Yes. The list of 1000 acct numbers is a list of 1000 unique acct numbers.
Each time XL selects a sample item it is selecting from the population of
1000. I need it to ignore the sampled item. To restate: with each item
selected for the sample, the population from which to select the next sample
is less one.

The first sample is selected from the 1000 accts. The next sample from 999
accts. The next from 998 accts. It's called sampling without replacement.

Any thoughts, anyone?
Thanks!

"RagDyer" wrote:

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?