Thread
:
Return value of heading if an adjacent cell in a row is not blank
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Return value of heading if an adjacent cell in a row is not blank
How about a formula that tries to match any impossible number on row 3 for
row 1.
=INDEX(1:1,1,MATCH(99999999999,3:3))
--
Don Guillett
SalesAid Software
"Wil H." wrote in message
...
I need some help/ideas in creating a macro or subroutine that returns the
column heading of the last cell in a row series that is not blank, and
populates the column heading in a cell adjacent to the last task date.
I'm using a worksheet to track the dates of when a particular task is
completed, and then I want to know what was the last task completed in
this
series in the cell next to the last task on that row. The data looks like
this:
Task 1 Task 2 Task 3 Task 4 Task 5 Last Task
completed
4/1 4/5 4/6 4/8
Task 4
3/8 3/7
Task 2
3/15 3/17 3/18 3/22 3/29
Task 5
4/12 4/14 4/15
Task 3
...and so on.
What I'd like to do is have Excel check the row to see if it has a date
value and then go to the next cell until it finds one that is blank. If
it
is blank, then return the column heading (task) of the last cell that was
not
blank in the appropriate cell (in this case "Last Task Completed".
I'm using Excel 2000 and I'm comfortable using Excel, but beyond writing
simple macros and functions - I'm somewhat limited as I'm not familiar
with
writing VBA code.
So any ideas or suggestions will be greatly appreciated!
--
Thanks, Wil H.
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]