G
Graham Parkinson
I have the following table of values
Unique IDs 1 1_1 1_2 2 3 4_1
A 1F 2H
B 1L 2F 3F 4H
C 1H
D 1H 2F
E
etc
I want to count how many 1Fs across all unique IDs there
are where the top row starts with a one (in this case
there would just be one for unique ID A). Then counting
1Fs with top row beginning with 2, etc. I will then count
how many 2Fs there are with the top row starting with a
one (2 in this case).
I've tried a sum array but I just get zeros for the
results.
Thanks
Graham
Unique IDs 1 1_1 1_2 2 3 4_1
A 1F 2H
B 1L 2F 3F 4H
C 1H
D 1H 2F
E
etc
I want to count how many 1Fs across all unique IDs there
are where the top row starts with a one (in this case
there would just be one for unique ID A). Then counting
1Fs with top row beginning with 2, etc. I will then count
how many 2Fs there are with the top row starting with a
one (2 in this case).
I've tried a sum array but I just get zeros for the
results.
Thanks
Graham