Basic text sort formula
This formula uses the "greater than or equal to" operator with text, something you might not have tried before. When Excel compares text, it decides which value is "greater" than another based on rules that follow the ASCII specification.
Inside COUNTIF, the...Read more