|
|
#2
10-11-2014, 06:53 PM
|
|||
|
|||
Counting distinct items
I have a solution for your question - I think?
I'll have to open your file that you included to observe. Basically I had the same issue and solved it with nested IF's and AND statements. There may be other shorter methods but this worked for me. To clarify, you prefer to solve via Excel and not VBA - correct? Thanks, Sgt Rock (Mort, like the salt) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula to count entries as per month, year and submission wise from different sheets | pinkacidpunk | Excel | 1 | 05-28-2013 08:26 AM |
| Clipboard - old entries | whipwell | Office | 1 | 11-14-2012 02:18 AM |
 formula taking long time to distinct word
|
gsrikanth | Excel | 2 | 03-18-2012 03:30 AM |
| colour of entries | ntambomvu | Outlook | 0 | 03-15-2012 11:56 PM |
| Autocorrect entries with astrix at the end | dswapp | Word | 2 | 02-14-2011 09:34 AM |
Windows 8 
Office 2010 64bit
Threaded Mode