Do you have a list somewhere in an XL sheet that contains a unique list of
you account numbers?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"AndersonsWorks" wrote in message
...
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?