SMALL/LARGE functions...

Hi Guys,

I need some help here...

I don't have much knowledge of EXCEL formulas and I prepared the attached sheet in which I have manually entered the information I require.

The original file I have has over 1500 entries that I need to check & match etc. which will take forever, hope you guys can help with some formal that could make life easier. Thanks.

A B C D E F G H I J K L M XXX YYY
450 275 275 450 450 275 350 500 300 450 450 0 0 ___ ____
-------------------------------------------------------------------------------------------------------------------------------
A B C D E F G H I J K L M XXX YYY
600 250 275 700 700 350 400 700 350 700 700 0 0 ___ ____

Hi Zbor,
I'm trying to implement the formula in the above examples but I keep getting incorrect values, something I'm doing wrong im sure...

In the first example, I require the value 350 under XXX and 450 under YYY.

Similarly in the second one, I require 350 under XXX and 600 under YYY.

Unfortunately can't share the master file as its company data...hope you can help....