Avatar of dory550
dory550
 asked on

Excel show only rows with distinct values

Hi Guys
I am using Excel 2003
I have a spread sheet with duplicate values in column B
How can I view only rows with distinct values in column B?
I tried Data->Filter->Advanced but couldn't make it work
Thanks
Dory
Microsoft Excel

Avatar of undefined
Last Comment
dory550

8/22/2022 - Mon
Mani Jaganathan

please send the spreadsheet. it will be helpful to resolve this issue.
dory550

ASKER
Here it is:
Columns  B,C & D
I need to view only rows with disticnt Item# (column B)
Thanks
Dory


   B                C                                                             D
 ITEM#     DESCRIPTION                                        UPC
15967      CLUBMAN AFTER SHAVE LOT  6 OZ        7006604030
67140      CLUBMAN STYLE GEL REG 16 OZ          7006602792
15969      CLUBMAN TALC 9 OZ                      7006602760
66606      POWER STICK A/P 1.65Z COOL BLST      85024100053
66606      POWER STICK A/P 1.65Z COOL BLST      5024100053
66607      POWER STICK A/P 2OZ HURRICANE        85024100096
66607      POWER STICK A/P 2OZ HURRICANE        5024100096
3547      POWER STICK SH/GEL COOLBLST 12Z      85024100004
3547      POWER STICK SH/GEL COOLBLST 12Z      5024100004
3443      POWER STICK SH/GEL IGNITION 12Z      85024100014
3443      POWER STICK SH/GEL IGNITION 12Z      5024100014
3165      POWER STICK SH/GEL INTENSTY 12Z      85024100088
3165      POWER STICK SH/GEL INTENSTY 12Z      5024100088
13635      AAAA ALCOHOL ISOPROPYL 50% 12 Z      71525690021
13635      AAAA ALCOHOL ISOPROPYL 50% 12 Z      1525690021
13667      AAAA ALCOHOL WNTRGREN 50% 12 OZ      71525690027
13667      AAAA ALCOHOL WNTRGREN 50% 12 OZ      1525690027
61098      QLTY EPSOM SALTS 1 LB                71525620002
61098      QLTY EPSOM SALTS 1 LB                1525620002
11984      FAULT EAR SYRINGE                    30074283800
ASKER CERTIFIED SOLUTION
Nero74

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
dory550

ASKER
Nero
It worked
Thanks for your help
Dory
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes