Reputation
6,137
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
2 15 36
Newest
 Yearling
Impact
~1.8m people reached

Apr
2
revised Find last row in sorted table for matched value
added corrections to formula
Apr
2
comment Find last row in sorted table for matched value
@Moses Yep, just enter it in the first cell under Last_Match_Date (using Ctrl+Shift+Enter) then copy it down to the other cells. You were getting the error because you replaced A2 (or the lookup value) with another array not parallel to the arrays in the formula.
Apr
1
revised Find last row in sorted table for matched value
added 218 characters in body
Apr
1
answered Find last row in sorted table for matched value
Apr
1
comment Why do I get an #REF! error after sorting?
Are you running Excel 2003 or below?
Apr
1
revised Merge Excel rows from two sheets
OP modified question, had to update answer
Apr
1
comment Merge Excel rows from two sheets
@Khaloymes Edit your question with methods/formulas that you have already tried.
Apr
1
answered Merge Excel rows from two sheets
Apr
1
answered Is there a way to automate cell merging in excel?
Mar
31
reviewed Close 750Gig Hard Drive shows full with only 315Gigs used
Mar
31
reviewed Leave Open Are USB drives as reliable as SATA
Mar
31
reviewed Leave Open CPU hitting 100% when flash or game is running after dropping laptop
Mar
30
reviewed Leave Open Which tool can display historical CPU usage (for the last minutes, hours)
Mar
30
reviewed Close Can I add my own books to Kindle for PC and have them sync with my Andoid phone?
Mar
30
reviewed Leave Open Laptop detects HDMI connection but won't display anything
Mar
30
reviewed Leave Open Windows 7 won't open any program
Mar
26
comment How to conditionally create a hyperlink based on value of a cell
@gm2 I think you're misunderstanding the OP's question. Excel is creating a "phantom" hyperlink even if you don't mean to.
Mar
26
reviewed Reject How do I get VLC to play on the second monitor on windows?
Mar
26
reviewed Close How do I prevent vlookup returning 0 for values that are blank in the lookup data?
Mar
26
reviewed Leave Open Restrict Bandwidth by IP