I’m looking for an excel formula that will allow me to compare multiple values in different rows based on the value in the cell against each other.
I need the formula to look at for all the cells in column C, find the same ones, and compare the value in column B for all the same values in column C.
For example, I need the formula to look find that there are 6 same values that are Account 3 and compare the column B value and give me false if the value in column B are not the same.
Hope this made sense. I’ve been trying different if formulas to no avail. Thank you!