Panayiotis
New Member
- Joined
- Mar 22, 2005
- Messages
- 38
My layout is such:
column A is blank
rows B1:E1 just have numbers 1,2,3,4
rows b2:E2 have dates jan, feb, mar, apr
rows b3:e3 1st 3 cells are blank, then e3 has a number 500
in a3 i want a formula as such that reads all cells in the same row, in this case be:e3 blanks and populated and as soon as it comes aross a number (500 in this case) it gives me the number directly above the date in this case the number 4 in cell e1.
thanks
column A is blank
rows B1:E1 just have numbers 1,2,3,4
rows b2:E2 have dates jan, feb, mar, apr
rows b3:e3 1st 3 cells are blank, then e3 has a number 500
in a3 i want a formula as such that reads all cells in the same row, in this case be:e3 blanks and populated and as soon as it comes aross a number (500 in this case) it gives me the number directly above the date in this case the number 4 in cell e1.
thanks