Hello,
I have seen some formulas but none are doing exactly what i want.
on Sheet1 I have a long row that has a "Text"(type data), then in the cell next to it (to the right) has a "Date"(type data). I.e. A1(text) A2 (Date) and continues down A1:ZZ1, i.e. text, date, text, date, text, date.
On Sheet2 i have a Cell say A1 that needs to look down 'Sheet1'!A1:ZZ1 and pull the last entry(moving left to right) that is a "text". Then in the cell next to it (to the right) A2 i need a formula that will look down that same row in Sheet1 and pull the last entry (moving left to right) that is a "Date". now the second to last entry will always be a "text" and the last entry will always be a "date".
Can someone help me with these formulas.
Thanks.
Bookmarks