Using the Sort and unique formula excel

Question

I am getting familiar with some new functions in excel 365 and saw that the unique and sort functions could take a large column and could be used in a summary list. Was wondering is there a way to have a manually select column title in another sheet and use those two functions to get all the values from another sheet excluding the title? Then after that to have the text total as I am planning to make an aggregate report using some formulas in other columns.

Answer 1

Hi @Jonathan Brotto

> Was wondering is there a way to have a manually select column title in another sheet and use those two functions to get all the values from another sheet excluding the title?

Please check whether the following formula is helpful.

• Select the data range that includes title, then press Ctrl + Q, select Table to convert that data range to be a table.
  
• Then you could enter the Tabe name[Title name] to be a data range in thoses 2 formulas.
  

If I have any misunderstanding, welcome to let me know.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---