Reputation
6,601
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 9 23
Newest
 Reviewer
Impact
~502k people reached

9h
comment In excel, I want the word “Name” to display but not print
That's a neat trick!
21h
answered How to get Ctrl+Shift combination for Excel macro shortcut?
1d
comment Excel. Looking for exact match and return value
Please don't ask a new question in a comment. If you have a new question, ask a new question.
1d
comment Excel. Looking for exact match and return value
My formula says $A$1:$H$1000, not $A$1:$A$1000. Why don't you start with the formula I supplied and just change the file and sheet name? Every other change you make will be likely to break the formula.
1d
comment Excel. Looking for exact match and return value
I don't think you can use whole columns in Excel 2007 for Vlookup. Try to use a range with a limited number of rows. 8 instructs to return the value from the 8th column of the table (column H) and False is the instruction for an approximate match. You want an exact match, so the parameter needs to be False.
2d
answered Excel. Looking for exact match and return value
2d
answered Excel: Ctrl+Shift+F does nothing
May
23
revised How to auto fill increasing values between existing filled cells
added 461 characters in body
May
23
comment How to auto fill increasing values between existing filled cells
Did you test this? Where are the ascending numbers? All results are zero.
May
23
answered How to auto fill increasing values between existing filled cells
May
23
revised Excel 2011 for Mac/ Pivot table / tabular layout how to “fill down?”
added 92 characters in body
May
23
answered Excel 2011 for Mac/ Pivot table / tabular layout how to “fill down?”
May
21
awarded  Reviewer
May
21
comment Multiplying Two Cells Returns Zero
@YSilber, can you share the file on a file sharing site?
May
21
comment Multiplying Two Cells Returns Zero
@EngineerToast, even if one or more values are text, the multiplication will coerce them into numbers and the result will not be a 0.
May
21
reviewed Approve Multiplying Two Cells Returns Zero
May
21
comment Excel: How to show top 3 “winners” by age and gender?
I added a link to a sample file.
May
21
comment How to automatically make copies of columns in Excel?
Power Query is still the best way to go (as far as I'm concerned). It's a free download from Microsoft and it is very powerful to connect to data sources and re-shape your data to your requirements. I added a download link to my post.
May
21
revised How to automatically make copies of columns in Excel?
added 220 characters in body
May
21
answered How to automatically make copies of columns in Excel?