Hi David. Some great tips for making queries more robust. Thanks for sharing. Liked and subscribed. I’ve found that although “choose columns” and “remove other columns” do basically the same thing I prefer to use “remove other columns for two reasons : 1) I can see the data better as I’m scrolling through the columns on screen to visualise what I want to keep 2) the order in which you click in the columns is the order of the results of the step - this then saves me having to do a subsequent reorder step. But as ever in Excel there are generally multiple ways to achieve the same result.
Hi David.
Some great tips for making queries more robust. Thanks for sharing.
Liked and subscribed.
I’ve found that although “choose columns” and “remove other columns” do basically the same thing I prefer to use “remove other columns for two reasons :
1) I can see the data better as I’m scrolling through the columns on screen to visualise what I want to keep
2) the order in which you click in the columns is the order of the results of the step - this then saves me having to do a subsequent reorder step.
But as ever in Excel there are generally multiple ways to achieve the same result.
Yes good feedback thanks for that, they do the same thing but the user interface is different, i go between the two!
Very good content
Great, thanks for sharing! Came here from one of your other videos, and glad I've watched it.
That’s lovely to read - thanks so much 😃
@@learnspreadsheets Thank you 🙂
Good practice is the best practice. Thank you a lot.
No worries good you find it useful!
Excellent tips, its greatly useful for excel loads.
Glad you think so!
Thanks David nice topic to cover
Glad you like it thanks!