Need to show latest figure input in a column

I have a spreadsheet with 5 columns and each day I need to update each column with a number. Column 6 needs to show the figure input in the last columns i.e. On Monday column 6 will show the figure for Monday but on Tuesday it needs to show the figure for Tuesday.

Daily Number of:- Saturday Sunday Monday Tuesday Wednesday Total
Activity 688 639 1327

I need to show the following

Daily Number of:- Saturday Sunday Monday Tuesday Wednesday Total
Activity 688 639 639

Can anyone help me do this?

Cheers

Suggest you post a copy of your workbook showing what you have and then showing what results you would like to have. Click on the Go Advanced button and follow the wizard.

The following formula in G7 should work:

Formula:

Please Login or Register  to view this content.