Gary's Student suggestion hid those duplicates.

If you copy|paste and got duplicates, you can copy just the visible cells by:
selecting the range you want
edit|goto|special|visible cells only

Then copy and paste.

AndersonsWorks wrote:

That's a good one that I'll need to remember, but doesn't address my problem.
The sample is 60. This means that I tell Excel to select 60. And the
resulting 60 may have only 40 unique items. I need the whole sample to be
unique.

Thanks for you help, tho.
Amy

"Gary's Student" wrote:

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?

--

Dave Peterson