How to get last weeks names in last weeks positions

[Pig59]

I do a 9 column spread sheet that looks like this
weekspred sheet.xls

What I need to know is how move last weeks names in to last weeks position but still keep them matched with the names in this weeks position after I have done the new grand total

[shyamhappy]

Could you please clarify on the last week position as I am getting bit confused?

[Andy Pope]

=IFERROR(INDEX(C2:F2,0,COUNTA(C2:F2)-1),"FirstWeek")

[oeldere]

@Pig59

1 advice you to store the data in a table.

Week in column C.

Values in Column D.

The it is easy to analyze your data with an pivot table.

[sktneer]

Not sure exactly what are you trying to achieve. But try this to see if this is what you want....

In I2

Please Login or Register  to view this content.

and copy down.

If this is not what you are trying to achieve, better upload a sample workbook with the desired output filled manually.

[micope21]

Hi

Column A13:A19, Column B13:B19 and column E13:E19 are array formula? Press same time Ctrl+Shift+Enter, NOT ENTER then copy down!

Rest are normal formula by just Enter??

See the files

Regard
micope21

[Pig59]

Thank you this sort of worked but I need the information in column A to stay the same ie 1 to 7 but the other columns to change after I put the next weeks figs in and for H column for last weeks position to change and match the new position in the B Column names ie week one c was in the 1st position and week 2 he moved to 4th position so that I can see last weeks position I need it to read position 4 name c then the weeks and grand total and in last week position column I it show position 1 but on the same line as the new position