I am trying to update a formula that I got working with some help from Exp Exchange yesterday. I am not sure if we can do it, but I wanted to give it a try. See the attached example.
I need to update the following formula:
The formula returns values in Column G.
I need it to, after it returns values, it looks at Column V. If the info in Column V is the same, V12=V13=V14, it looks back at Column G, finds the earliest date, 6/21/15 (E), and returns that date for the other matching cells.
I know this is confusing. I am trying to return the earliest date in Column G for all of the matches in Column V.