I'm trying to rank order a list grouped by date and time. They should be ranked from earliest to latest and there can't be any ties. I've got them to group and order using the SUMPRODUCT function, but they're in reverse order. I tried to get them to break the ties using the RANK and COUNTIF function, but as you can see from the attached spreadsheet, there's no number 10 in the list? That's weird. I'm somehow going to embed the RANK formula into the SUMPRODUCT formula to achieve the desired ends. But, I have that tie breaker problem I can't seem to surmount. Any and all help would be appreciated. Thank you.
Bookmarks