read data to obtain column counts by column

Danny54

Active Member
Joined
Jul 3, 2019
Messages
295
Office Version
  1. 365
Platform
  1. Windows
How might I go about determining the following excel report

SerialLowModerateimportantCritical
11112​
1​
1​
10616​
1​
1​
10859​
1​

from this sheet?

Thanks


HostSerialDateShipNewText
abc
11112​
1/1/2020​
1/2/2020​
11/6/2020​
Moderate
abc
11112​
1/2/2020​
1/3/2020​
11/6/2020​
Important
def
10616​
1/25/2020​
1/26/2020​
11/6/2020​
Moderate
def
10616​
1/26/2020​
1/27/2020​
11/6/2020​
Low
jhi
10859​
1/31/2020​
2/1/2020​
11/6/2020​
Critical
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
How about
+Fluff v2.xlsm
ABCDEFGHIJKL
1HostSerialDateShipNewTextSerialLowModerateimportantCritical
2abc1111201/01/202002/01/202006/11/2020Moderate111120110
3abc1111202/01/202003/01/202006/11/2020Important106161100
4def1061625/01/202026/01/202006/11/2020Moderate108590001
5def1061626/01/202027/01/202006/11/2020Low
6jhi1085931/01/202001/02/202006/11/2020Critical
Data List
Cell Formulas
RangeFormula
I2:L4I2=COUNTIFS($F$2:$F$6,I$1,$B$2:$B$6,$H2)
 
Upvote 0
Solution
Sweet,

thanks so much. I was thinking that I would have to code a array using vba.
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,223,879
Messages
6,175,148
Members
452,615
Latest member
bogeys2birdies

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
Back
Top