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

    How to group products by region then rank -- possibly using named ranges?

    I'm stumped! I'm trying to rank counties based on the estimated number of paint cans and shoes (columns F, G and H) and the following critieria: 1st 5 = rank A 6 - 10 = rank B all else = rank D In order to be ranked as an A or B, the minimum volume must be equal to one or greater...
  2. A

    VLOOKUP to return multiple corresponding values across multiple sheets

    In a previous post someone referenced this technique as a fix: http://office.microsoft.com/en-us/excel-help/how-to-look-up-a-value-in-a-list-and-return-multiple-corresponding-values-HA001226038.aspx what if, you needed to search one source and return values accross multiple tabs/sheets...
  3. A

    How to average a list of numbers and exclude 0

    Hello, I've gotten a lot of great info on this site, I figured that I'd ask my question here before anywhere else --- this is my first post. I'm trying to reduce the amount of manual selecting/deselecting of cells somehow. Any help would be greatly appreciated. I have a range of products and...
Back
Top