|
|
#2
07-30-2013, 02:35 PM
|
||||
|
||||
Interesting. Have you tried sorting the rows? I don't know whether that would take longer or not. If you can sort the data, then afterward you can change the countif to something like this in column B:
Code:
=IF($A2=$A1,$B1+1,1) 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Word Count | Richtriebe | Word | 1 | 04-20-2013 11:09 AM |
| Frequency of a name | bryant03 | Excel | 1 | 06-27-2012 10:21 AM |
| How to set frequency of Send?/Receive in Outlook 2010 | mikepla | Outlook | 4 | 11-03-2011 06:50 AM |
| How to count the frequency of data and also tally value from an array of Excel record | KIM SOLIS | Excel | 5 | 09-07-2011 09:01 AM |
 Count By Color
|
beb1227 | Excel | 4 | 06-15-2011 08:46 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode