View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roadkill roadkill is offline
external usenet poster
 
Posts: 173
Default List of Contents by Criteria

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.