Posted 2/17/2021 00:42 (#8838307 - in reply to #8837823) Subject: RE: Help with excel formula
Here you go, I created a new sheet that is a copy of CB3 (CB3(2) ). It has the formulas, it does use arrays and at times those needed ctrl+shift+enter to function but it seems to work without. Still puts the curly brackets if you do it that way though. I populated the first few columns, you should be able to get the rest from there with copy paste into the formula bar, then edit the column in the index. Edit the bin name it is searching for to use for other bins. The formulas are setup to be dragged to populate all other rows.