Results 1 to 8 of 8

Dynamic Top 5 Customer per month

Threaded View

dluhut Dynamic Top 5 Customer per... 06-30-2014, 02:14 PM
dluhut Re: Dynamic Top 5 Customer... 06-30-2014, 05:04 PM
oeldere Re: Dynamic Top 5 Customer... 06-30-2014, 05:17 PM
dluhut Re: Dynamic Top 5 Customer... 07-02-2014, 09:20 AM
kvsrinivasamurthy Re: Dynamic Top 5 Customer... 07-01-2014, 06:36 AM
dluhut Re: Dynamic Top 5 Customer... 07-02-2014, 09:20 AM
dluhut Re: Dynamic Top 5 Customer... 07-02-2014, 10:17 AM
kvsrinivasamurthy Re: Dynamic Top 5 Customer... 07-03-2014, 06:37 AM
  1. #7
    Valued Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    365
    Posts
    1,101

    Re: Dynamic Top 5 Customer per month

    Quote Originally Posted by kvsrinivasamurthy View Post
    Pl see attached file.
    Hi kvsrinivasamurthy,

    Technically, this thread is solved!

    However, I noticed that my pivot data starts at row 5 instead of row 1 as shown in the sample. So taking the same data, H1:L4 is empty

    I've made a change to the formula and tried to use it in my original, however, I'm getting #N/A value (but on the sample, it's not taking the #N/A value)



    PS: I found the mistake. In the sample, #N/A is "FALSE" with ISTEXT function. However, in my original pivot, #N/A is considered as "TRUE" with ISTEXT function. Therefore, I've changed the formula with


    =IFERROR(INDEX(Pivot!$H$6:$H$30,SMALL(IF(INDEX(Pivot!$I$6:$L$30,,1+INT((ROW()-2)/5))=$I2,ROW(Pivot!$H$6:$H$30)-1,""),COUNTIF(OFFSET($I2,0,0,-1-MOD((ROW()-2),5)),$I2))-4),"")
    Last edited by dluhut; 07-02-2014 at 10:29 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to Count Unique Customer by Month
    By byankton in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-19-2013, 12:39 AM
  2. SUM Sales by Month and Customer
    By gblass1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-11-2013, 03:30 AM
  3. Summing total per customer for each month
    By wnstar21 in forum Excel General
    Replies: 13
    Last Post: 11-06-2009, 03:48 AM
  4. product sum per month per customer
    By Pete Petersen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-04-2005, 01:06 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