I am trying to find a way to get Excel to take a range of cells and find out if ANY of those cells match any other cells in that range. So far, all I can find is to determine if any in that range matches a specific cell or criteria given. But I want it to be able to just find out if there are any matches. So, a column that is, say, 109, 100, 57, 83, 2, 100, 86, 82 would result in TRUE, or maybe a 1 if that is how I could set it up. Either way, it would just let me know that the criteria has been met because there are two 100s in the range.
I'm thinking I cold do a long convoluted nested COUNTIFS formula, using one of each cell, but is there a simpler way to do this? If the range is 50 cells, I don't want to make 50 ranges and criteria in the COUNTIF formula. I know I could manually check it by doing a conditional formatting on the range, having it highlight cells that are matching, and then underneath the range manually put a 1 or whatever whenever there is a highlighted cell. But is there a way to make that conditional formatting do it for me?