I have a short list of 4 names ; if someone chooses 1 of them from a dropdown ; I want a new list to be generated of the 3 remaining names ; plz and thank u ;
answer below : key is =IFERROR(INDEX($B$22:$B$25,AGGREGATE(15,6,ROW($A$1:$A$100)/($B$22:$B$25<>$B$13),ROWS($1:1))),"")
Bookmarks