Liked and subscribed! A bit off topic here, but I saw you did some videos using the MAX function and was wondering if it was possible to tell Excel to find the max or latest date in a table and return a corresponding cell value that goes with that date in that is located in a column to the right of it. I feel like it should be possible but I haven’t come across any videos on it this far.
Thanks for the video, I would have avoided removing duplicates on customer number only thoughl; that is fine if a customer has only ever made one purchase, but what if the customer has made multiple purchases over several months? So easy to produce reports with incorrect data. Far better to use a transaction number grouped with all rows selected, produce a table per transaction number remove duplicates from the nested tables relying on more than just the one column.
Blog post chrismenardtraining.com/post/removing-duplicates-using-power-query Online courses courses.chrismenardtraining.com
Liked and subscribed! A bit off topic here, but I saw you did some videos using the MAX function and was wondering if it was possible to tell Excel to find the max or latest date in a table and return a corresponding cell value that goes with that date in that is located in a column to the right of it. I feel like it should be possible but I haven’t come across any videos on it this far.
Thanks Chris
welcome
Thanks for the video, I would have avoided removing duplicates on customer number only thoughl; that is fine if a customer has only ever made one purchase, but what if the customer has made multiple purchases over several months? So easy to produce reports with incorrect data. Far better to use a transaction number grouped with all rows selected, produce a table per transaction number remove duplicates from the nested tables relying on more than just the one column.
Hi chris
What is short cut key to select all columns if we want to check based on all columns?
Hi Chris can we do more power query series
sure.