I have two columns of data like this:
Batch PO
A 4500202477
B 4500159684
B 4500171273
B 4500171273
C 4500208603
C 4500208603
C 4500208603
...
I want to add a third column that lists how many DIFFERENT PO#s are listed for each Batch No.
For example, I'd like for this new column to show "1" for each row of batch A, "2" for B, and "1" for C (because all those PO#s are the same).
Of course the numbers will repeat, I just need a quick way of seeing which batches had more than one PO assigned to them.
I'd post some of my failed attempts at a function but they're too embarrassing!
Bookmarks