I have a list of dates that I want to find the earliest and latest dates in the range based on 2 criteria in adjacent columns. Ultimately, I want to find how many days are between the earliest and latest dates posted.
I have attached a sample sheet that shows the 3 columns in question, eventcode, eventType, and date along with some sample dates. I see a lot of examples to count and sum based on multiple criteria, but nothing on min and max.
Am I even approachng this correctly? And can anyone give me a formula for finding the first date in column c that match criteria in columns a and b.
In otherwords, if eventcode = 1 and eventType = "A" what is the earliest and latest dates so I can find the differnce between the two.