formulas with drop down menu
i need a formula so when if in a drop down menu that selection has already
been taken from another drop down menu i can place a message to say that the selection was already used/taken. thanks chris |
formulas with drop down menu
You can "remove" a selection from the list so that it can't be selected
again. See this for instructions: http://contextures.com/xlDataVal03.html -- Biff Microsoft Excel MVP "cele25" wrote in message ... i need a formula so when if in a drop down menu that selection has already been taken from another drop down menu i can place a message to say that the selection was already used/taken. thanks chris |
All times are GMT +1. The time now is 07:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com