S
SiH23
I would be most grateful if someone could offer me some help.
I need to count the number of unique values within a column range. Each
value consists of a series of alpha and numberical characters.
I have used the formula below but it keeps crashing my spreadsheet:
=SUMPRODUCT((1/COUNTIF(A1:A5,A1:A5&"")))
Any help or advice would be greatly appreciated.
I need to count the number of unique values within a column range. Each
value consists of a series of alpha and numberical characters.
I have used the formula below but it keeps crashing my spreadsheet:
=SUMPRODUCT((1/COUNTIF(A1:A5,A1:A5&"")))
Any help or advice would be greatly appreciated.