ExcelBanter - microsoft excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - microsoft excel (https://www.excelbanter.com/excel-worksheet-functions/180641-microsoft-excel.html)

david h

microsoft excel

hi i have 200 tracking numbers a lot of them are repetitive how to i filter
them out

Pete_UK

microsoft excel

Debra Dalgleish explains how he

http://www.contextures.com/xladvfilter01.html

Scroll down to Filter Unique Records.

Hope this helps.

Pete

On Mar 19, 4:50*pm, david h <david
wrote:
hi i have 200 tracking numbers a lot of them are repetitive how to i filter
them out

Teethless mama

microsoft excel

In B2: =COUNTIF(A$2:A2,A2)1

copy down

Auto Filter all the TRUE values

"david h" wrote:

hi i have 200 tracking numbers a lot of them are repetitive how to i filter
them out

All times are GMT +1. The time now is 01:45 AM.