List of Contents by Criteria

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.
 
F

Fred Smith

In C30, use something like:
=if(e6="qualified",c6,"")
and copy down

Regards,
Fred
 
R

RoadKill

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
 
F

Fred Smith

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count non blank cells which meet criteria in another column 2
Extract multiple records matching criteria from list 12
Using SUMIF to exclude mulitple criteria 4
Lookup come list 8
appending data to individual cell throug function 2
Use a multiplier to change List Prices to Net prices 1
Creating a function to randomize a list of alphanumeric entries in an array 5
Sum based on multiple conditions 2

Top