Sunday, 20 January 2013

How To Create Dynamic Drop Down List In Excel

How to Get Dynamic Range in DropDown List in Excel
Suppose you want create a dynamic drop list based on column where the values are dynamically changing , we have to follow the below method.
Key Steps:
  1. Click Data tab
  2. Click Data validation button
  3. Click "Data validation..."
  4. Select List in the "Allow:"
  5. Type =OFFSET($A$1,0,0,COUNTA($A:$A),1) In the "Source:" window
  6. Click OK!  



Example:
We have data as follows :



Now will add some more data is updated In Column A then the 
Drop Down List also Updated Dynamically. as Shown Below
This list may allows Duplicate Values also.



Thanks,
TAMATAM

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts