Hi all,
I have Dates in 1st row, second row title I need Latest Status, Latest Reason for that particular row should shown in 1st & 2nd Columns.
Please see the attachment
Thanks in advance.
Prasad Emany
Hi all,
I have Dates in 1st row, second row title I need Latest Status, Latest Reason for that particular row should shown in 1st & 2nd Columns.
Please see the attachment
Thanks in advance.
Prasad Emany
What would a sample answer look like?
perhaps this for the date...
=INDEX($C$1:$CQ$1,,COUNTA(C3:CQ3)-2)
and this for the reason...
=INDEX($C$1:$CQ$1,,COUNTA(C3:CQ3))
On a side note, its almost always better to make your worksheet grow downwards, rather than across, ie, have dates going down, rather than across the top
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Dear Ford,
Many Thanks for your solution
Actually I need Latest Status and Latest Reason. Date not required. you have given solution for date and reason.
Please suggest me on Latest Status and Latest Reason
Last edited by prasademany; 05-22-2015 at 11:36 PM.
use this instead...
=INDEX(C3:CQ3,,COUNTA(C3:CQ3)-1)
and
=INDEX(C3:CQ3,,COUNTA(C3:CQ3))
Thanks A Lot....All it's worked for me....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks