![Old](images/statusicon/post_old.gif)
1st October 2004, 03:38 PM
|
Member
|
|
Join Date: Jan 1970
Location: South West Sydney
Posts: 37
|
|
moeee,
Try using formula in a vacant cell as follows
=max(a1:x1)
where "a1" is your 1st cell of row and "x1" is the last cell of your row, this will give you the highest amount
If you need to know which cell this is then you will have to use the "find" feature after highlighting the whole row. To highlight, click in 1st cell, then click and hold down your right mouse button whilst dragging all the way to the last cell
"Find" is under the "edit" section of your toolbar
|