microsoft excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

david h - 19 Mar 2008 17:50 GMT

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

Reply to this Message

Pete_UK - 19 Mar 2008 18:10 GMT

Debra Dalgleish explains how here:

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 h...@discussions.microsoft.com>
wrote:

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

Reply to this Message

Teethless mama - 19 Mar 2008 18:13 GMT

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

copy down

Auto Filter all the TRUE values

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

Reply to this Message