OK...I need to look at a range of cells and pull over any row that has a "v" in the column.
Auction.xlsx
On the Auction sheet anything that is marked with a "v" in column C is a special item that needs to go to another page for a summary.
I need the "674 Summary" tab to pull any items that are marked with a "v". I need the entire row of information for each item to be pulled.
It is effectively a filter...but it needs to be on its own summary page.
In A1 of SUMMARY674, put this ARRAY(Confirm using Control+Shift+Enter-Not just Enter) formula.
Copy down and across.
=IFERROR(INDEX(Auction!A$3:A$100,SMALL(IF(Auction!$C$3:$C$1000="v",ROW(Auction!A$3:A$100)-2),ROW(Auction!A1))),"")
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 worked...reps!
Welcome.
Thanks for reb *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks