J
Jon
I have 3 columns as follows:
A B C
100 100 a
200 350 a
100 100 a
220 500 c
100 250 a
C10 = 210
What I want is how to find the number of 100s & the letters in column C if
a1+b2<c10.
In my example the result is
Number of duplicated = 2
The duplicated letter is: A
How to do that please??
A B C
100 100 a
200 350 a
100 100 a
220 500 c
100 250 a
C10 = 210
What I want is how to find the number of 100s & the letters in column C if
a1+b2<c10.
In my example the result is
Number of duplicated = 2
The duplicated letter is: A
How to do that please??