I'm attempting to count unique values of account numbers, where notes contain "Canceled" with the array in T but it only gives 0 even with CTRL+SHIFT+ENTER
No clue whats wrong
Please Login or Register to view this content.
I'm attempting to count unique values of account numbers, where notes contain "Canceled" with the array in T but it only gives 0 even with CTRL+SHIFT+ENTER
No clue whats wrong
Please Login or Register to view this content.
Last edited by ZENITH; 08-10-2011 at 02:38 PM. Reason: Solved
try:
CSE confirmedPlease Login or Register to view this content.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
That works, but why does my formula work on some sheets but not others?
Maybe coincidence ??
I don't know, this stuff is confusing me today. Do you know how I would count unique NOT equal to Canceled and Pending and " " and ""?
I tried using an OR but it didn't work.
Please Login or Register to view this content.
Try:
orPlease Login or Register to view this content.
either CSE confirmed.Please Login or Register to view this content.
First one worked, second didn't. Thanks! A little excessive coding but it works and helps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks