I have a spreadsheet of physical education assessment results, for over 15 sports. For the assessment, 4 of the highest scores go forward. I have a large function, =LARGE(W2:DT2,1), to find the 1st, 2nd, 3rd and 4th highest scores. Next to large results, I want the sport it is in, which means I want a function that returns the column heading from which the large result came from. This function will need to apply for each row.
Hope this makes sense.
Thanks,
Jon.
=INDEX(A1:B14,MATCH(LARGE(B1:B14,1),B1:B14,0),1)
This doesnt cover 2 identical scores though...
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks