Forum Discussion
Merged Cells and Filtering
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?
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.
4 Replies
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.
- I ended up doing something similar, thank you
FILTER doesn't work that way.
