Help with filtering

[Lhalkett]

I have a dataset that contains in the first column the name of a company, column b contains two options that apply to that company, so each company could be in the sheet at least twice, then in column c to g contains financials that are associated with each option (column b). I need to consolidate the company names so I only see one entry for each company only, then toggle between column B (the two options), and when I choose one of those, the corresponding data would show only (from column c to g). Is this possible? Help!!

 

[alansidman]

This may be possible with Pivot Tables. I am having a bit trying to envision this and how it would work. Without hands on data, this is the best I can do for you. Perhaps if you provided a few rows of sample data, we could try to determine the best means.

 

[Lhalkett]

Thanks I will supply some data tomorrow

 

[Lhalkett]

[TABLE="width: 1055"]
<colgroup><col width="233" style="width: 175pt; mso-width-source: userset; mso-width-alt: 8521;"> <col width="178" style="width: 134pt; mso-width-source: userset; mso-width-alt: 6509;"> <col width="198" style="width: 149pt; mso-width-source: userset; mso-width-alt: 7241;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;"> <col width="93" style="width: 70pt; mso-width-source: userset; mso-width-alt: 3401;"> <col width="137" style="width: 103pt; mso-width-source: userset; mso-width-alt: 5010;"> <col width="171" style="width: 128pt; mso-width-source: userset; mso-width-alt: 6253;"> <col width="137" style="width: 103pt; mso-width-source: userset; mso-width-alt: 5010;"> <col width="171" style="width: 128pt; mso-width-source: userset; mso-width-alt: 6253;"> <tbody>[TR]
[TD="width: 233"]Service[/TD]
[TD="width: 178"]Package[/TD]
[TD="class: xl63, width: 198"]Which Reduction Package?[/TD]
[TD="class: xl63, width: 87"]Tolerance[/TD]
[TD="class: xl65, width: 93"]Comments[/TD]
[TD="class: xl66, width: 137"] 2016 Base - Total [/TD]
[TD="class: xl66, width: 171"] 2016 One-Time - Total [/TD]
[TD="class: xl66, width: 137"] 2017 Base - Total [/TD]
[TD="class: xl66, width: 171"] 2020 One-Time - Total [/TD]
[/TR]
[TR]
[TD]Program 1[/TD]
[TD="class: xl67"]A[/TD]
[TD]None[/TD]
[TD][/TD]
[TD="class: xl64, width: 93"][/TD]
[TD="class: xl66"] $ (45)[/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl66"] $ (00)[/TD]
[TD="class: xl66"] $ - [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Program 1[/TD]
[TD="class: xl67, bgcolor: transparent"]B[/TD]
[TD="bgcolor: transparent"]None[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl64, width: 93, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"] $ - [/TD]
[TD="class: xl66, bgcolor: transparent"] $ - [/TD]
[TD="class: xl66, bgcolor: transparent"] $ - [/TD]
[TD="class: xl66, bgcolor: transparent"] $ - [/TD]
[/TR]
[TR]
[TD]Program 2[/TD]
[TD="class: xl67"]A[/TD]
[TD]Reduction A[/TD]
[TD][/TD]
[TD="class: xl64, width: 93"][/TD]
[TD="class: xl66"] $ (15)[/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl66"] $ (11)[/TD]
[TD="class: xl66"] $ - [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Program 2[/TD]
[TD="class: xl67, bgcolor: transparent"]B[/TD]
[TD="bgcolor: transparent"]None[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl64, width: 93, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"] $ (11)[/TD]
[TD="class: xl66, bgcolor: transparent"] $ - [/TD]
[TD="class: xl66, bgcolor: transparent"] $ (22)[/TD]
[TD="class: xl66, bgcolor: transparent"] $ - [/TD]
[/TR]
[TR]
[TD]Program 3[/TD]
[TD="class: xl67"]A[/TD]
[TD]None[/TD]
[TD]N/A[/TD]
[TD="class: xl64, width: 93"][/TD]
[TD="class: xl66"] $ (3)[/TD]
[TD="class: xl66"] $ - [/TD]
[TD="class: xl66"] $ (53)[/TD]
[TD="class: xl66"] $ - [/TD]
[/TR]
</tbody>[/TABLE]

 

[alansidman]

Highlight the first row. Select Data on the ribbon. Select Filter. In column B,(Package), using the drop down created by the filter, select A or B.