Hi all,
I have a range of cells which contain personal ID numbers. The range goes from column A1:E500. I hightlight the range and the select the 'conditional format' function of 'Highlight Dulipcates'. It finds and highlights 26 duplicate values across the range. I only know its 26 because I've had to scroll through and manually count the highlight cells which the conditional format has found. My question is this... Is there a formula that will count the number of highlightes cells for me?... It's annoying that I have to count by hand from a spreadsheet and I'm sure there must be away round this. Greatful as always Cris
I have a range of cells which contain personal ID numbers. The range goes from column A1:E500. I hightlight the range and the select the 'conditional format' function of 'Highlight Dulipcates'. It finds and highlights 26 duplicate values across the range. I only know its 26 because I've had to scroll through and manually count the highlight cells which the conditional format has found. My question is this... Is there a formula that will count the number of highlightes cells for me?... It's annoying that I have to count by hand from a spreadsheet and I'm sure there must be away round this. Greatful as always Cris
Last edited: