Hi
I want to count the unique items in a list and to do this I have the formula
Please Login or Register to view this content.
My question is this if I have 'a!" it is counted as an Item to be counted, but if I change the ! to an asterisk
I get a fraction, so if my count is 4 with an "a" make it a "a!" I get 5 but if i change to "a*" I get 4.2 ?
Can someone explain what the asterisk is doing? I've attached work book with example, just change ! to *.
Richard.
Bookmarks