Add Data validation of Alphabetically Sort Unique values using Array Formula

**mchilapur** · 03-24-2020, 02:43 AM

Hello Excel Experts,
First of all, i thank each member for their suggestion to figure out issue in below post. Currently i am too struggling with same issue and after going through below post i found the issue was with drop downs..!!
https://www.excelforum.com/excel-pro...ver-as-mu.html

Below is the code which i currently use to get sorted unique values and its definitely causing the error. How can i create drop downs (Unique and Sorted) using Array formulas and in-turn add into VBA..? Sorry i am not that used to Array formulas..

Please help.. By the way i have 5000 rows (dynamic) of data and unique values among them may be 50 or so..

Please Login or Register  to view this content.

**mjr veverka** · 03-24-2020, 04:21 AM

Please upload a sample workbook (false data), but it should reflect the actual layout of the data on the worksheet.

**mchilapur** · 03-24-2020, 05:33 AM

Thanks for your response..Please check attached file..Under 'Data' sheet there are 6 unique values but in real these are around 50+..I need "All" as an option to be included along with unique values... All i am looking for is to build the same drop down using cell references (not the values, because it creates the error while opening the workbook)

Thanks for your help.