May 24 2019 06:02 AM
I need to index match based on the last instance of a combination of data elements. In the attached example, I want to match the Units (col D) for the last instance of each combo of Name (col B) and Stock (col C). This table is small, the real one is thousands of combinations. I haven't had any luck figuring this one out on my own! Thank you!
May 24 2019 06:48 AM
May 24 2019 10:53 AM
Thank you so much!