Despite my best efforts going round in circles on a simple problem. Help gratefully accepted....
If say, Cell A1 can have two values - "In" or "Out" and cell B1 can have a date or have no date in it;
1. I want to say if you find "In" or "Out" in cell A1 and cell B1 has a date in it, return a null.
2. I want to say if you find "In" or "Out" in cell A1 and cell B1 has no date in it, return "No Date".
My best attempt yet was
I know its simple for an experienced user but sending me daft - many thanks
May I extend the question to a related bit for the formula below? Its when there is a choice of two different cell contents that catches me. I will sit and understand your kind reply which has worked very well.
I need to search a range in a single column and if cells contain word In or Out total the number of dates in adjacent column that are =to or before todays date. The formula above works but onlly for cells tagged "In"
Thank you for all your help. It has saved me so much time for something which is very important. I have been able to get on with the job while I will go through the formula when a little bit more quiet and make sure I understand how it was put together. Thanks again.
Thank you so much for your patience, help and time. You have helped me produce far more superior statitsics and overview than I would have been able to do. It was kind to share your workbook. Once I have my sheet updated (there are a few pages not just one!) I will sit down and try and learn from your help. Again thank you so much.
I was just perusing the test work book when it dawned on me and now I feel like such a dork! I became so absorbed with the SUMPRODUCT function that I forgot all about a simple COUNTIF function that would do the task for you:-