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!

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

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.