Help with Excel ! Please
29 November 2002, 02:09 PM
#1
Scooby Regular
Thread Starter
Join Date: Sep 1998
Posts: 496
Likes: 0
Received 0 Likes
on
0 Posts
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
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
29 November 2002, 02:36 PM
#2
Scooby Regular
Join Date: Oct 2001
Location: X5 and MCS JCW country....London :)
Posts: 2,223
Likes: 0
Received 0 Likes
on
0 Posts
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.
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.
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
bluebullet29
General Technical
9
05 October 2015 02:17 PM