The Excel Formula below is an array formula that will sort a column and bring the contents to the top of the list. It’s particularly useful if you have blanks in your data that’s intermittently placed throughout a column. If you want the data to display at the bottom (instead of the top of the list), just swap out the word “LARGE” below with “SMALL”. Enter the formula and drag down adjacent to the list that you want evaluated. Remember to press SHIFT + CTRL + ENTER on the first cell to make it an array formula…then drag down from there.
{=INDEX($L$131:$L$190,MATCH(LARGE(COUNTIF($L$131:$L$190,"<"&$L$131:$L$190),ROW(1:1)),COUNTIF($L$131:$L$190,"<"&$L$131:$L$190),0))}
