I don't know if its possible to do this in Excel. My worksheets has clients with duplicate rows. I'm attempting to tally the number of clients without counting them more than once.
i.e.:
client a
client a
client a
client b
client b
client c
total client: 3 instead of 6
Thanks in advance for your help.
Rob
i.e.:
client a
client a
client a
client b
client b
client c
total client: 3 instead of 6
Thanks in advance for your help.
Rob