|
|
|
|
#1
02-08-2015, 12:49 PM
|
||||
|
||||
Sorry, I didn't understand what you needed.
Perhaps add a 4th column called "batch". Enter 1 in D2 and Code:
=IF(AND(A3=A2,B3=B2),D2,D2+1) Apply a PT to these four columns and move the "batch" to the first column in the PT. That should do the trick
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How do you count how often a specific value occurs in single changing cell?
|
blackjack | Excel | 12 | 09-03-2014 10:41 AM |
|
HELP -- Drop Menu for Reoccuring Data??
|
cscaudle | Word | 1 | 03-02-2014 10:19 AM |
|
Highlight only the characters ER when it occurs in SEVERE.
|
norgro | Word VBA | 3 | 02-18-2013 05:14 PM |
|
count how many tims a certain value occurs
|
lucnijs | Excel | 6 | 03-26-2012 09:29 AM |
| 34 Rminders for reoccuring appointments | rgarneau | Outlook | 6 | 01-13-2012 10:04 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode