Hello !!
I have a matrix of 6*6 with names of all my colleagues. I want to extract the unique names vertically. I'm using Microsoft excel 2019. Also the matrix range is dynamic i.e. it can be 3by3, 7by7, 3by2 ( 3 rows and 2 columns), 2by3 (2 rows and 3 columns) and so on. Looking for a either a power query or a formula solution.
Thanks!!
PS : I already know the trick of using Ctrl + C twice to open clipboard, copy all the names, paste vertically and use remove duplicate feature.
I have a matrix of 6*6 with names of all my colleagues. I want to extract the unique names vertically. I'm using Microsoft excel 2019. Also the matrix range is dynamic i.e. it can be 3by3, 7by7, 3by2 ( 3 rows and 2 columns), 2by3 (2 rows and 3 columns) and so on. Looking for a either a power query or a formula solution.
Thanks!!
PS : I already know the trick of using Ctrl + C twice to open clipboard, copy all the names, paste vertically and use remove duplicate feature.