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

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

Hi there,

Thanks you everyone

2. ## 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:
`Please Login or Register  to view this content.`

Title
Formula:
`Please Login or Register  to view this content.`

3. ## 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

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

Thanks all guys

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

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

6. ## 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. ## 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))

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

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