Vlookup

[violetlim]

Hi all, I am a newbie , need help.

Summary
B1* 37
B2 0
N1* 0
N2* 0
N3* 0
C1* 8
C2 0
C3 0
E1* 6
E2 1
S1* 2
S2* 0


How can i get the top 5 position in formula?
Eg:
Top 5
B1 37

[Kevin UK]

Hi violetlim

Maybe using the LARGE function EG: =LARGE(Your Array,ROW(A1)) and copy down 5 rows.

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.