I have a simple Excel spreadsheet with just names, account numbers,
and card numbers.

I only want to view the names that occur more than once to see who has
multiple accounts. Basically, the opposite of a "Unique values only"
check box.

How would I go about doing this?

Any help is appreciated.

Show certain rows??????

I'd use another column and a formula like:

=countif(a2:a999,a2)
and drag down.

Then filter to show the values larger than 1.

Woda wrote:

I have a simple Excel spreadsheet with just names, account numbers,
and card numbers.

I only want to view the names that occur more than once to see who has
multiple accounts. Basically, the opposite of a "Unique values only"
check box.

How would I go about doing this?

Any help is appreciated.

--

Dave Peterson