hi there!
Please see the file enclosed? Can someone tell me if there's a way to reproduce data filtered on table from sheet1, so it appears on sheet2, but using formulas or some other way that doesn't require copy and pasting from one sheet to the other?
You can try this in A2 on Sheet2, entered as an array formula with CTRL+SHIFT+ENTER:
Drag down and across through Row 17 and Column F to pick up all possible combinations.
Please Login or Register to view this content.
Spread the love, add to the Rep
"None of us are as smart as all of us."
You can try this in A2 on Sheet2, entered as an array formula with CTRL+SHIFT+ENTER:
Drag down and across through Row 17 and Column F to pick up all possible combinations.Please Login or Register to view this content.
Thank you for your response, mcmahobt!
Can you please tell me how we can make this formula "dynamic" so that on Sheet2 it returns the corresponding values of the rows containing the Name (or Names) filtered in Column A on Sheet1? Your formula has the parameter "A" chosen, and I need the formula to work out for any Name or Names chosen when filtering the column.
I know that multiple combinations are posible (one or MORE Names can be chosen), but could you please show me how the formula would look like in a given scenario (say for example, I choose Names "A" and "C")?
As a matter of fact, there are 10 posible combinations: A, B, C, D, AB, AC, AD, BC, BD, CD. I need a formula to work in any of these scenarios.
Actually, there are more scenarios. I forgot about: ABC, ABD, ACD, ABCD.
See attached. C3:F3 are togglable to enable multiple combinations of names.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks