Forum Discussion
Solved
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...
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.
FILTER doesn't work that way.