Need a bit of help.
Have a sheet of data with imformation about customers balance over the last 12 months.
I need to create a formula that can look at each row and display in a specified cell the highest balance.
This is on Excel 2000 and need to finish it by end of today and have 1250 accounts to review.

Thanks

Grant

 

type in =MAX(A7:L7)
This will give you the highest value in the range above. Just copy the formula down all the rows. If you need more help shout.

 

Thanks
Perfect.

Grant