Dear All Hi,
<tbody>
</tbody>
I have the above table
In column 3. I want the expected results shown already shown.
I want to use this formula =IF(MAX(B2:B4)=B2,MAX(B2:B4),"") This is to be used only for rows above blank rows.
but the cell ranges changes gradually and for 2nd row the formula range becomes B3:B5
Which results in Wrong answers.
Please if anyone can give proper formula so that the range is always between the blank rows.
Hope I am able to explain the problem.
Thank in Advance
Jack
Location | KM | Needed Output |
CHIKHALI | 70 | 70 |
KARVE NAGAR | 44 | 0 |
DHANKWADI | 38 | 0 |
BHOSARI | 60 | 60 |
KASARWADI | 48 | 0 |
NARHE | 50 | 0 |
AMBEGAON PATHAR | 48 | 0 |
KATRAJ KONDHWA ROAD | 36 | 0 |
LOHEGAON | 42 | 0 |
NIGADI | 73 | 73 |
DHOLE PATIL ROAD | 24 | 0 |
DHANKWADI | 38 | 0 |
FURSUNGI | 20 | 0 |
CHINCHWAD GAON | 68 | 68 |
THERGAON | 64 | 0 |
BALEWADI | 60 | 60 |
NARHE | 50 | 0 |
NDA | 50 | 0 |
MUNDHWA ROAD | 12 | 0 |
<tbody>
</tbody>
I have the above table
In column 3. I want the expected results shown already shown.
I want to use this formula =IF(MAX(B2:B4)=B2,MAX(B2:B4),"") This is to be used only for rows above blank rows.
but the cell ranges changes gradually and for 2nd row the formula range becomes B3:B5
Which results in Wrong answers.
Please if anyone can give proper formula so that the range is always between the blank rows.
Hope I am able to explain the problem.
Thank in Advance
Jack