Filter function

[Ian]

I have a column as below:

Lot code
43397
42287
42287
43279
42287
43397

Is there a function that will allow me to list each lot
code used in the table? Or do I have to use code? The
result should look like this:

43397
42287
43297

Thanks

Ian

 

[Mike]

Use [Data]-->[Filter]-->[Advanced filter] feature to get such a unique list.

 

[Ken Wright]

And Debra Dalgleish has some great instructions with piccies on her website to show you how:-

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

Just look at the Filter Unique Records section