+ Reply to Thread
Results 1 to 7 of 7

Top 10 List on the basis of Year and Month

Hybrid View

  1. #1
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Top 10 List on the basis of Year and Month

    Pl see file wth formulas.
    For B5
    =IFERROR(INDEX(Sheet1!$C$2:$C$28,SMALL(IF((Sheet1!$A$2:$A$28=Sheet2!$C$2)*(Sheet1!$B$2:$B$28=Sheet2!$D$2)*(Sheet1!$L$2:$L$28=Sheet2!C5),ROW($A$2:$A$28),""),COUNTIF($C3:$C5,C5))-ROW($A$2)+1),"")
    For C5
    =IFERROR(LARGE(IF((Sheet1!$A$2:$A$28=Sheet2!$C$2)*(Sheet1!$B$2:$B$28=Sheet2!$D$2),Sheet1!$L$2:$L$28,""),ROW(A1)),"")
    then drag down.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    05-07-2014
    Location
    India
    MS-Off Ver
    MS Office 365
    Posts
    313

    Re: Top 10 List on the basis of Year and Month

    Hi Kvsrinivasamurthy,

    Its working, thanks for the help

+ 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. Graphing dates by month/year with 2 bars per month/year
    By Ellpoyohlokoh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-22-2014, 05:25 AM
  2. Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  3. Replies: 1
    Last Post: 06-27-2013, 08:12 AM
  4. How to add Month-on-Month and Year-on-Year %Variance into a pivot table
    By emeritus1812 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-09-2013, 02:37 AM
  5. If Column A Month and Year = ColumnB Todays Month and Year then send email
    By HACCStaff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 12:47 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