repeating values


A

awmiranda

Hi,
Please help.
I have a colun with repeating values, a second column that counts
these repeating values; formula is (=countif($a$1:$a$4000,a1). I am
looking for a third column that can then identified the repeating
values uniquely in column A or B.
Let me demonstrate in an example. (Note that I don't know how to
calculate column C, it's what I would like to achive. It would then
help me sort for only values of 1 in column C)

A B C
A005 2 1
A005 2
A006 2 1
A006 2
A009 4 1
A009 4
A009 4
A009 4

I hope to find the formula for column C.

thanks.
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

repeating values 1
repeated value 8
repeated values 1
repeated numbers or value 2
Counting repeated values 1
Autofill - repeating values 3
maximum repeated value 2
find repeating values 6

Top