C
cmartin2459
I have a spread sheet where A5:A237 are dates. Columns B5237 are
inputted numbers based on our water usage at 3 different times during
the day.
Cell C2 is =MAX(B5231)
I need cell C3 to look at the value in cell C2, search for this value
in cells B5237, find the corresponding date in cells A5:A237 and put
that date into C3.
I can't find a function to do this, anyone have any ideas?
inputted numbers based on our water usage at 3 different times during
the day.
Cell C2 is =MAX(B5231)
I need cell C3 to look at the value in cell C2, search for this value
in cells B5237, find the corresponding date in cells A5:A237 and put
that date into C3.
I can't find a function to do this, anyone have any ideas?