Help me create a prompt for my work

I have an excel sheet with total 8 columns showcasing the previous and new rankings of games

First 4 columns with names (Previous A, Previous B, Previous C, Previous D)

And other 4 columns with names ( New A, New B, New C, New D)

What I want is that the chatgpt would compare the new columns by Old Columns of the same alphabet and determine in the new columns which entries moved up the rank, which entries moved down the rank, which entries are replaced by new ones in each, and which entries are same position according to their previous alphabetical order sheets.

And then create a New excel sheet showcasing each New Columns with the rankings "up" "down " "new" "same" beside each New Columns Lists

Please help me craft this prompt.

Leave a Reply