The title may sound convoluted, but I hope this is a pretty simple request.

I am entering in daily data in one column per day. I'm using a simple subtraction formula to determine new daily counts in three separate rows. The percent positive row is a direct-entry number. I'm using the MAX command to return the max value of a row to another cell, but what I want do is return the date associated with that same max value to a different cell. Any guidance is appreciated!



case demo.xlsm