1 way using Array formula.
Formula:
IFERROR(INDEX('source data'!A$3:A$10000;SMALL(IF('source data'!$N$3:$N$10000="Non-Lagged";ROW('source data'!A$3:A$10000)-2);ROW('source data'!A1)));"")
-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
That's excellent, thank you!
May I please ask one more question:
If I were to sort this data, say in descending order of column M ("rel-ytd"), is there any way for the "n/a" results to appear at the bottom of the sorted table?
Thanks
You can sort the data in Sourse data sheet and then your results are as you need...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks