• 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

    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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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