Excel show only rows with distinct values

dory550
dory550 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
please send the spreadsheet. it will be helpful to resolve this issue.

Author

Commented:
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
Commented:
Hi Dory,

Just select the item column (including the column header) in the advanced filter when filtering unique items.  As long as there are no blank columns Excel will execute command on all of the columns; i.e. if you filter to unique items and then sort the items the description and upc columns relationship is maintained.

Regards
Nero

Author

Commented:
Nero
It worked
Thanks for your help
Dory

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial