vlookup or countif

aka_krakur

Active Member
Joined
Jan 31, 2006
Messages
438
I run a query that brings back results with a particular column that I'm interested in breaking down even further.
It's a column that has data like this:
1485 - Failure; 1586 - Color; X100; 1785 - N/A

The one thing is that this column's data is never consistently the same size of data. It may only have like one(1) item (ie. X100). SO I can't break it down.

I ultimately would like to create pivot tables based off of the Top 10 failure codes. Right now I have to run a query for each top 10 failure modes. But it would be a lot more advantageous to run a complete query that pulls all data and then a formula somehow splits all these up and counts them and creates a pivot table.
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Forum statistics

Threads
1,136,995
Messages
5,679,037
Members
419,801
Latest member
spinjector

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top