Search results

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

Hui, you sir are truly a master. FWIW, I was convinced it had to be solved by Index/Match with the mins of each range...but I was stuck thinking in a "2 dimensional" table state of mind. 3D is the answer! I'll pivot my price table and put the gauge mins in rows and width mins in columns then...

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

I agree, I'm thinking I'll try to keep the tables intact and come up with some VBA to filter out the blanks from the "IF(ISERROR" results in the Dates column(now column C) when the pivots are refreshed. That should work out perfect...keyword SHOULD. Thanks again for your precise and prompt...

YES! Works perfect dan_l, thanks for your time and expertise! Just for clarification in your step 2 above, you meant to say A:A instead of B:B, correct? Also, a related question I should prob start in a new thread...but this works perfect when I convert my table back to a range. I guess my...

Great, try this: http://dl.dropbox.com/u/7827507/Example%20MHudson.xlsx Thanks

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

Perfect, thanks Luke, worked just as I needed...

Awesome stuff guys...John, it worked exactly as you typed it out, always love that! Now how do I go about altering the formulas if I want to apply each condition to a table of cells? Thanks again!!!

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?

Thanks Hui, almost there. The easiest way I can explain it is: Sum (or even highlight) the CountInventory with greater width and length that are the same Brand and Grade. So for the A-160's the formula would only return 5 because the 2 pcs on line 2 are smaller than the 13 on order on line 3...

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