Search results for query: *

What version of Excel are you using? In 2007 and later you could just use SumIfs. =SUMIFS(M:M,B:B, "11_22", L:L, 303, M:M, ">=" & 1) (Not entered as an array formula) That'll be much simpler going forward. To add your second criteria, just add two formulas together to make a longer formula...

The criteria for your Conditional Format will be a formula: <=today() + 7 (The Now function includes the time. Today just returns today's date) -John [tab]The plural of anecdote is not data Help us help you. Please read FAQ 181-2886 before posting.

Huh? How [/i]do[/i] you expect to do it if not with any programming system and not with keystrokes? Do you mean you want to create a dynamic link to the other cell? What results would you expect to see in cell A3 on Sheet 1: 3 or 7? -John [tab]The plural of anecdote is not data Help us help...

It sounds to me like you're describing Aero Snap, which is a feature of Windows 7, not Office. This page should walk you through disabling it. -John [tab]The plural of anecdote is not data Help us help you. Please read FAQ 181-2886 before posting.

I think we talked about this a long time ago, KJV. FYI: Double clicking the Office Button will close the application, regardless of how many workbooks you have open. I know it's not the red X, but it works out of the box. -John [tab]The plural of anecdote is not data Help us help you. Please...

I don't think it's anyone trying to sound smart so much as it's yet another military euphemism that's meant to avoid upsetting the populace. Instead of killing one of our own soldiers, we have "friendly fire incidents". Instead of slaughtering innocent civilians including women and children...

Not without a macro. But, as long as the selection isn't too complex (meaning made up of too many separated pieces), you can just copy and paste. Excel will, by default, only copy the visible cells. -John [tab]The plural of anecdote is not data Help us help you. Please read FAQ 181-2886...

The "etc." leads me to suspect that there are several options in the dropdown. What you want isn't a series of nested IFs (which is limited to only 7 nested statements in XL 2003 anyway), but rather a VLookup. Search Excel's help file for "VLookup". Let us know if you need assistance...

Without any VBA: In Excel (not Access), Go to Data > Get External Data > Access Browse to find the file Select the Table you're after I've brought in several few hundred thousand records in one shot. -John [tab]The plural of anecdote is not data Help us help you. Please read FAQ 181-2886...

Here's an edited copy of your file that I used for testing to be sure this produced identical results to what you already had. -John [tab]The plural of anecdote is not data Help us help you. Please read FAQ 181-2886 before posting.http://www.mediafire.com/?eq46xy4v5sn4z4r

Sorry about the delay - I got sidetracked. These silly people at work expect me to, you know, work. The nerve of some people. [wink] I'd probably just use a Dynamic Named Range. Try this (If you're in Excel 2003 or before, your menu paths will differ): Select Range C2 It is [!]critical[/!]...

Macro question best fit in forum707. If you need help with a macro, please repost your question there. BUT you don't need a macro for this. I'll write up some thoughts and post back in a few minutes. -John [tab]The plural of anecdote is not data Help us help you. Please read FAQ 181-2886...

Yes! Most of us around here would use a SumProduct formula to accomplish that. It's quite simple once you understand how to read it and has the benefit of not having to be entered as an Array Formula. Plus it's quite a bit shorter than what you have above. [tab]=SumProduct( --($A$1:$A$1000 =...

I never used that menu item in earlier versions, but maybe this is what you're looking for? Go to the Office Button > Prepare > Properties That allows you to see the location of the file (at the right) as well as edit various properties such as Author. -John [tab]The plural of anecdote is not...

Oh, also.... If you just hover your cursor over the file in the Recent Files list a pop up will appear showing the full path of the file. -John [tab]The plural of anecdote is not data Help us help you. Please read FAQ 181-2886 before posting.

Just go to Save As and note the folder structure. -John [tab]The plural of anecdote is not data Help us help you. Please read FAQ 181-2886 before posting.

I do see a separate RAID configurations screen during boot up - after the MoBo splash screen and before Windows starts to load. But once I'm in Windows and go to Disk Management it shows two different drives. and only intermittently shows those. I sometimes have to Rescan Disks before they show...

You don't specify what the problem is if the date difference is greater than 2 days - what are you seeing that you don't expect to see?? First, why would you "take out the date"? Aren't you trying to figure how many total hours have passed? If you're putting the formula into a cell on the...

I recently bought two 2TB internal HDDs to replace a couple of aging 500GB drives. It's hard to believe that what I'm trying to do is uncommon, but nearly all of the results I find in Google deal with trying to add the an existing non-RAIDed boot drive into a RAID without wiping the boot drive...

Pivot Tables are a great way to summarize the data, but for placing the totals on the same sheet as in your example, SumIf is the formula you want. Side note (and the reason I'm bothering to post): Place your totals at the TOP of the data, not the bottom. And Freeze Panes so that the column...