find two large numbers!

[stewart08]

Dear excelers,

how can I create a function that can find two large/small numbers from a list of numbers i.e.

numbers
125101845107

need result: 87

below is my nearest function, but still does not work! please how is this do...thankx

=IF((LARGE(I101:AV101,1))*OR(LARGE(I101:AV101,2))=AI101,6,"")

[darkyam]

I take it from the range you have below that all your numbers are in different cells. If so, use =Large(I101:AV101,1) in one cell and =Large(I101:AV101,2) in the next. Or, to combine them into one cell, =Large(I101:AV101,1)&Large(I101:AV101,2)

[stewart08]

darkyam thankx for the quick reply.

I just tested this function:

=IF(LARGE(I101:AV101,1)&LARGE(I101:AV101,2)=AI101,0,"")

seem to still not work

it needs to find the large1 or large2 in a cell array...please help.

[ChemistB]

Enter Darkyam's equation just as he wrote it. Why are you changing it into an IF statement?

ChemistB

[stewart08]

may be I donot make it clear, once again:

row1: 0123456789 (refer nums)
row2: 1281006372 (sample nums)
row3: 2 8 (function per cell)

need finally result: 2,8

row3 function per cell needs to:
1) find largest or second largest digits in row2 = 87
2) then 87 is refers to row1 = 28

i hope it is clear now

[stewart08]

at the simplest level this is what I am trying to do:

seach a value via two other values i.e.

if 2 = 2 or 3! then use value "8"

or

need to use two function criteria (largest or second largest) in one function argument!

is this possible...any help would be greatful