Recent content by cabbey77

'Actual_Delivered_Bushels__c','Buyer__c','BuyerBasis__c','BuyerCashPrice__c','BuyerPriceLockPrice__c','Delay_Reason__c','DeliveryWindowEnd__c','GrossBushels__c', Grower__c', 'GrowerBasis__c', 'GrowerCashPrice__c', 'GrowerPriceLockPrice__c'. Order doesn't matter in the very least.

I have: <b>parent_id &emsp;&emsp;action &emsp;&emsp;&emsp;&emsp; first_date&emsp;&emsp; latest_date</b> abc123&emsp;&emsp; BuyerPriceLockPrice__c &emsp;&emsp;&emsp;&emsp; 9/30/2019 &emsp;&emsp; 9/30/2019 abc123&emsp;&emsp; BuyerBasis__c&emsp;&emsp;&emsp;&emsp...

Thank you!!!!

If there is a kit in the row that matches the first kit within that SDDOCO range, that should be selected, if not, then it should be the first kit in the current row.

Zelgar, Many times what is in Col E does from Col G, but only due to the fact that columns G:O are actually in a ranked order. I have provided an updated spreadsheet, whereby you can see that this does not happen all the time. You can find examples on rows 14,15,16 to start, and again at...

The attached revised file has expected results highlighted in orange.http://files.engineering.com/getfile.aspx?folder=84f50c33-9f0c-4ee6-b6fa-4fea7e152a01&file=Layered_Match_Index.xlsx

Oh my gosh, you are so right, I was inconsistent, I do apologize! No there should be no blank rows! Thank you for putting up with my inability to communicate this clearly, and continuing to help. It is greatly appreciated.

Skipvought, I am thoroughly confused by your previous post. "For rows 6 & 7 the Total Of ParentItem is not 1" both of them are indeed 1 on my sheet. You are correct in that there no assigned Kits to look up yet, but there will be as soon as the formula is dropped in, its feeding off it's...

Unfortunately, this is actual data I am having to work with, so I can make the test set bigger, but that wouldn't change what needs to happen. What I can do is see if I can clarify. Utilizing the revised attached spreadsheet: Look in columns G through O of the selected row for any kit number...

Please see attached. Assigned kit column is where I want to put the formula, rows 6 and 7 have 1 each parent kit as listed to the right in column M, 5601KITA for both. Thanks for the...

For column Assigned Kit, I am looking to input column M if the Total of Parent Item is a 1, if it is not a 1, I need to look and see if columns M:U match any Assigned Kit within the same SDDOCO range, and if not give me column M, if so give me the match. Row 2 should be DHRSKITA, 3: 5361KITA...

Hello, I have a Pivot Table whereby I am performing a running Percentage outside of the pivot table. The Table is as follows: Hub (grouped) Comp Desc Qty by Wk Total The running subtotal formula works for the 1st hub but not subsequent due to the hard reference to $AE$5...

There are many more Anaheim rows. The summary table should pull from the column indicated in the formula from the Anaheim row where the 2nd column (Kit #) that matches the selection in the A1 dropdown list. When the kit # in the Drop Down List is changed, the data should change. So...

Summary DSDSKITA/1 SMALL SCREW SYSTEM IMPL KIT ANAHEIM #REF! 0 0 0 0 -1 AUSTIN #N/A 1 0 0 0 0 -1 BIRMINGHAM #REF! 1 0 0 0 0 -1 Lookup ANAHEIM 2488KIT1 4 1 0 0.20 0.38 1 1 ANAHEIM 86MX1X12 2 1 0 0.10 0.28 1 1 ANAHEIM 86PSKIT1 6 1 0 0.29 0.44 1 1 ANAHEIM 86PSKIT2 2...

Whoops Link Link