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

[DanielMinh]

Hi there,

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

Thanks you everyone

[Glenn Kennedy]

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

Value

Please Login or Register  to view this content.

Title

Please Login or Register  to view this content.

[samba_ravi]

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

[DanielMinh]

Thanks all guys

[Glenn Kennedy]

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

[DanielMinh]

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

[Glenn Kennedy]

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))