Search results

Bob. Thanks for the excellent link to Debra's site - Now bookmarked. Jeffrey, your solution is perfect and so much more than I wanting to achieve. I especially like the fact that your code deletes invalid entries once 'upstream' choices are changed. Thanks also for providing a descriptive...

Hello all, I hope you can help me? I want to validate a list entry which was originally selected from a list based on a previous list selection. Chandoo's blog on the subject was great for creating a multi list solution...

Dear Chandoo, For 2 years, I have had the need to condense entries from several datatables into 1 sheet so that I have a customer number with entries for each of the tables they appear in - That is to say, I want to combine the datatables into one table that shows every entry in one row for...

Hello all, Chandoo is making me AWESOME with Excel. This site is, for me, the greatest site I know. I've been using it since 2010, when I decided to become a data analyst, regardless of not knowing what one actually was and having no Excel skills. Through the knowledge I've gained with...

Dear Chandoo. Please help me. I have an issue which began last year. Can Excel merge rows like a database does records? Either Formulas or VBA solution would be acceptable. An example would be where customer activity is held on Excel. Each row contains a record of the customers' visit...

Hello shenbagavalli. Although it depends on what your exact requirements and level of complexity are, the short answer is No, absolutely not. I began learning Excel, virtually from scratch, in August 2011. I can now build dynamic and interactive dashboards and still have not used, nor yet...

Luke, After playing with your solution, I began to wonder if it would be possible to select from a range rather than specifying the criteria within the ((ISNUMBER)) arguement? The reason for this is that other values could exist and would be missed if not included into the formula at the...

Luke, That solution is absolutely great. Thank you so much. I could not have come up with that on my own. Additionally, I love that you have condensed the date process with the TEXT function, streamlining the formula. I'm learning a lot from your example and will be looking at my other...

Hello everyone. I wonder if you can help me debug a formula? I need to include several criteria which are parts contained within longer entries. Firstly, let me tell you the criteria; 1-5 are selected from dropdown lists by the user: 1. Month = 11 2. Year = 2011 3. Status = Finished 4...