ScottishLass
New Member
- Joined
- Oct 17, 2017
- Messages
- 1
Hello I'm having trouble with a spreadsheet I have created. When I turn on the filter I can't get the information to display as I want. Please see example layout below.
<tbody>
</tbody>
If I filter column B on Jane Brown to see how many Committee's she is on the result is this
<tbody>
</tbody>
I want column A to show that she is on Committee 1 and 4. I don't want to duplicate the Committee's all the way down column A. Any help would be much appreciated!
A | B |
Committee 1 | Joe Smith |
Jane Brown | |
Committee 2 | Alex Davies |
Heather Nimmo | |
Committee 3 | Tom Munro |
Jake McDonald | |
Committee 4 | David Clark |
Jane Brown |
<tbody>
</tbody>
If I filter column B on Jane Brown to see how many Committee's she is on the result is this
A | B |
Jane Brown | |
Jane Brown |
<tbody>
</tbody>
I want column A to show that she is on Committee 1 and 4. I don't want to duplicate the Committee's all the way down column A. Any help would be much appreciated!