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]

Service	Package	Which Reduction Package?	Tolerance	Comments	2016 Base - Total	2016 One-Time - Total	2017 Base - Total	2020 One-Time - Total
Program 1	A	None			$ (45)	$ -	$ (00)	$ -
Program 1	B	None			$ -	$ -	$ -	$ -
Program 2	A	Reduction A			$ (15)	$ -	$ (11)	$ -
Program 2	B	None			$ (11)	$ -	$ (22)	$ -
Program 3	A	None	N/A		$ (3)	$ -	$ (53)	$ -

<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> </tbody>

 

[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.