Kutty Member May 22, 2019 #1 Hai Excel Experts! How to make drop down list in many rows except the selected name in the previous cells. I attached herewith my excel file for your reference. Thanks. by Kutty Attachments Test file.xlsx 11.7 KB · Views: 2 Last edited: May 22, 2019
Hai Excel Experts! How to make drop down list in many rows except the selected name in the previous cells. I attached herewith my excel file for your reference. Thanks. by Kutty
Luke M Excel Ninja Staff member May 22, 2019 #2 We can use formulas to build a new list that doesn't include selected items. I also built your dynamic validation as wlel. Attachments Test file LM.xlsx 12.5 KB · Views: 11
We can use formulas to build a new list that doesn't include selected items. I also built your dynamic validation as wlel.
Kutty Member May 23, 2019 #3 Luke M said: We can use formulas to build a new list that doesn't include selected items. I also built your dynamic validation as wlel. Click to expand... Thank You So much @Luke M for your help. It's very helpful to me. You done exactly what I want. Thanks a lot. by Kutty
Luke M said: We can use formulas to build a new list that doesn't include selected items. I also built your dynamic validation as wlel. Click to expand... Thank You So much @Luke M for your help. It's very helpful to me. You done exactly what I want. Thanks a lot. by Kutty