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

    Return Greatest Count based on Criteria

    This should be a quick one, got me stumped. 3 Columns: Account Number, Product Code, and PO Count. Some of the product codes are blank, so I want to return the highest PO Count by Product Code for the same Vendor Number. So, in the example below, I need to return the product code F1 to use for...
  2. M

    Pricing Model: Find price based on 2 non-unique size ranges

    2 sheets, the 1st has a fixed price table with 3 columns: Gauge Range, Width Range, and Price. The 2nd sheet has data with 3 columns: Gauge and Width (exact numbers, not ranges). Taking the gauge and width for an item from the data sheet, I need to look up the price from the ranges in the...
  3. M

    CONTEST: Can you make a dynamic summary data table based on multiple pivots?

    Basic Problem: I want to create a dynamic table that adds rows as necessary, based on a pivot table being refreshed. In Sheet 1, I have 2 data tables. One is based on nine products with daily prices and the other is different products (15) that are tracked on weekly prices. In Sheet 2, I...
  4. M

    Conditional Formatting based on True/False outcome of IF formula

    Simple issue which I believe will have a simple answer, but I cannot figure it out for the life of me. I have an IF formula in a cell, I need to have the cell conditionally formatted green if the result of the IF formula is TRUE, and red if the result of the IF formula is false. Any Ideas?
  5. M

    Sum from 2 lists based on 2 constant 2 changing variables

    Hi all...first time poster, long-time reader. Basically, I want to look at pieces in our inventory and pieces on order from our supplier. If I have pieces in inventory that are greater or equal to in both width and length than the part that has been ordered, I can cancel the order and cut it...
Back
Top