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

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Forum statistics

Threads
1,170,933
Messages
5,872,792
Members
432,947
Latest member
tchurzofretka

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