D david h Mar 19, 2008 #1 hi i have 200 tracking numbers a lot of them are repetitive how to i filter them out
P Pete_UK Mar 19, 2008 #2 Debra Dalgleish explains how here: http://www.contextures.com/xladvfilter01.html Scroll down to Filter Unique Records. Hope this helps. Pete
Debra Dalgleish explains how here: http://www.contextures.com/xladvfilter01.html Scroll down to Filter Unique Records. Hope this helps. Pete
T Teethless mama Mar 19, 2008 #3 In B2: =COUNTIF(A$2:A2,A2)>1 copy down Auto Filter all the TRUE values
