Forum Discussion
MatthewO2147
Mar 21, 2022Copper Contributor
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...
- Mar 22, 2022
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.
Riny_van_Eekelen
Mar 22, 2022Platinum Contributor
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.
- MatthewO2147Mar 22, 2022Copper ContributorI ended up doing something similar, thank you