Re: Find lowest 5 numbers in column A with highest values in column B

Hi All,

What i need to do is:

I've two sheets(1,2), in sheet1 have values from L11 to L86 and v11 to v86. In sheet2 i wants to max value of V column so i used max formula and i got max value in sheet2 C8, max value of V column change in every 3 secs so after every 3 secs c8 value also change. Suppose at present v11 value is 1000 and it is max value of column v, so acoording to max formula it comes automaticaly in sheet2 c8.. now what i need is: when ever v11 column's max value comes in c8, at the same time i want the value of L11 value in E8, after 3 secs when max value of v column is change and suppose this time max value is in v16 so it will come automatic in c8 because of max formula, so at the same time i want L16 value automaticaly in E8, now guys please suggest me what and how i can do this ? please explain in bit details as i'm novice in excel, i'm using excel 2007 by the way.

Thanks a ton in advance,
regards