The array formula in D10 extracts numbers sorted from small to large from column D if Region is equal to North AND Category is X on the same row.
The array formula in column E, shown in above picture sorts text values from column B. The Length columns prove that they are sorted by text length from small to large.
#N/A error is sometimes used to show gaps in charts, however, the AVERAGE function can't process errors, shown in C11 in the picture above.
Column C contains both date and time, to calculate the average of only time we need to extract the hours, minutes and seconds from column C. Formula in cell D3:
The AVERAGE function is designed to ignore blank cells but there are instances where it fails. The picture above seems to have blank cells in B3:B8, however, they are counted as zeros. Why?