| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation Formula only worked once.
I have a drop down list in cell B40. In the validation I wrote
=If(A40="","",FORTYB) where "FORTYB" is the name of a list. It worked perfectly, only filling the list if cell 40A had data in it. I then tried to enter the same format in B41 and it gave me an error something to the effect of needing a delimited list. I copied the workbook and tried to redo the same thing I had done in the original A40. Could someone tell me what I have done wrong? I don't even know that it was supposed to work in the first place! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for hr worked that cross 12:00 am | Excel Discussion (Misc queries) | |||
| Formula to work out hours worked | Excel Discussion (Misc queries) | |||
| Need formula to calculate hours worked | Excel Discussion (Misc queries) | |||
| What is wrong with this IF formula, it worked fine for a while? | Excel Discussion (Misc queries) | |||
| Formula that will represent years & months worked | Excel Discussion (Misc queries) | |||
![Rick Arends[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
