Mar 21 2022 08:03 AM
I'm trying to merge cells in Column A and then use a filter to display all cells next to it.
Job
A | 1 |
A | 2 |
A | 3 |
B | 1 |
B | 2 |
I want to merge like values in the first column
then run a filter formula
Call these A:6 and B:6
Job | A |
=filter(A1:B:5,A1:A5=B6)
So I could receive and output like
A 1
2
3
Is there any way to do this with the merged cells referencing all cells adjacent to the merged cell?
Mar 21 2022 10:10 PM
Solution@MatthewO2147 You could filter only the second column based on the Job and add a label for the Job (in A11) by directly linking it to the selected Job cell reference (C9), as shown in the picture below.
Mar 22 2022 05:41 AM
Mar 21 2022 10:10 PM
Solution@MatthewO2147 You could filter only the second column based on the Job and add a label for the Job (in A11) by directly linking it to the selected Job cell reference (C9), as shown in the picture below.