Sorry, I tried my best to frame my question in the title! But here's what I'm trying to do:
I have an excel sheet of two columns, A and B. I am trying to check if a value underneath A has two or more values underneath it in B. See below:
A B
France Paris
France Paris
France Nice
California Los Angeles
California Los Angeles
Japan Tokyo
Japan Tokyo
In here, I am trying to report back that France is a value in column A that has more than one value in B. How do I write a comparison formula in Excel that will allow me to do this?
I thought about doing something along the lines of doing VLOOKUP to report back the first row (France --> Paris, California --> Los Angeles, Japan --> Tokyo), and if the value in B does not equal the value in the first row, report that back to me.
Ex. in C4, it's supposed to anticipate Paris but a conditional will throw False since it's equal to Nice.
TIA!
Aucun commentaire:
Enregistrer un commentaire