Results 1 to 6 of 6

need formula help to highlight date ranges

Threaded View

  1. #1
    Registered User
    Join Date
    05-03-2013
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    3

    need formula help to highlight date ranges

    Hi. I have 2 columns A & B which contain a list of customer numbers (A) and dates (B)

    I would like a formula for column C which will show the word 'REPORT' if the customer number in A also appears at a date in the previous 90 days. The dates are beside the customer numbers

    Thanks

    Craig
    Last edited by CRAIG20; 05-03-2013 at 06:53 AM. Reason: title too short

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