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

  1. S

    Highlight one of duplicates base on values in another column

    Thanks guys. Appreciate it.
  2. 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...
  3. 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...
  4. 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...
  5. 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
  6. 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...
  7. 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...
  8. 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!
  9. 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
  10. 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...
  11. S

    Create an inventory map on Excel from website content?

    This definitely gives me some new leads. Thanks!
See more
Back
Top