Write a custom function in Excel to replace countif().
The Problem is countif(): it will not work on huge spreadsheets, because it searches entire column every time. So it is slow.
I want a CountIfSorted() function that will take the same parameters, but it will expect that the column is sorted.
This way it needs to find the first occurrence and increment until the next line does not match.
The function will need to work on a sheet of 1,000,000 rows to be successful project.