If your general ledger account numbers are in a column, first make sure the
column has a header cell at the top. Select the header cell and pull-down:

Data Filter Advanced Filter... and check unique records only

This will remove duplicates. Just take any 60 of the resulting items.

Good Luck
--
Gary's Student


"AndersonsWorks" wrote:

I have over a 1000 general ledger account number from which I need to select
a sample of 60 unique numbers. The only option my co-workers and I can find
in Excel uses replacement and we end up with duplicates. Does anyone know a
solution?