Excel power

Array formula extracts multiple data from the table it needs ctr+shift+enter keys for the command you can not press only enter key it will show error.

Offset and match formula become more effective and more impressive when we put these formulas with the big spread sheet also it find out the data or answer from the intersection as well.
Offset needs reference no, row, columns so we can put match formula instead of row and columns then it looks so easy and fruitfull.

Whenever you want a table sort by A to Z or Smallest to Largest here are Short cut for that
Alt+ A+ S.