ryank_2002
New Member
- Joined
- Apr 12, 2012
- Messages
- 4
I am looking for a formula in excel that will first search for the first non-blank cell in a column and return a date in a different column that is associated with that first non-blank cell. I've seen a few formulas around that are close, but nothing has worked for me so far.
For example:
-Column A lists all of the dates in sequential order
-Column B lists recorded values over certain days, but not every day has a value recorded.
-Let's say that cell B5 is the first filled in cell in column B, I'm looking for a formula to return the date in cell A5. So looking at the example below when it comes to B5 which is the first filled in cell, B5=100, it would return A5, A5=2/5/2012.
......A ...........B
1 2/1/2012
2 2/2/2012
3 2/3/2012
4 2/4/2012
5 2/5/2012 ...100
(the periods are only to make the fake rows/columns kind of line up)
I'd also like a formula that returns the date associated with the last filled in cell in a column.
Any ideas? Any help would be appreciated!
For example:
-Column A lists all of the dates in sequential order
-Column B lists recorded values over certain days, but not every day has a value recorded.
-Let's say that cell B5 is the first filled in cell in column B, I'm looking for a formula to return the date in cell A5. So looking at the example below when it comes to B5 which is the first filled in cell, B5=100, it would return A5, A5=2/5/2012.
......A ...........B
1 2/1/2012
2 2/2/2012
3 2/3/2012
4 2/4/2012
5 2/5/2012 ...100
(the periods are only to make the fake rows/columns kind of line up)
I'd also like a formula that returns the date associated with the last filled in cell in a column.
Any ideas? Any help would be appreciated!