Hello,
I'm trying to setup an ARRAY formula to automatically to fill a column when new data is entered. I'm using MIN/IF function to pull the lowest date available for that person each time that person's name appears on my list. As you can see on the attached sheet, I believe I have the formula to capture the lowest date, but for some reason it won't auto populate the column. Thanks in advance.
Nigel (uknusa)
Bookmarks