Reputation
2,004
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
1 12 33
Impact
~184k people reached

Jul
22
comment Count Unique Cells Matching Results in Set
@mrwweb Good point. I updated my answer, let me know what you think of this solution.
Jul
22
revised Count Unique Cells Matching Results in Set
made more scalable
Jul
21
answered Count Unique Cells Matching Results in Set
Jul
21
revised Copy from sheet2 to sheet1 based on if values match
formatting
Jul
21
answered Copy from sheet2 to sheet1 based on if values match
Jul
21
suggested approved edit on Copy from sheet2 to sheet1 based on if values match
Jul
21
answered Excel filter duplicate values in column A and filter out rows which have column C blank
Jul
21
answered Why do video streaming services buffer when I plug in my headphones?
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.