Example:
I'm using an excel list to track down goalscorers in 3 different football leagues.
Its 1 huge list,where i manually add data in format:
each of that data in separate column offcourse.Scorer,His Club,No. of goals
Now,here comes the tricky thing.
From that 1 list i need to create 3 separate lists,where each one of them would feature a "TOP Scorer" list for its league.
So,lets say that 1 main list contains scorers from England,German and Italian league.
My data on list nowhere mentions in which league a scorer is,but,i can make aditional list somewhere which would name the clubs from england league,then another list which would feature a clubs from german league and so on.
So,a code would compare listed clubs in "main list",then,if they are a match to a 'german clubs' list,it would transfer those entries(full row of it,since there are 'name of scorer' and 'No. of goals') to a "TOP german scorers" table,in descending order(best scorer first,adn so on).
Sorting should stop after 10 or 15 entries on list,so even though if there is like 33 scorers in german league,final TOP german list would feature only 10,15 best among them.
Bookmarks