Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Lookup
I am a sheet that looks like:
2/17 2/18 2/19 2/20 2/21 2/22 Sue A A A A Sally P P P Peter A Mary A P P P Pat A A A Marie A A A Liz P P P Marjorie P P P P On a second sheet I want to list the names of the people who have an "A" or "P" such as: 2/17 - A 217 - P 2/18 - A 218 - P 2/19 - A 2/19 - P 1 1 1 1 1 1 2 2 2 2 2 2 3 3 3 3 3 3 4 4 4 4 4 4 5 5 5 5 5 5 Thanks for any help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Lookup
On Jan 31, 5:41*pm, Tracey wrote:
I am a sheet that looks like: * * * * 2/17 * *2/18 * *2/19 * *2/20 * *2/21 * *2/22 Sue * * A * * * A * * * * * * * A * * * A * * * Sally * * * * * * * * * P * * * * * * * P * * * P Peter * * * * * * * * * A * * * * * * * * * * * Mary * *A * * * * * * * P * * * P * * * P * * * Pat * * A * * * A * * * A * * * * * * * * * * * Marie * * * * * A * * * A * * * A * * * * * * * Liz * * P * * * * * * * * * * * * * * * P * * * P Marjorie * * * *P * * * P * * * * * * * * * * * P * * * P On a second sheet I want to list the names of the people who have an "A" or "P" such as: * * * * 2/17 - A * * * *217 - P 2/18 - A * * * *218 - P 2/19 - A * * * *2/19 - P * * * * 1 * * * 1 * * * 1 * * * 1 * * * 1 * * * 1 * * * * 2 * * * 2 * * * 2 * * * 2 * * * 2 * * * 2 * * * * 3 * * * 3 * * * 3 * * * 3 * * * 3 * * * 3 * * * * 4 * * * 4 * * * 4 * * * 4 * * * 4 * * * 4 * * * * 5 * * * 5 * * * 5 * * * 5 * * * 5 * * * 5 Thanks for any help! if you want count, try countif function. joe |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Lookup
My message was a little unclear......
One sheet looks like this: 2/17 2/18 2/19 2/20 2/21 2/22 Sue A A A A Sally P P P Peter A Mary A P P P Pat A A A Marie A A A Liz P P P Marjorie P P P P I want to pull the info across so that a second sheet ends up with the names of people who have an "A" or "P" and therefore give me a this: 2/17 - A 2/17 - p 2/18 - A 2/18 - P 2/19 - A 2/19 - P Sue Liz Sue Marjorie Peter Sally Mary Marjorie Pat Pat Mary Pat Marie Marie Thanks Again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting using lookup | Excel Discussion (Misc queries) | |||
Conditional Lookup | Excel Discussion (Misc queries) | |||
Conditional Lookup? | Excel Worksheet Functions | |||
Conditional Lookup Functions | Excel Worksheet Functions | |||
conditional lookup | Excel Worksheet Functions |