Row A 1[/COLOR] 2 3 3 5 4 2 5 (blank) 6 1 7 (blank) 8 (blank) 9 (blank) 10 9 11 5 12 8 13 7 14 5 15 (blank) Use formula =MAX(A2:A15)
i have data set in column, but there are some blank cells between two data set. 3 5 2 (blank) 1 (blank) (blank) (blank) 9 5 8 7 5 (blank) how to find the maximum value in each data set. please help me