Sometimes you just want to tell Excel what it is you want your formula to do. It'd be a lot easier if you could just say "sort this data in ascending order and find its average" i ...

It's so much easier to create, summarize, and analyze data now - no complex manual formulas required.

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.