Forum Discussion
Solved
Dynamic Filtering Help
Hello-
I need help filtering the difference in settings based on the 9 column headers. I would like to filter differences in adjustments on current setup to adjustments on the next setup, example: I am currently set up for 12oz 4pk and will be switching to 12oz 6pk. Ideally I would see a much more condensed list of adjustments on 12oz 6pk because some of the settings do not change. Is this possible?
| Adj # | Description | Reference Point | 12oz 4pk | 12oz 6pk | 12oz 6pk Half Flaps | 12oz 12pk | 12oz 24pk | 16oz 6pk | 16oz 4pk | 16oz 24pk | 19.2oz 12pk |
| 1 | Magazine Drive Height | Position Indicator | 2.63 | 2.63 | 2.63 | 5 | 7.25 | 1.25 | 1.25 | 1.25 | 2.31 |
| 2 | Magazine Backstop | Position Indicator | 4.23 | 4.69 | 2.99 | 4.62 | 4.62 | 6.05 | 5.79 | 5.79 | 6.13 |
| 3 | Magazine Drive Belt Width | Position Indicator | 5.54 | 7.75 | 7.09 | 10 | 15.62 | 7.75 | 5.54 | 5.54 | 10.38 |
| 4 | Magazine Picture Frame | Change Part | 12oz 4pk | 12oz 6pk | 12oz 6pk Half Flaps | 12oz 12pk | 12oz 24pk | 16oz 6pk | 16oz 4pk | 16oz 24pk | 19.2oz 12pk |
| 5 | Magazine Height | Position Indicator | 6.11 | 5.76 | 6.15 | 8.2 | 10.25 | 6 | 5.62 | 11.64 | 7.63 |
| 6 | Setup Height | Position Indicator | 4.81 | 4.81 | 4.81 | 4.81 | 4.81 | 6.25 | 6.25 | 6.25 | 7.44 |
| 7A-C | Vacuum Cup Width | Scale | 4 1/2" 6 9/16" NA | 4" 6 3/4" 9 5/8" | 4" 6 3/4" 9 5/8" | 4" 8" 12" | 5 1/2" 10 1/2" 15 1/2" | 4" 6 3/4" 9 5/8" | 4 1/2" 6 9/16" N/A | 5 1/2" 10 1/2" 15 1/2" | 5 1/4" 8" 11" |
| 8 | Left Setup Guide | Scale | 5 1/4" | 5 1/8" | 5 1/8" | 7 7/8" | 10 1/2" | 5 1/8" | 5 1/4" | 10 1/2" | 7 3/4" |
| 9 | Right Setup Guide | Scale | 5 1/4" | 5 1/8" | 5 1/8" | 7 7/8" | 10 1/2" | 5 1/8" | 5 1/4" | 10 1/2" | 7 3/4" |
| 10A-C | Case Squaring Width | Scale | 4 7/8" | 7 3/4" | 7 3/4" | 10 1/2" | 15 5/8" | 7 3/4" | 4 1/4" | 15 5/8" | 10 3/8" |
| 11 | Tool Bar | Position Indicator | 5.08 | 7.75 | 7.75 | 10.44 | 15.69 | 7.75 | 5.08 | 15.98 | 10.38 |
| 12 | Right Upper Flap Guide Height | Position Indicator | 4.81 | 4.81 | 4.81 | 4.81 | 4.81 | 6.19 | 6.19 | 6.19 | 7.44 |
| 13 | Right Glue Gun Height | Scale | 1 | 1 | 1 1/4" | 1 | 1 | 1 | 1 | 1 1/4" | 2 1/4" |
| 14 | Right Ram Height | Scale | 1/2" | 1/2" | 1/2" | 1/2" | 1/2" | 1/2" | 1/2" | 1/2" | 1/2" |
| 15 | Right Upper Flap Plow Height | Scale | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 6 1/2" |
| 16 | Load Deck | Change Part | Not Used | C | C | B | A | C | Not Used | A | B |
| 17 | Carton Support Rail | Change Part | Not Used | Not Used | Not Used | Used | Used | Not Used | Not Used | Used | Used |
| 18 | Carton Support Rail | Change Part | Not Used | Not Used | Not Used | Used | Used | Not Used | Not Used | Used | Used |
| 19 | Left Upper Flap Plow Height | Scale | 4 5/8" | 4 5/8" | 4 5/8" | 4 5/8" | 4 5/8" | 4 5/8" | 4 5/8" | 4 5/8" | 6 1/2" |
| 20 | Left Ram Height | Scale | 1/2" | 1/2" | 1/2" | 1/2" | 1/2" | 1/2" | 1/2" | 1/2" | 1/2" |
| 21 | Left Glue Gun Height | Scale | 1 | 1 | 1.25 | 1 | 1 | 1 | 1 | 1 1/4" | 2 1/4" |
| 22 | Left Upper Flap Guide Height | Position Indicator | 5.11 | 5.11 | 5.11 | 5.11 | 5.11 | 6.4 | 6.4 | 6.35 | 7.54 |
| 23 | Selector Bars | Change Part | 2 dot | 2 dot | 2 dot | 3 dot | 4 dot | 2 dot | 2 dot | 4 dot | 3 dot |
| 26 | Preload Air Cylinders Height | Position Indicator | 7 | 7 | 7 | 7 | 7 | 7.45 | 7.45 | 7.45 | 8.75 |
| 30 | Infeed Guides | Scale | 6 1/8" | 8 7/16" | 8 7/16" | 11 | 15 5/16" | 8 7/16" | 6 7/16" | 15 5/16" | 10 7/8" |
| 32 | Infeed Guides | Scale | 12 5/8" | 12 9/16" | 12 9/16" | 15 1/4" | 20 1/8" | 12 9/16" | 12 5/8" | 20 1/8" | 15 3/8" |
| 35 | Tipped Product Flags Height | Scale | 4 13/16" | 4 13/16" | 4 13/16" | 4 13/16" | 4 13/16" | 6 3/16" | 6 3/16" | 6 3/16" | 7 3/8" |
| 36 | Tipped Product Flags | Up/Down | Lanes 1 2 | Lanes 1 2 3 | Lanes 1 2 3 | Lanes 1 2 3 4 | All Lanes | Lanes 1 2 3 | Lanes 1 2 | All Lanes | Lanes 1 2 3 4 |
| 37 | Lane Guide 1 | Change Part | A | A | A | B | B | A | A | B | B |
| 38 | Lane Guide 2 | Change Part | B | Not Used | Not Used | Not Used | Not Used | Not Used | B | Not Used | Not Used |
| 39 | Lane Guide 3 | Change Part | Not Used | A | A | Not Used | Not Used | A | Not Used | Not Used | Not Used |
| 40 | Lane Guide 4 | Change Part | Not Used | Not Used | Not Used | A | Not Used | Not Used | Not Used | Not Used | A |
| 42 | Lane Guide 5 | Change Part | Not Used | Not Used | Not Used | Not Used | A | Not Used | Not Used | A | Not Used |
Not sure I fully understood, but the attached file contains a 365 solution for what you may be looking for. If not, please clarify.
C39:D39 contain dropdown lists for the current and new set-up.
A43 contains the following LET function where the words are either variables declared within LET or named ranges in the worksheet.
=LET( current, XLOOKUP(C39, headers, settings), new, XLOOKUP(D39, headers, settings), FILTER( HSTACK(adjustments, new), current <> new, "No adjustments needed" ) )
Not sure I fully understood, but the attached file contains a 365 solution for what you may be looking for. If not, please clarify.
C39:D39 contain dropdown lists for the current and new set-up.
A43 contains the following LET function where the words are either variables declared within LET or named ranges in the worksheet.
=LET( current, XLOOKUP(C39, headers, settings), new, XLOOKUP(D39, headers, settings), FILTER( HSTACK(adjustments, new), current <> new, "No adjustments needed" ) )this is perfect. Thank you for your help!!
