adrienne0914
Board Regular
- Joined
- Mar 22, 2018
- Messages
- 73
- Office Version
- 365
- Platform
- Windows
This is a sample of a worksheet that has hundreds of countries and thousands of charges listed. Rather than having to scroll across and see each country that has charges, I need a formula that returns only the countries that have charges:
[TABLE="width: 600"]
<tbody>[TR]
[TD]Charge[/TD]
[TD]Countries[/TD]
[TD]Argentina[/TD]
[TD]China[/TD]
[TD]France[/TD]
[TD]USA[/TD]
[TD]Totals[/TD]
[/TR]
[TR]
[TD]Forklift[/TD]
[TD]Argentina, France, USA[/TD]
[TD="align: right"]323[/TD]
[TD="align: right"]-[/TD]
[TD="align: right"]210[/TD]
[TD="align: right"]280[/TD]
[TD="align: right"]813[/TD]
[/TR]
[TR]
[TD]Imo Handling[/TD]
[TD]Argentina, France, USA[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]-[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD]Import Fee[/TD]
[TD]China, USA[/TD]
[TD="align: right"]-[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]-[/TD]
[TD="align: right"]190[/TD]
[TD="align: right"]310[/TD]
[/TR]
[TR]
[TD]Logistics Fee[/TD]
[TD]Argentina, France[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]-[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]-[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD]Seal Fee[/TD]
[TD]China, USA[/TD]
[TD="align: right"]-[/TD]
[TD="align: right"]130[/TD]
[TD="align: right"]-[/TD]
[TD="align: right"]240[/TD]
[TD="align: right"]370[/TD]
[/TR]
[TR]
[TD]TOTALS[/TD]
[TD][/TD]
[TD="align: right"]368[/TD]
[TD="align: right"]250[/TD]
[TD="align: right"]255[/TD]
[TD="align: right"]735[/TD]
[TD="align: right"]1608[/TD]
[/TR]
</tbody>[/TABLE]
The "Countries" column has the desired result. Any help would be appreciated.
[TABLE="width: 600"]
<tbody>[TR]
[TD]Charge[/TD]
[TD]Countries[/TD]
[TD]Argentina[/TD]
[TD]China[/TD]
[TD]France[/TD]
[TD]USA[/TD]
[TD]Totals[/TD]
[/TR]
[TR]
[TD]Forklift[/TD]
[TD]Argentina, France, USA[/TD]
[TD="align: right"]323[/TD]
[TD="align: right"]-[/TD]
[TD="align: right"]210[/TD]
[TD="align: right"]280[/TD]
[TD="align: right"]813[/TD]
[/TR]
[TR]
[TD]Imo Handling[/TD]
[TD]Argentina, France, USA[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]-[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD]Import Fee[/TD]
[TD]China, USA[/TD]
[TD="align: right"]-[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]-[/TD]
[TD="align: right"]190[/TD]
[TD="align: right"]310[/TD]
[/TR]
[TR]
[TD]Logistics Fee[/TD]
[TD]Argentina, France[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]-[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]-[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD]Seal Fee[/TD]
[TD]China, USA[/TD]
[TD="align: right"]-[/TD]
[TD="align: right"]130[/TD]
[TD="align: right"]-[/TD]
[TD="align: right"]240[/TD]
[TD="align: right"]370[/TD]
[/TR]
[TR]
[TD]TOTALS[/TD]
[TD][/TD]
[TD="align: right"]368[/TD]
[TD="align: right"]250[/TD]
[TD="align: right"]255[/TD]
[TD="align: right"]735[/TD]
[TD="align: right"]1608[/TD]
[/TR]
</tbody>[/TABLE]
The "Countries" column has the desired result. Any help would be appreciated.