What excel function do I use to display a date
Please see attached excel. I have a spreadsheet that has a number of dates and values that correspond to those dates. I need to know the minimum and maximum values, which are calculated in cells F3 and F4, using =min(B:B), and max (B:B) but I also want to display the corresponding date, from column A, in cells H3 and H4. Is there a function or formula I can use to do this? Thanks
|