List of Contents by Criteria
In C30, use something like:
=if(e6="qualified",c6,"")
and copy down
Regards,
Fred
"RoadKill" wrote in message
...
Hello,
I would like to have a list of items that meet a certain criteria
displayed
on a separate area of my spreadsheet.
To elaborate, if anyone in cells E6:E26="Qualified", then the contents of
Cells C6:C26 should be listed in C30:C50. And obviously if they are not
Qualified, they would not be listed in C30:C50.
Thanks for your help.
|