Select the range of values u need to find maximum. Now in the tool bar click on AutoSum(the down arrow on AutoSum Symbol) and select Max. That is all. Maximum is displayed in the last field. By clicking on the last field u can see the formula also.
Hope this helps
I am afraid I am a bit late, but I saw the message just now
Hi joy
need some help
I am workin with excel ,I have following data say
colum A1 column B1
30 29
45 36
25 42
52 63
22 82
Now what formula should I enter in formula bar to get higher value in column A1 and lower value in B1
thanks in advance
faith
PS: I am using your data converter so I know you are an expert