• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. L

    Validating a list’s value based on what is selected in another list [SOLVED]

    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...
  2. L

    Combine records from sheets into 1 master record in 1 sheet

    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...
  3. L

    Merge Excel rows like a database does records

    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...
  4. L

    SUMPRODUCT and soundlikes - Help

    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...
Back
Top