K Kenshin Member Feb 5, 2021 #1 I am still confused about whether the title is correct or not, but please take a look at the file, hope somebody out there understand and need formula solutions only thank you Attachments Excel_app.xlsx 108 KB Views: 5 Last edited: Feb 5, 2021
I am still confused about whether the title is correct or not, but please take a look at the file, hope somebody out there understand and need formula solutions only thank you
R rahulshewale1 Active Member Feb 5, 2021 #2 Hi@ kenshin, Microsoft Office 365 Version solution ( Dynamic Array ) =SORT(UNIQUE($A$3:$B$23),1,1)
K Kenshin Member Feb 5, 2021 #3 Sorry not mention earlier about myexcel version is 2019 but appreciate your help @rahulshewale1 thanks
Sorry not mention earlier about myexcel version is 2019 but appreciate your help @rahulshewale1 thanks
R rahulshewale1 Active Member Feb 5, 2021 #4 Hi @Kenshin, or VBA Code Attachments Excel App vba.xlsm 23.7 KB Views: 4
R rahulshewale1 Active Member Feb 5, 2021 #6 Kenshin said: Is it possible a solution with formulas? Thank you in advanced Click to expand... Hi, PFA file. Array Formula With helper Columns. Attachments Excel_app Array Solution.xlsx 111 KB Views: 7
Kenshin said: Is it possible a solution with formulas? Thank you in advanced Click to expand... Hi, PFA file. Array Formula With helper Columns.
K Kenshin Member Feb 5, 2021 #7 Thank you @rahulshewale1 its awesome you nailed it thanks again for the helping
