Hello,
I have attached a sample spreadsheet that shows what I'm trying to do in a sense.
Basically need to search an entire row for the last Date and Text cell in the row (from left to right) and it always alternates Text/Date/Text/Date from one cell to the next. So if starting in Row-2 it went Text1(A2)/Date1(B2)/Text2(C2)/Date2(D2)/Text3(E2)/Date3(F2) etc.... in the row, then in Say A1 i need a formula that searches the row(2) and would want to pull Text3 and in A2 i need a formula that searches the row and pulls Date3
Thanks.
I added a sample log to kind of show what I'm trying to do.
Thanks.
Bookmarks