Previous Topic Next Topic

Adding last week position to a weekly record survey

Closed
oraclewjr Posts 1 Registration date Friday January 13, 2023 Status Member Last seen January 13, 2023 - Jan 13, 2023 at 12:36 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 16, 2023 at 12:16 PM

Hello,

I am compiling weekly record charts of the most popular records. How do I add the last week position to each song on each new record list in Excel? Each compiled top 30 record chart is on a different sheet but in the same workbook.

Thanks for any suggestions.

Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jan 16, 2023 at 12:16 PM

Hi Oracle,

Could you post some sample data for better understanding? Probably use the VLOOKUP function.

Best regards,
Trowa
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response