• 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

    Highlight one of duplicates base on values in another column

    This should be an easy one but my brain is sluggish today, so any help is appreciated. I have 2 columns, one with names and other with age. the name column could have duplicates. If a name has a duplicate, I want to highlight oldest person. Is there are conditional formatting formula that we...
  2. S

    Finding Duplicates - multiple criteria - text word order jumbled

    @Faseeh Thanks. Yes, the names will be different each time. I just made up the example to avoid sharing sensitive data. All I want to actually do is remove duplicates, retaining just one unique entry satisfying the A to D criteria and treating the name in E as duplicate irrespective of the word...
  3. S

    Finding Duplicates - multiple criteria - text word order jumbled

    Here's an interesting question for you rockstars. its in 2 parts 1. I have a excel sheet with 6 columns. A, B, C, D, E and F. All columns are text except F. Column E contains the core phrase that I'm interesting in finding duplicates of. A, B, C and D can be looked at as phrases that...
  4. S

    Work on all files in a folder with standard structure

    Thanks a lot for your help Kaushik. Unfortunately I cannot share the workbook. I'll see if can create a dummy workbook if your suggestions hit a roadblock. First let me try them out. Thanks for your time! Shyam
  5. S

    Work on all files in a folder with standard structure

    Thanks Kaushik. I'll try it out. I should have been clearer. Apologies. Yes, C6 has a drop down control through validation, which through various vlookup and other formula changes other values in the sheet (based on the selection). It is a dashboard which I want to set it to 12/7/2012 when...
  6. S

    Work on all files in a folder with standard structure

    I have about a 100 files in a folder (.xlsx) which all have the same 5 tabs in them. I need to do these things on all of them. 1. In Tab named 'Dates', there is a drop down in C6 which has to be set to 12/7/2012. 2. Hide Tab named 'Raw'. 3. Delete Tab named 'Old' Is there Loop routine in...
  7. S

    Median formula with multiple IF in an array involving dates.

    Beautiful! I cleaned up the dates and the array formula works like a charm! Good learning about not mixing up logical operators with Array formulas. Thanks Deb, Narayan and Hui!
  8. S

    Median formula with multiple IF in an array involving dates.

    @Debraj Even DateValue is giving the same #Value error. @Montrey. Not tried Sum product though
  9. S

    Median formula with multiple IF in an array involving dates.

    I'm working on something that i need some help with. I don't see an option to attach a sample Excel file, so here is a sample. Runs from A3 to A354 excluding the heading(heading on A2 and B2) Week Start Volume 1/2/2006 477 1/9/2006 391 1/16/2006 303 1/23/2006 386 1/30/2006 595 2/6/2006...
  10. S

    Create an inventory map on Excel from website content?

    This definitely gives me some new leads. Thanks!
  11. S

    Create an inventory map on Excel from website content?

    i was looking for a ways in which we can link a website to an excel site and maintain a map of the inventory on it. For example, if you look at http://www.amazon.com/kitchen-dining-small-appliances-cookware/b/ref=sa_menu_ki10?ie=UTF8&node=284507 is it possible to maintain a local excel...
  12. S

    Format entries based on 2 metrics

    You are a rock star! Take a bow!
  13. S

    Format entries based on 2 metrics

    Hi Excel Wizards, Probably a easy one! I have a situation such with 3 columns (Name, metric1, metric2) and the goal is to pick one row based on metric1 and metric2 for each of the names. There are multiple entries for each name. I've pasted a sample table below. So for each name, I'd like...
  14. S

    Copy data under specific columns in sheet1 n paste to sheet2 under same headers

    Yes. Chandoo is a great place to start and I'm glad I found it! Thanks! Shyam
  15. S

    Copy data under specific columns in sheet1 n paste to sheet2 under same headers

    I now see the power of VBA and I'm going to allocate some time to learn. Any recommendations on how to learn fast? or study materials online?
  16. S

    Copy data under specific columns in sheet1 n paste to sheet2 under same headers

    You are awesome! Thanks a lot SirJB7. The code works like a charm!
  17. S

    Copy data under specific columns in sheet1 n paste to sheet2 under same headers

    I'm pretty new to VBA and I'm trying to automate a few things and the task at hand is like this: Two sheets in my workbook 'marketing.xlsm'. Sheet1 is the source sheet containing between 5 and 15 columns at different instances but they will always contain the 4 columns alpha, beta, gamma, and...
Back
Top