I want to calculate the total number of cells with the same name from H6:H50, every cell repeated with the same name would be counted as 1, such as :
H6=APPLE
H7= APPLE
H8=APPLE
H9= BANANA
H10=APPLE
H11= BANANA
H12=MANGO
APPLE+BANANA+MANGO=3
Every name would only be counted as 1, the formula would identify the name as data, so that space or uppercase differences wont affect the result.
Bookmarks