Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
Excel show only rows with distinct values
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
8/22/2022 - Mon
please send the spreadsheet. it will be helpful to resolve this issue.
Here it is:
Columns B,C & D
I need to view only rows with disticnt Item# (column B)
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
Log in or sign up to see answer
Become an EE member today
7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
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.
See how we're fighting big data
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
Thanks for your help
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!
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent