Thanks to everyone. Problem solved.


"T Harris" wrote in message
...
Using 75 cells down begining with A1 and B1, I have random number between
1-75 in B column and corresponding letters of the word BINGO to appear
accordingly in the A column. Thanks to three people in this forum, this
is working. Now when I hit F9, the BINGO results are displayed in the
first 75 rows of the A and B columns.

Now, how do I filter the 75 results to weed out duplicates like "B12"?
(OR another solution which may be the best is) How do I generate the 75
unique solutions so that no duplicates appear in the first place? If
anyone has an answer to either question, I would appreciate it very much.
I tried ADVANCED FILTER and could not get it to work and output my unique
results to another location. Thanks.

T Harris