I Am trying to get the top scores for multiple bow styles along with the archers name and and score.
see attached.
I Am trying to get the top scores for multiple bow styles along with the archers name and and score.
see attached.
Hi zardof
Would it be better to have the different Bow styles/Gender in there own tables for simplicity!
Alowance%20example(1).xlsx
How do you want to handle a tied highest score?
Im still thinking about solutions for that
I have amended the formula in #3 to get it working is there a way of only showing archers who have a score. with regard to tied scores i am thinking about it.
i didnt understand the question...maybe use an iferror or =if(iserror
to return a " " (blank)
=IFERROR(VLOOKUP(K24&M24, $C$2:$D$75, 2, 0),"") gets rid of the errors but i cannot get the name without a score to not be displayed until they have a score.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks