Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List of Contents by Criteria
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 "Fred Smith" wrote: 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. . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List of Contents by Criteria
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 "RoadKill" wrote in message ... 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 "Fred Smith" wrote: 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query criteria based on a changing criteria list | Excel Discussion (Misc queries) | |||
Excel cell contents to query criteria | Excel Discussion (Misc queries) | |||
Display contents of cell based on criteria | Excel Worksheet Functions | |||
How do I specify cell contents for the Criteria in SUMIF? | Excel Worksheet Functions | |||
Finding cell contents based on certain criteria | Excel Discussion (Misc queries) |