I have two cells, A1 and B1, where values for each are from dropdown menus. Any way to clear the contents of B1 automatically if I delete the value in A1? When I try to use a formula to say if A1 is blank, then B1 is blank, but I get the error that what I entered is not part of the drop down...
I've created a list of weekly dates in 2016 that I use to do a vlookup based off of today's date to input that weekly date into cell B2. Can someone show me if a formula can create a perpetual weekly date instead of me having to update the list for 2017 at the end of 2016?
Thanks, Lo Baan...
Hi Chandoo,
I am very impressed with your website and all the experts in your forum. I am a novice at all the functions in Excel. I use Excel 2002 and create a monthly report of states that list 5 different dates for each state representing different stages of project implementation. Dates...
I have worksheet of projects with dates that represent effective dates and I'm trying to get the closest install date from a column range of established install dates without going past. Basically I need to fill the cell next to the effective dates with the closest install date. Probably need a...
I am looking for a template of a simple table that will be used for testing. Each cell will have dedicated answers. In testing, folks will fill in blank cells and then can hit a button that will provide number of correct answers. Also another button that can clear all entries to start test...