View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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