+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    12-24-2003
    Posts
    4

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

    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.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,337

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

    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
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1