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

Recent content by amit_gupta123

  1. A

    Combine 2 Cell value with "/" and to exclude repeated values

    Can you share a sample worksheet to understand the requirement in better manner
  2. A

    Averaging Based on Multiple Criteria

    Attaching the file basis image and getting the expected result. Hope that would help. Formula used sumifs & Countifs
  3. A

    Averaging Based on Multiple Criteria

    Hi Joe it would be great if you share an excel sheet as an attachment Thanks
  4. A

    Lookup value in column based on criteria

    Formula used =TRANSPOSE(FILTER(D:D,G3=A:A)) Applicable for office 365
  5. A

    Lookup value in column based on criteria

    Attached
  6. A

    Return Multiple values matching the criterion in column

    Dear Vletm...appreciate your response Please note the following : 1. Looking for results for search list mentioned in sheet 1 out of master data in sheet 2. Sheet 1 might contain 1 lakh records and master is comprising of 20 lakh rows data 2. In the file attached by me, macro is working very...
  7. A

    Return Multiple values matching the criterion in column

    Thanks Ateeb for revert Challenge is I m dealing with millions of rows and hence formulas making it way slower
  8. A

    Return Multiple values matching the criterion in column

    Hi All I am working with 2 million rows and come across a macro for fast lookup which states about Scripting Dictionary object. As i tried to use it, it worked tremendously fast but the issue is when it matches the value in Col A from sheet 1 and searches in master data in Sheet 2, it gives...
  9. A

    Secondary Y axis on chart-2010 version

    Yes, it was a trial and I got stuck there...
  10. A

    Secondary Y axis on chart-2010 version

    Thanks Narayan!!!!! You are a star
  11. A

    Secondary Y axis on chart-2010 version

    Hi.. I am trying to place data on secondary Y axis but no success. Tried but results are not as per expectation. Attaching herewith the sample data. Kindly help where I am missing Regards
  12. A

    Return Multiple matched Values from different worksheets/ Workbooks

    hi... To clarify, "Desired data" sheet contains the subset and data to be pulled from sheet 1 of "Source1" and "Source2". Kindly ignore "Source 3" sheet.
  13. A

    Return Multiple matched Values from different worksheets/ Workbooks

    Thanks P45cal for revert...the challenge is, the attached sheet is trying to pull out unique values from all the sheets and filling the values against them. I am trying to lookup and pull out values for specific data set from the multiple sheets
  14. A

    Return Multiple matched Values from different worksheets/ Workbooks

    Regret for late reply Marc.... It would be multiple files with single worksheet (as given in "Source 1 & "Source 2"). You can eliminate "Source 3" file from consideration.
  15. A

    Return Multiple matched Values from different worksheets/ Workbooks

    Hi All I tried very hard to figure out of fetching multiple match results from different workbooks/ sheets. To brief out, I have named "desired output" having input data in sheet1. There are two different workbooks "Source 1" & Source 2" from which all data to be matched and fetched. Scenario...
See more
Back
Top