Recent content by AnotherHiggins

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.