In removing duplicate rows, can this look for duplication in more than one column? Perhaps Match Code is the same but other data elements within those records are different.
@@TigerSpreadsheetSolutionsThanks but those other column duplicates may be in different records than this Match Code duplicate. Perhaps finding complete record duplicates requires Access.
Good to see you back here Chris!
Good to be back Henrik, thank you! Lots more to come this year ...
Thank you so much for another clear explanation and exercises Sir. More power to your channel.
🔥WATCH NEXT - 30-MInute Session On Power Query
ruclips.net/user/live10C5PhO9BVo
so wonderful, appreciate your effort, best of luck.
Thank you and welcome to the channel! See you in another video ...
In removing duplicate rows, can this look for duplication in more than one column? Perhaps Match Code is the same but other data elements within those records are different.
Hi there - you should be able to do as many 'remove duplicate' steps as you need on different columns
@@TigerSpreadsheetSolutionsThanks but those other column duplicates may be in different records than this Match Code duplicate. Perhaps finding complete record duplicates requires Access.
I'm not sure - I tend to reach for VBA in this situation!
@@TigerSpreadsheetSolutions... and your VBA classes are wonderful!!! 🤩