Trying to rank games by positions over a month.
Receive a XML file for each individual day for a month. In that file are game names and their ranking (top 50)
I want to import those XML files into LibreCalc and have the spreasheet recognise the scores for each particular game to create an overall score
For example on 1st May Game X may rank 5th so needs to be allocated 46pts on the spreadsheet. The next day the game may rank 8th so needs 43pts on the spreadsheet. However because of the structure Game X is not getting imported into the same Row on Calc.
Its probably a basic formula I need but cant suss it out