The blue section in this example sheet feeds prices externally.
Table to Table.xlsx
I want to create tables of each team where the Conditions column is TRUE.
Not sure how to go about it?
Many Thanks
The blue section in this example sheet feeds prices externally.
Table to Table.xlsx
I want to create tables of each team where the Conditions column is TRUE.
Not sure how to go about it?
Many Thanks
Do you mean?
In G14 and copy down and across, this ARRAY formula.
=IFERROR(INDEX(A$2:A$100,SMALL(IF($D$2:$D$100=TRUE,ROW(A$2:A$100)-1),ROW(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.
Hi beat,
This has a simple Advanced Filter solution.
http://www.contextures.com/xladvfilter01.html
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I cant use advanced filter because its externally updating and changing
Fotis the red table need to be all arsenal
That formula dragged down doesnt do that
Basically I want to create a table for each team using functions and where the condition is true
A ha..Ok. But this one does....Fotis the red table need to be all arsenal
That formula dragged down doesnt do that
=IFERROR(INDEX(A$2:A$100,SMALL(IF($A$2:$A$100&$D$2:$D$100="ARSENAL"&TRUE,ROW(A$2:A$100)-1),ROW(A1))),"")
Your a Hero
........................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks