Dear friends please help me...
I have 24 cell and am putting (C6:C29) hourly temperature in it like following.
A C
06 |00:00hrs. 40
07 |01:00 hrs. 40
08 |02:00 hrs. 40
09 |03:00 hrs. 40
10 |04:00 hrs. 41
29 | 23:00 hrs. 42
If I enter value 40 in cell C6 and thereafter I have press only down arrow key want to automatically take (upper cell) value 40 by formula, and continued till as required.
Suggest formula not vba code please.
Thanks in advance!
I have 24 cell and am putting (C6:C29) hourly temperature in it like following.
A C
06 |00:00hrs. 40
07 |01:00 hrs. 40
08 |02:00 hrs. 40
09 |03:00 hrs. 40
10 |04:00 hrs. 41
29 | 23:00 hrs. 42
If I enter value 40 in cell C6 and thereafter I have press only down arrow key want to automatically take (upper cell) value 40 by formula, and continued till as required.
Suggest formula not vba code please.
Thanks in advance!