Find the last Date and Text in a row that contains both Date and Text data.

[patcha]

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.

[vlady]

Welcome to the forum, I think you should attach a sample workbook for the members to work with include expected results.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic