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??

Hi,

=SUMPRODUCT(--((A1:A5+B1:B5)<C10))

calculates the number of rows that meet the condition. The following array
formula return the letter in column c

=INDEX(C1:C5,MAX(((A1:A5+B1:B5)<C10)*ROW(A1:A5)))

to make it an array you enter it by pressing Shift+Ctrl+Enter.

Note that this does not deal with what happens if the two rows have
different letters. This just return one of those letter.



--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Jon" wrote:

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??