Excel help

Hi guys,

Im doing pair trading and calculating p/L in excel sheet. Final profit field value is changing depending upon Profit or loss.. I want to know whats the high profit and whats the low loss. Just want to make a note of High and Low of that field....

Is this possible to catch high and low which is changing always.

Plz guys any one suggest .... thanks in advance.

M&M Long 1396 1401.45 250 1403.91376.6 1362.5
MARUTI Short 2945 2942 125 2963.15 2921 375
Final Profit=1737.5

waiting for reply.. plz any one

http://chandoo.org/wp/excel-basics/

You will get everything you need in excel at above site.

Thanks for ur reply..

But sorry to say.. im not finding exactly what i want.

There is good examples to find large or small numbers in range.. but not showing for cell value which is changing value.

Even i googled for this.. but exactly im not finding..

Plz guys...

You can ask your query here and most probably you will get your answer.

http://chandoo.org/forum/