Counting and duplicates
Hi,
I have a column of numbers with duplicates. so the numbers might be A1 = 33, A2=1221, A3=4, A4=4, A5=4, A6=8392,.... I want to display the numbers without the duplicates - in column B. Do you know how to do this? Thanks for your help. |
Counting and duplicates
The Advanced Filter can be used. Check 'Unique records only'.
Otherwise, by formula... 1) Leave B1 empty 2) Enter the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER, in B2 and copy down: =INDEX(A1:A$6,MATCH(TRUE,ISNA(MATCH(A1:A$6,B$1:B1, 0)),0)) To trap errors, try the following instead... =IF(OR(ISNA(MATCH(A1:A$6,B$1:B1,0))),INDEX(A1:A$6, MATCH(TRUE,ISNA(MATCH(A 1:A$6,B$1:B1,0)),0)),"") Hope this helps! In article , Jeff wrote: Hi, I have a column of numbers with duplicates. so the numbers might be A1 = 33, A2=1221, A3=4, A4=4, A5=4, A6=8392,.... I want to display the numbers without the duplicates - in column B. Do you know how to do this? Thanks for your help. |
All times are GMT +1. The time now is 10:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com