Hi All,
How can i get the pairs details from OEF Status while i enter H1 cell pairs should be display in L3, M3, N3, O3 based on L4 to O4 article+color details which is i have updated in OEF STATUS in L3:L7
And 2nd option if enter SL.No. single article+color pairs while i enter 1 to 5 etc... in H2 cell this pairs should be update based on OEF STATUS M3:M7
It took a while before I grasped your intentions. I've added some formulas to your workbook in the BOM sheet. See if that does what you need. If not, come back here and clarify what's wrong.
Thanks Riny van... I got it my answer in your updated file can u help me again for size wise group pairs
Couldn't come up with an easy formula. Actually, it's quite a monster and works only if you are using E365, 2021 or the on-line version as it includes the FILTER function.
This is how the formula looks like:
If that's causing a problem I would restructure the EOF STATUS table so that every size group has it's own row and total. Than you can use a SUMIFS similar to the formula in the top of the schedule.
there is any other option to work in 2016
As said earlier, then I would restructure the EOF STATUS table so that every size group has it's own row and total. Than you can use a SUMIFS similar to the formula in the top of the schedule.
i tried in sumifs but vertically not working
| ART + Color | Total Pairs | 7½ | 8 | 8½ | 9 | 9½ | 10 | 10½ | 11 | 11½ | 12 | 12½ | 13 | 13½ | 14 | 15 |
| Monmouth Mid (M)- Cascade Brown/Gargoyle | 1,792 | - | - | 123 | 160 | 184 | 258 | 294 | 233 | 184 | 209 | - | 147 | - | - | - |
See if the attached file does what you have in mind, using size groups and a max number of 5 sizes withing each group.
