R
RFJ
I've got a 2000 row worksheet where I want to count the number of occurences
row where two row conditions are satisifed
eg In the example below if I wanted to count where Col 1= A and Col 2 = 1,
then I'd want the answer 2 returned
A 1
B 2
A 3
C 4
A 1
In practice Col 1 has the rangename 'Place' and Col 2 has the rangename
'Customer' - if this helps answering this post
Can someone save my sanity
Tx in advance
Rob
row where two row conditions are satisifed
eg In the example below if I wanted to count where Col 1= A and Col 2 = 1,
then I'd want the answer 2 returned
A 1
B 2
A 3
C 4
A 1
In practice Col 1 has the rangename 'Place' and Col 2 has the rangename
'Customer' - if this helps answering this post
Can someone save my sanity
Tx in advance
Rob