Forum Discussion
How to get the unique data from 1 column using the duplicates from another column
- Jun 01, 2022
SergeiBaklan I don't think it works as I want to and now I see that I didn't explained it well.
Basically I need to know which names in column A appear with the same number in column B and to somehow extract them or highlight them.
Like for example the first 4 names - Alfa and Beta have the same number in column B but Alfa500 is only one name with the same number in column B.
I need to know only if there is more than one name with the same number in Column B.
Does that make sense?
Thank you!
It could be
=COUNTIFS($B$2:$B$10,$B2) <> COUNTIFS($A$2:$A$10,$A2)
which gives
1234567 also has more than one name.
- Steiny88Jun 01, 2022Copper Contributor
SergeiBaklan
That works perfectly but I only pasted an example as I have 11k values below and didn't realize that the same name can appear with a different number (as in my file they are sorted with the numbers and not the names) where the formula should also check the other number if it has more than one name 😞 (didn't see that one coming) I've attached another example using the formula which you gave me and the results are True and should be False for A12:A15 and B12:B15 as the number 234 is appearing only for Alfa and 456 only for Beta.Thank you!
- SergeiBaklanJun 01, 2022Diamond Contributor
- Steiny88Jun 01, 2022Copper Contributor
Thank you so much! It works great. I suppose the numbers that it's giving me as result is how many times the criteria is met. I simply filtered without the zeros and I have the data I need to work with 🙂
Thanks again!