Hi! I need a little help. I'm working with something similar to the pic below. I'm looking to identify the date that the setup was completed for each serial number. It's a report that I'll be adding to on a weekly basis.
Basically, I'm looking to find that latest date in the "Created Date" column for each serial number that is labeled as "Setup" in the "Service Type" column. So, for example, SN ABC001 would be 10/15/2016.
Any ideas on a formula that I can use?
File should be attached.
Capture.PNG
Thanks!
Bookmarks