how to count specific words and copy/past a related cell:
How can I take the 4-names as used in B36, C36,
D36 & E36 compare these words with the ones mentioned in B3:E24 and pick the top5 names (as used in A3:A24) that have the
best average result (the same names as predicted in Row36)??
So I would somehow get the top5 people who are most likely to win, I mean the ones that have about the same result or exactly
the same result (names from 1 to 4) as stated/predicted in Row36 (B36:E36)
These 5-top5 names should be placed in B41:B45 and It would be nice to add a percentage of how much they actually predicted
allright, so in my example there would be at least 4 people with 100% because they had exactly the same 4-names as was
predicted in Row36 (B36:E36).
it looks like these should be at least in the top5, because they have exactly the
same result as what Row36 has predicted.
=> A12 & A13 and A17 & A18 have exactly the same 1-to-4 as stated in Row36 (B36:E36)
Perhaps it's also possible
for the results in Row36 to be choosen dynamically? Now I just looked manually for the highest values in B27:E34 and
copy/pasted the results/names in B36:E36
(by the way, I used i.e.* =AANTAL.ALS(B1:B22;"Aerts") to count how much a specific name/word is used. AANTAL.ALS is the sam
as COUNTIF (at least I think so))
I Hope it's clear what I want to do?
With kind regards, Tim.