jeudi 13 août 2020

EXCEL: Check if value in cell has more than one value under it in adjacent row

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