+ Reply to Thread
Results 1 to 7 of 7

Formula to flag last three transactions for unqiue suppliers

  1. #1
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    Formula to flag last three transactions for unqiue suppliers

    This is a follow-up question to a previous post here.

    See attached spreadsheet below. Basically, using a countifs formulas in column E to count the last three transactions by date for each customer. However, need to modify it to include last three transactions per customer and unique supplier. I manually put in the expected result in column F. Previous formulas is as follows:
    Please Login or Register  to view this content.
    Any ideas to modify to factor in unique supplier? Thanks.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: Formula to flag last three transactions for unqiue suppliers

    I am little confused. Let me know if this is what you want.
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    Re: Formula to flag last three transactions for unqiue suppliers

    That formula is putting a "1" in every cell. I am only trying to put a "1" in each corresponding cell that meets the criteria of last three unique suppliers by date of service (e.g. max date of service/three unique suppliers). Thanks.

  4. #4
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: Formula to flag last three transactions for unqiue suppliers

    Ok. Got it now.

  5. #5
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: Formula to flag last three transactions for unqiue suppliers

    You can use this array formula :
    Please Login or Register  to view this content.
    Confirm Ctrl+Shift+Enter

  6. #6
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    Re: Formula to flag last three transactions for unqiue suppliers

    Excellent. That one worked. Thanks Sanram...

  7. #7
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: Formula to flag last three transactions for unqiue suppliers

    You are welcome and thanks for the rep.

+ 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. Replies: 22
    Last Post: 09-20-2013, 02:00 PM
  2. Replies: 2
    Last Post: 09-17-2013, 07:12 PM
  3. [SOLVED] Formula to produce sequential number for multiple suppliers
    By tanyas in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2013, 05:55 PM
  4. Replies: 5
    Last Post: 09-02-2012, 04:34 PM
  5. Formula to mark offsetting transactions
    By jmiller7 in forum Excel General
    Replies: 4
    Last Post: 01-14-2011, 07:23 PM
  6. [SOLVED] The goal is 5 per 100 transactions, how do I write formula for %
    By andy3468 in forum Excel General
    Replies: 2
    Last Post: 07-11-2006, 01:35 PM
  7. Excel Formula-different products from different suppliers.
    By Mangus Pyke in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 04:05 AM

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