Updating a Cell

[tallahasseegirl10]

Please help. I am trying to figure out how to reference a cell from a column that changes each week:

For example: If year to date is F3, I want it to reflect G5, and then the next week G6 and the next week G7. The YTD numbers will be changed each week. Thanks for the help.

YTD

25
28
35
37
55

[JosephP]

hi

your question isn't clear to me-could you upload a sample workbook that shows what you are talking about?

[tallahasseegirl10]

Attached. I want to be able to have 36 weeks in my spreadsheet and reflect the latest number in Cell C1. Does that make sense? Thank you.

[daffodil11]

Assuming the YTD value is the highest, C1 would be =Large(c4:c40,1)

[tallahasseegirl10]

Thanks, this worked too! I appreciate the help.

[JosephP]

for the last number you can try
=LOOKUP(1E+100,C4:C56)

[tallahasseegirl10]

That did the trick! Thanks so much for the help.

[daffodil11]

FYI, JosephP's will produce a more accurate result in the event the count resets at any point.