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