hi there,
i'm trying to take a table of disjointed data, and segregate the 'true' items into 1 final condensed table; hopefully in order or their appearance in the original.
the final table would make a better reference using vlookup, etc.
excel 2010 btw.
an example is in the attachment; i'd like to get the final yellow table to reference. here it is copy & pasted in txt..not sure if the spaces are going to process accordingly in the thread...
A B C D
1| produce variety color
2| =if(color)="red", True, false
3| Apples mcintosh red TRUE
4| Apples gala red & white FALSE
5| Apples grannysmith green FALSE
6| Apples red delicious red TRUE
7|
8| =if(color)="yellow",true,false
9| Corn Taber yellow TRUE
10| Corn Maize multi FALSE
11| Corn Sweet yellow TRUE
12| Corn Peaches & cream yellow TRUE
ref table - red & color produce ("Trues")
Mcintosh Apple red
Red Delicious Apple red
Taber Corn yellow
Sweet Corn yellow
Peaches & Cream Corn yellow
how would i get this final table condensed down; then i can use hlookup, or index, etc.?
thanks for any input; and eat your vegetables - they're good for you!
Bookmarks