Hi all,
I need to count fields in excel that contain numbers and text... e.g
Column A:
6742-1-109
3345-7-521
65-8459
6742-1-109
The number of unique fields above would be 3.
Countif function only seems to work with numbers. What can I use instead??
Thanks a lot.
Owen
I need to count fields in excel that contain numbers and text... e.g
Column A:
6742-1-109
3345-7-521
65-8459
6742-1-109
The number of unique fields above would be 3.
Countif function only seems to work with numbers. What can I use instead??
Thanks a lot.
Owen