+ Reply to Thread
Results 1 to 7 of 7

Help please in identifying multiple enquireis

  1. #1
    Registered User
    Join Date
    03-20-2013
    Location
    Yorkshire
    MS-Off Ver
    Excel 2007
    Posts
    17

    Help please in identifying multiple enquireis

    I have a yearly spreadsheet which includes the post code and date that a client made an enquiry (Col A = UK post code, Col B = date). I need to be able to identify those clients who have made a second call within 3 time periods:
    1. 1 day (or 24 hours) of their first call
    2. 2 days (or 48 hours) of their first call and,
    3. 5 days (or 120 hours) of their first call.

    ideally the re-occurrences would be put into individual columns.
    Is anyone able to help me out here??
    Many thanks
    Vin 1602

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Help please in identifying multiple enquireis

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

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

    View Pic

  3. #3
    Registered User
    Join Date
    03-20-2013
    Location
    Yorkshire
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Help please in identifying multiple enquireis

    Thanks Pepe - I have attached a sample w/book. I can sort the data according to Postcode then Date, but need help identifying re-occurences. Hope it is apparent....
    Attached Files Attached Files

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Help please in identifying multiple enquireis

    There is probably a cleaner solution but the attached seems to do the job.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-20-2013
    Location
    Yorkshire
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Help please in identifying multiple enquireis

    Thamks Pepe - however, when I copy your formulas in G2 -I2, and drag these down the columns to apply them, I get the resulkts in w/book 'Sheet 1'. Also , the formula in col G inserts "tru" but yourworked data states"true" in col G.
    Could you help explain? Many thanks (see attached file)
    Attached Files Attached Files

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Help please in identifying multiple enquireis

    If you drag the formula down, you have to adapt the B2:B30 and A2:A30 ranges to something like B2:B500 or whatever

    The formula in sheet 1 are not correct, only those in the sheet AFTER

  7. #7
    Registered User
    Join Date
    03-20-2013
    Location
    Yorkshire
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Help please in identifying multiple enquireis

    The formula in sheet 1 are not correct, only those in the sheet AFTER[/QUOTE]

    Hi again. If I copy your formula from the AFTER page and insert in a new page (as in my w/book heet 1) and scroll down, I do not get the results you get in your downloaded file. I cannot see how formula in your col I will insert "True" when the formula says "tru", for eample. Pleae can you explain.
    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Identifying multiple value combinations
    By vicentiu in forum Excel General
    Replies: 0
    Last Post: 07-26-2013, 07:05 AM
  2. Replies: 4
    Last Post: 03-07-2013, 11:42 AM
  3. Identifying duplicates across multiple tabs with VBA
    By 0nyx1756 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-18-2011, 11:02 AM
  4. Identifying multiple entries.
    By clash005 in forum Excel General
    Replies: 3
    Last Post: 09-30-2009, 07:29 AM
  5. Identifying multiple entries
    By madtai in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-11-2007, 12:54 PM

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