for long term solution your power query method is great especially once excel 2016 is used by vast majority of users. Sumifs with wildcard is also great solution but we'd have to be watching for new criteria pairs. Power Query solution is much easier than possible vba solution.
Love your videos. Quick question: What if I have 10 columns of data in a table and I want to use group by on two fields like you have done in your video but I also want to keep the additional column data after using Group By? Using Group By removes all other column data except the users selected data and whatever column they used to aggregate the data with.
Great video - the use of wildcard is really good to know and I am starting to appreciate the power of power query also. Good start to the day in Singapore :-)
ExcelIsFun the "*" trick indeed is MAGIC , I didn't know that one. I am already thinking in how many ocasiona I could have used it in my models. You are awesome Mr
hello my Friend Please one video on the formulas list, how to create a list of formulas that we can change result with it. like sum, average, max, min, count, with list can you help me on this matter.
hey! I'm Waheed Qureshi from Pakistan, I have a Problem in excel, I saw that list formulas function in the template, that template have a list of formulas that we can change list And we can and result change automatically in the one cell, I don't know how it work, Please one video on the Formulas list than we can change our result list changing the list like sum, average, Max, Min, Count Number, with list. Please One video on the formulas list with this We can change result any time without putting the formula again and again in the Excel. Waheed Qureshi
for long term solution your power query method is great especially once excel 2016 is used by vast majority of users. Sumifs with wildcard is also great solution but we'd have to be watching for new criteria pairs. Power Query solution is much easier than possible vba solution.
Yes, Power Query is so updateable when new criteria appears in data set! : )!!
Good stuff.
Wildcards are wildly powerful.
I knew I had used Group by before. Thanks for reminding me.
You are welcome!
great use of wildcards in formulas
thanx for the tip
You are welcome!
Love your videos. Quick question: What if I have 10 columns of data in a table and I want to use group by on two fields like you have done in your video but I also want to keep the additional column data after using Group By? Using Group By removes all other column data except the users selected data and whatever column they used to aggregate the data with.
It's amazing, as always your videos are a great help for those who really wanna be excel expert. :)
I am glad that the videos are helpful!
Great video - the use of wildcard is really good to know and I am starting to appreciate the power of power query also. Good start to the day in Singapore :-)
Awesome! Glad to help with the start of your day! : )
Great video man! Helped me alot!
Glad to help!!!!
Thank you mike you are doing amazing things with excel :-)
You are welcome!
wow amazing 👍👍
Glad it is wow for you, vijay : ) : )
Amazing illustration of efficient working. But is it true that you can do all that in VBA as well?
I am sure that you can, but I am not good with VBA... so I do not know how.
ExcelIsFun the "*" trick indeed is MAGIC , I didn't know that one. I am already thinking in how many ocasiona I could have used it in my models.
You are awesome Mr
Yes, wildcards open up a whole new world of possibilities!
hello my Friend Please one video on the formulas list, how to create a list of formulas that we can change result with it. like sum, average, max, min, count, with list can you help me on this matter.
Great tricks Mike!
Glad you like them! : )
This time my vote goes to formula :)
Thanks for voting!!! Yes formula is pretty good!
Adaptation of a new version(of excel) in companies usually considered as difficult as appointing the whole new staff. :)
That is funny, and mostly true.
hey! I'm Waheed Qureshi from Pakistan,
I have a Problem in excel,
I saw that list formulas function in the template, that template have a list of formulas that we can change list And we can and result change automatically in the one cell,
I don't know how it work, Please one video on the Formulas list than we can change our result list changing the list like sum, average, Max, Min, Count Number, with list.
Please One video on the formulas list with this We can change result any time without putting the formula again and again in the Excel.
Waheed Qureshi
"FUNTASTIC" ;)
I love it!!!! It is funtastic!!!!
Waoww….
for power query
: )