Hi all and thank you for taking the time to read my post, i have a small query and need some help, I am hoping someone can point me in the right direction.
I have a spreadsheet with some test scores in a tab called Data.
i want to be able to select any test and for the names of those people to appear.
Any help would be really appreciated. My work around at the moment involve lots of filtering so I thought may be a formula might be easier.
Are you actually using Excel 2003 still or do you have a newer version? I ask as my answer would be very different if you are limited to an old version of Excel.
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
Try this
Enter array formula in Dynamic Sheet A2 and copy down
***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
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.
Formula:
Please Login or Register to view this content.
then enter formula in B2 and copy down
Formula:Please Login or Register to view this content.
Please see attached file
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi Zero Cool,
I am currently using Excel 2013. Any help would be greatly appreciated.
Thank you Alkey,
I really appreciate the quick response, however its a great start but i noticed some of the scores are still over 55%.
I was hoping to get scores less than 55%, its my fault for not making that clear at the beginning my post.
I really appreciate your time sir.
Thank you
Please update your forum profile to reflect your current version of Excel. Thanks!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If you are using Excel 2013, I would then highly recommend you "flatten" your data and simply use a pivot table for this. Its the kind of thing its meant to do and does well, but your data isnt arranged in a conducive way for it.
See the attached file. Simply click test 1, 2 or 3 and you get what you want, sorted closest score to 55 to lowest. Based on the "new data" sheet, which has your data flattened.
Thank you Zer0 cool for all your efforts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks