Forum Discussion
Clive_Rabson
Jun 14, 2024Brass Contributor
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
- dscheikeyBronze Contributor
- Clive_RabsonBrass ContributorOnce again many thanks for your help with this project
- Clive_RabsonBrass ContributorI am very grateful