Dynamic Data Validation List
Hi All,
My example excel file is attached. As being seen from attached file, I have 2 ranges to consist Data Validation Lists but the 2nd Validation List must be dynamic regarding the selection from the 1st Validation List has been tried to be explained in excel file.
What can be the proper formulas to implement Data Validations' Lists of 1 & 2 ? Thanks in advance for kindest supports.
Please try at H1 for unique list
=IFERROR(INDEX($C$5:$C$999,AGGREGATE(15,6,ROW($C$5:$C$999)-ROW($C$4)/(FREQUENCY(MATCH($C$5:$C$999&"",INDEX($C$5:$C$999&"",),),ROW($C$5:$C$999)-ROW($C$4))>0)/($C$5:$C$999<>""),ROWS(H$1:H1))),"")
drag down
You may use remove duplicate or Advance filter for unique list.
Data Validation Lists for
B1
=OFFSET($H$1,,,COUNTIF($H$1:$H$5,"*?"))
Data Validation Lists for
B2
=OFFSET($A$4,MATCH(B$1,$C$5:$C$999,),,COUNTIF($C$5:$C$999,B$1))
Dear Bo_Ry. Please grant my appreciation with lots of thanks. All the best
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks