Col A has the following:
A1 - XXX
A2-YYY
A3-ZZZ
A4-XXX
A5-CCC
A6-YYY
B1 to B6 has dates in the date format. I want to sum Col B (to find out the
days lapsed) for XXX, YYY, ZZZ etc....
I sorted col A but do not know the formula to do the above. Please help.