We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

Excel help required


Housten

Likes # 0

Good Afternoon, everyone.

I have a spreadsheet which is growing longer on a daily basis, with a series of varying values. What I want to do is to record the daily value and then have a cell alongside it show what the highest number has been. I have tried, and failed miserably, to do this with the 'if' function but this failed. I have been using "=IF(K12>$M$10,$M$10=K12,IF($M$10>=K12,$M$10))" in column M, starting in row 12, with the idea that the greatest value would be put in M10, and then printed alonside the cells of column K, in which I am recording the changing values. I know I should have thought of this before, but I have only just realised that this information would be handy and I am already over 200 rows long!

Any ideas/help/information/advice would be very, very gratefully received. I have been at this for two days now and this is driving me bananas, so any help will be most gratfully received.

Like this post
VoG II

Likes # 0

Try in M12 copied down something like

=MAX(K$10:K12)

Like this post
Housten

Likes # 0

VoG™,

I can only say "brilliant, really brilliant!". I entered it and then copied it down all the rows, and BANG!! I had the highest value instantly. I didn't even realise the values had gone as high as they have, another marvellous side effect.

Many, many thanks for your very speedy help.

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

Windows 9 release date, price, features: Microsoft teases new OS ahead of 30 September unveiling

IDG UK Sites

From the iPhone 6 to the iWatch and a new Apple TV we look at the products Apple is set to launch...

IDG UK Sites

September 2014 creative trends: 5 things you must see

IDG UK Sites

What to expect from Apple in autumn/winter 2014: iPhone 6, iPhone Air, iWatch, iPad 6, new Apple...