tanwarrahul1988
Member
Hello Guys I am finding a formula to find unique names but not show the name which contains a number like this "6. Sandhya Enterprises"
So, when I try this below formula it shows the below example results. Pls help me guys
=UNIQUE(SORT(FILTER(D2:D73,D2:D73<>"")))
Examples :
6. Sandhya Enterprises
7. Nirmal Enterprises
8. Aradhya Enterprises
9. Sunny
Dilip
Party
Self A/C
So, when I try this below formula it shows the below example results. Pls help me guys
=UNIQUE(SORT(FILTER(D2:D73,D2:D73<>"")))
Examples :
6. Sandhya Enterprises
7. Nirmal Enterprises
8. Aradhya Enterprises
9. Sunny
Dilip
Party
Self A/C