List of Contents by Criteria

  • Thread starter Thread starter RoadKill
  • Start date Start date
R

RoadKill

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.
 
What I would like though is if the cell does not qualify, it should be left
out of the results instead of giving a blank cell.

Thanks
 
You'll need to explain what you mean by "left out of the results" because
something has to be specified if the if statement is not true (or Excel
assumes FALSE which I'm sure you don't want).

Regards,
Fred
 
Back
Top