Results 1 to 4 of 4

Count text and apply formulas

Threaded View

  1. #1
    Registered User
    Join Date
    04-20-2011
    Location
    CA
    MS-Off Ver
    Excel 2003
    Posts
    44

    Count text and apply formulas

    Hi, I need some help here. Please see attached Spreadsheet.
    I have some text in Column A. This text is a drop down from a range Column H. Now i have Date1 in column B and Date 2 in Column C. This Date 2 will always be the same for the particular text in A1. I need a formula to look at text, then find out if Date2 is earlier than Date-1 and return "Repeat", if Date2 is later than Date-1, "First Time", if there is no date or there is simply text in Date2 column, then return "Does not have a date" .
    Thanks
    Gautam
    Attached Files Attached Files

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