ExcelBanter - How does Excel determine the ORDER of consolidated data?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How does Excel determine the ORDER of consolidated data? (https://www.excelbanter.com/excel-worksheet-functions/101307-how-does-excel-determine-order-consolidated-data.html)

How does Excel determine the ORDER of consolidated data?

When consolidating by category, the results did not seem to be in any
particular order (using Excel 2003 version)...

All times are GMT +1. The time now is 12:00 AM.