|Posted: June 11, 2009, 12:13 pm - IP Logged|
good day sir/mam. :)
can someone please help me with an excel formula? for example i have 3 rows and each has a number
ex. 10 20 30
and i want to find out what is the lowest and highest number for the 3 rows and i wanted to put it in another two rows 1 for the lowest and 1 for the higest. is it possible to do this? tnx alot to anyone who will kindly reply.
row A1, A2, A3 has different numbers and i want to find out what is the lowest and higest number of the three and i want to put the lowest number in A5 and the higest number in A6. tnx again to anyone who will kindly reply or even read my post. :)