Find min and max values

[prakash_moturu]

hi

i have a sheet and the values are updating in Range("A1")(live data)

based on that data (sheet1.range("A1").value how to find min and max

value

 

[JamesW]

Hi,

In your excel sheet, try: =MIN(A1:A10) and =MAX(A1:A10)

 

[prakash_moturu]

hi james ,

thanks for help. but in my sheet i have only one cells ie sheet1.Range("A1") that value is updating dynamically(Stock data).

in 10:01 the data is 700.5
10:02 the data is 710
10:03 the data is 695 like this

how to find min and max for that data


thanks in advance

bye
Prakash