I am having some issues trying to get quite a lot of data ranked correctly. I've done some reading and possibly I need to use COUNTIF rather than RANK.
Here is what I am trying to do.
I have around 140,000 rows of data with the first two columns being date and time. I have numbers in...