[ATTACH]342740
Hi
Each time I change cell C3 I wish to get the name,address,number and pass\fail from the input sheet. I need to get the top 10 values based on number.
I was thinking that each time c3 is changed it would sort the Input range by value in colume E then by name in column A. Then copy the first 10 rows of columns A,C E and F to the Output sheet.
Any ideas on how to do this.
James
What I would do is to insert a pivotTable. You can filter by name and you will see the addresses and data of the top ten numbers.
Top 10.xlsm
Last edited by Excel Mechanic; 09-02-2014 at 12:12 PM.
Check out my gig@ http://www.fiverr.com/s/5syr1l
By TOP TEN I assume you actually mean the "FIRST TEN" rows that belong to Sylvia?
In B6, then copied down:
=$C$3
In C6, then copied down AND to the right:
=INDEX(Input!C:C, MATCH($B6, Input!$A:$A, 0)+$A6-1)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi James
Try this Code in the attached for the Top Ten
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks