# Top ten Values

1. ## Top ten Values

Need some help of you in excel. I have attached one excel having one table.
I want to form another table, which can give me top 10 numbers & values from
Table-1.

This Table-1 will be refreshed on daily basis, so I believe some kind of

Thanks

2. ## Re: Top ten Values

Try in E2 and copy down.

=LARGE(\$B\$2:\$B\$1000,ROW(A1))

In D2 and copy down.

=INDEX(\$A\$2:\$A\$1000,MATCH(E2,\$B\$2:\$B\$1000,0))

3. ## Re: Top ten Values

hi vjharry. just in case the Value repeats, this array formula helps you return a different Number:
=INDEX(\$A\$2:\$A\$628,SMALL(IF(\$B\$2:\$B\$628=E2,ROW(\$B\$2:\$B\$628)-ROW(\$B\$2)+1),COUNTIF(E\$2:E2,E2)))

...confirmed by pressing CTRL-SHIFT-ENTER to activate the array. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL-SHIFT-ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again. adjust the range accordingly to your needs

4. ## Re: Top ten Values

sorry value is not coming

5. ## Re: Top ten Values

Thanks .. But in case if any two values are same then Number will not come in correction postion
So could u pl help me more in this

6. ## Re: Top ten Values

Why not just filter?

See the attached file.

7. ## Re: Top ten Values

Thanks, the file which I provide is master data and I want result in other data\formulas.

Originally Posted by oeldere
Why not just filter?

See the attached file.

8. ## Re: Top ten Values

Ben in post#3 , offered a solution for this! Did you tried it?

9. ## Re: Top ten Values

Thanks Yes I checked .. But in case if any two values are same then Number will not come in correction postion (Means Index fourmula will not show correct)

So could u pl help me more in this

Originally Posted by Fotis1991
Ben in post#3 , offered a solution for this! Did you tried it?

10. ## Re: Top ten Values

See the example pls.

11. ## Re: Top ten Values

Thanks its done

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