+ Reply to Thread
Results 1 to 7 of 7

[Return Daily Top10 Function in a range of different cell]

  1. #1
    Registered User
    Join Date
    08-11-2011
    Location
    HCM
    MS-Off Ver
    Excel 2007
    Posts
    15

    [Return Daily Top10 Function in a range of different cell]

    Hi there,

    As the title said, please help me with the function in the attachment.

    Thanks you everyone
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: [Return Daily Top10 Function in a range of different cell]

    PROVIDING that both sheets start on the same date, this is not too difficult.

    Value
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Title
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Glenn



  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    7,954

    Re: [Return Daily Top10 Function in a range of different cell]

    b4=LARGE(INDEX(INDEX('Consume by Fucntion'!$B$3:$CM$63,MATCH($A4,'Consume by Fucntion'!$A$3:$A$63,0),)*('Consume by Fucntion'!$B$2:$CM$2='Consume by Fucntion'!$CM$2),0),INT((COLUMNS($B4:B4)+1)/2))
    Please Login or Register  to view this content.
    c4=IFERROR(INDEX('Consume by Fucntion'!$1:$1,SMALL(INDEX(((INDEX('Consume by Fucntion'!$B$3:$CM$63,MATCH($A4,'Consume by Fucntion'!$A$3:$A$63,0),)<>B4)+('Consume by Fucntion'!$B$2:$CM$2<>'Consume by Fucntion'!$CM$2))*10^10+COLUMN('Consume by Fucntion'!$B$2:$CM$2),0),COUNTIF($B4:B4,B4))-2),"")
    Please Login or Register  to view this content.
    Try this and copy across both the formulas
    see the attached file
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Registered User
    Join Date
    08-11-2011
    Location
    HCM
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: [Return Daily Top10 Function in a range of different cell]

    Thanks all guys

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: [Return Daily Top10 Function in a range of different cell]

    Thanks for the rep... glad to have helped.

  6. #6
    Registered User
    Join Date
    08-11-2011
    Location
    HCM
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: [Return Daily Top10 Function in a range of different cell]

    Hi again,

    i need a little more help with this case....
    Now we need to query and return the top10 function of the 5 newest day only.(starting from today back to today - 4)

    Appreciate any help

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: [Return Daily Top10 Function in a range of different cell]

    Use nflsales' formulae, but put this in sheet 3, A4 and drag down a total of 5 rows:

    =INDEX('Consume by Fucntion'!A:A,MATCH(LOOKUP(1E+100,'Consume by Fucntion'!B:B,'Consume by Fucntion'!A:A),'Consume by Fucntion'!A:A,0)-(ROWS($1:1)-1))

+ 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: 9
    Last Post: 06-27-2018, 12:15 PM
  2. IF function to return text if a cell = another range of cells
    By Richie Bell in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2015, 10:56 AM
  3. Replies: 4
    Last Post: 03-21-2014, 01:41 PM
  4. Cse formula to do conditional sum w/large function to get a top10
    By carlosmaldonado in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-15-2013, 10:50 AM
  5. select a range (season) of daily values in a long daily calendar
    By lobotomy in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-19-2012, 09:48 AM
  6. Replies: 5
    Last Post: 11-17-2010, 02:52 PM
  7. how to calculate daily return to monthly return
    By wuruonan in forum Excel General
    Replies: 1
    Last Post: 05-27-2010, 08:19 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