To find Multiple values in column B for a unique value in column A
 

Help!

Help if you can please!! Here's my problem, I'm trying to identify
multiple values in column B for a unique value in column A.

Column A Column B

100 5687
100 5687
100 5687
100 8569
100 8569
200 4544
300 8563
300 5686
300 1256

So in this example, I'm trying to find all the values in column B that
relate to the unique value of 100 in column A.

Thanks for your help!

Cheers
Chris

To find Multiple values in column B for a unique value in column A
 

Do you want to just highlight them, or extract them? Once-off, or regularly
updated?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"kishdaba" wrote in message
oups.com...
Help!

Help if you can please!! Here's my problem, I'm trying to identify
multiple values in column B for a unique value in column A.

Column A Column B

100 5687
100 5687
100 5687
100 8569
100 8569
200 4544
300 8563
300 5686
300 1256

So in this example, I'm trying to find all the values in column B that
relate to the unique value of 100 in column A.

Thanks for your help!

Cheers
Chris

To find Multiple values in column B for a unique value in column A
 

Hi,

Have you tried "Auto Filter" for this? I guess that might help you.


Hope that helps,

Thankyou,

Shail


kishdaba wrote:
Help!

Help if you can please!! Here's my problem, I'm trying to identify
multiple values in column B for a unique value in column A.

Column A Column B

100 5687
100 5687
100 5687
100 8569
100 8569
200 4544
300 8563
300 5686
300 1256

So in this example, I'm trying to find all the values in column B that
relate to the unique value of 100 in column A.

Thanks for your help!

Cheers
Chris