• 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. S

    Create unique code based on given string

    Hi again, Seems I wasn't quite clear - there is country column. So final code would be in 5 symbols: CountryCode + 2 characters from description. Updated file attached.
  2. S

    Create unique code based on given string

    Hi Narayan, VBA is ok. Please find attached full list with possible entries.
  3. S

    Create unique code based on given string

    Hello! I'm in stuck with my problem. Kindly please help. Let's say I have a list of locations and I need to create unique codes for each of them. Conditions are: 1. The code should contain 2 letters and can not be duplicated. 2. The first code letter = The first location letter 3. The second...
  4. S

    Data collection from database based on multiple criteria

    Thank you!
  5. S

    Data collection from database based on multiple criteria

    Hello John, Could you please help me to find solution to my problem. The problem is that additional condition should be added - Max date cannot be greater than last month day. For example if Driver4 was in the same country some days in a row but in different months, report should generate...
  6. S

    Data collection from database based on multiple criteria

    Hello John, Thank you! It's works perfect.
  7. S

    Data collection from database based on multiple criteria

    Hi PCosta, Thanks for quick reply. I added more drivers but pivot table did not worked in order. for example Driver 2: i need to show: Driver 2 2016.11.02-2016.11.03 Poland but report show two rows: Driver 2 2016.11.02-2016.11.02 Poland Driver 2 2016.11.03-2016.11.03 Poland I've attached...
  8. S

    Data collection from database based on multiple criteria

    Hello! I've a problem and I'm stucked in finding of it's solution. Please refer to attached file. There's a sheet "Data" where data are inputted and a sheet "CollectedData" in which I need to generate report from "Data" sheet by month criteria. I've entered manually how report should look...
  9. S

    INDEX&MATCH with multiple conditions doesn't work for string values

    Dear all, Thank you all for answers. They really helped(just wanted to find out why formula works when ID is number but do not work if ID contains letter or is string), but things are more complicated. I'm attaching a fragment from my tables, with real formula I use. Tried to apply all yours...
  10. S

    INDEX&MATCH with multiple conditions doesn't work for string values

    Hello! I'm in stuck finding solution how to get data that match multiple conditions using INDEX&MATCH array formula. Please refer to attached file. Formula works if ID is number, but do not work if ID contains letter or is string. Thanks in advance!
Back
Top