Newbie - Finding maximum in a variable range

[tcheung]

Hi guys,

I am a newbie in excel and vba. Apology in advance if the question look so stupid. I have read through some of the post but I could not find the answer I want.

I am now working on an excel spreadsheet which will automatically update every day so that one row will be added on the top of the sheet everyday.
i.e.
A1 Date Price
A2 (New row added,date) (New row added,price)
A3 16/1/2013 5.5
A4 15/1/2013 5.6
A5 14/1/2013 5.45
... ...

Assuming that I am looking for maximum value of the column "Price", since max() cannot be applied to variable range, is there other method I could useto look for the most updated maximum value of column "price"?

Thank you

 

[Aladin Akyurek]

=MAX(B:B)

should suffice.

Ok my bad, i'm misunderstood with your expecting results, the solution is easy bro, =MAX(B2:B1000) , then u can add up the new row for data until u reach the 1000th row

OK Good luck with it. Should you have more than 1000 rows, you could use my solution.

Greetings

G.

What is wrong with:

=MAX(B:B)