ScoobyNet.com - Subaru Enthusiast Forum - Help with Excel ! Please

ScoobyNet.com - Subaru Enthusiast Forum (https://www.scoobynet.com/)

- Computer & Technology Related (https://www.scoobynet.com/computer-and-technology-related-34/)

- - Help with Excel ! Please (https://www.scoobynet.com/computer-and-technology-related-34/154862-help-with-excel-please.html)

GRANT

29 November 2002 02:09 PM

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

Scooby-Doo

29 November 2002 02:36 PM

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.

GRANT

29 November 2002 02:48 PM

Thanks
Perfect.

Grant

All times are GMT +1. The time now is 12:23 PM.