Updating dates automaticaly

  • Thread starter Thread starter foilprint0
  • Start date Start date
F

foilprint0

I have a score workbook that I enter my scores for different shoots o
different worksheets and have my best score for each shoot on a maste
page, this I have done ok.
The problem I have is getting the date for each of my best shoots t
update on the master page.
Example
I shoot a “here”
On the “here” sheet I enter the date of the shoot in B4 then C4 the
D4
My score goes in cell B29 then C29 then D29 the highest score out o
the shoot is reflected in cell S29 which is the score that goes to th
master page which is all done. Now I need to get the date from th
corisponding row 4 to be updated on the master page as wel
 
Assume Sheet1 is where you have the scores as described,
and you have in S29: =MAX(B29:D29)
[ it's assumed there's no *ties* for the maximum score ]

In your "Master" sheet
---------------------------
Put in any cell:

=OFFSET(Sheet1!$A$4,,MATCH(Sheet1!S29,Sheet1!B29:D29,0))

Format the cell as date

The above will extract the date corresponding
to the maximum score in Sheet1
 
Back
Top