Finding a date that is linked and adjacent to a number
I have a simple spreadsheet for which I need a formula in cell AT3 to identify a date that appears next to a corresponding number. For example cell M3 is where the highest number in the row (PeakNum) is found.
Cell N3 contains the corresponding date and it is this date I need the formula in AT3 to show.
Can anyone help please?
I attach the file
I have a simple spreadsheet for which I need a formula in cell AT3 to identify a date that appears next to a corresponding number. For example cell M3 is where the highest number in the row (PeakNum) is found.Cell N3 contains the corresponding date and it is this date I need the formula in AT3 to show.Can anyone help please?I attach the file Read More