Reputation
1,558
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
9 32
Impact
~128k people reached

Jul
21
comment Comparing columns in two different excel sheets and if they match copying third column
Why use the EXACT function instead of, for example, =IF(AND('F1'!A1='F2'!A1,'F1'!B1='F2'!B1),'F2'!F1)? It's shorter and there is no need for a case sensitive match here.
Jul
21
answered Comparing columns in two different excel sheets and if they match copying third column
Jul
21
comment vlookup in a cell that contains mid formula
It shouldn't make a difference whether the cell targeted by the VLOOKUP contains a formula or a fixed value. Can you describe what is in columns B and C on the LOCATION LOOKUP TABLE sheet and what is in cell F57?
Jul
2
awarded  Curious
Jun
14
awarded  Yearling
May
26
comment How to dynamically populate a filter list with “first match” on a row, using excel 2007
What should it return when it finds a match?
May
18
revised How to override the CSS of a site in Firefox with userContent.css?
code formatting
May
18
reviewed Reviewed Thinkpad Edge E430 slowed down to a crawl
May
18
suggested rejected edit on Is there a Linux tool for changing DOS/Windows file attributes?
May
18
suggested approved edit on How to override the CSS of a site in Firefox with userContent.css?
May
14
answered Map network drive for the SYSTEM user in Windows
May
8
comment Averageing numbers in a column while ignoring rows with headers
You might be right. We'll let Jack83 tell us which one he meant.
May
8
comment Averageing numbers in a column while ignoring rows with headers
I may be wrong, but I think the question is asking how to average cells based on whether a separate column is empty, based on the title which says "while ignoring rows with headers".
May
8
answered Averageing numbers in a column while ignoring rows with headers
May
7
comment Empty “notify” file being created on external hard drive
@Hans No, I was not able to figure it out. I tried Process Monitor but I wasn't able to capture the program that created the file. Are you having the same problem?
May
4
revised Jump Lists not showing for Office programs in Windows 7
added 73 characters in body
May
4
comment Jump Lists not showing for Office programs in Windows 7
@magicandre1981 Yes. SP1 and all of the latest updates are installed for Office 2013.
May
3
awarded  Custodian
May
3
reviewed Reviewed MSN Messenger Password Recovery on Windows XP
May
3
asked Jump Lists not showing for Office programs in Windows 7