+ Reply to Thread
Results 1 to 4 of 4

Count text and apply formulas

Hybrid 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

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,063

    Re: Count text and apply formulas

    Maybe this:

    =IF(ISNUMBER(C2),IF(B2<=C2,"First time","Repeat"),"Does not have a date")
    Never use Merged Cells in Excel

  3. #3
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Count text and apply formulas

    Something like this in cell D2, perhaps:

    =IF(A2="","",IF(OR(ISERROR(MONTH(B2)),ISERROR(MONTH(C2))),"Does not have date",IF(C2>B2,"First Time","Repeat")))

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

    Re: Count text and apply formulas

    Excellent, thanks Andrew-R and zbor. Both of these work !

+ 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