Excel - Search entire column for string

[gfuentes4]

Hello,

I am not sure I am finding a way to do this online.

I want to count the number of times something happens each month by searing an entire column for a string value. If that specific string value is found, then check the corresponding column over to see if it matches a specific month, if it does, then add +1.

Example


This is where I would want everything to be copied to:

Incidents		Jul-17	Aug-17
Running		1	1
Jogging			1
Talking			1
This is where I would be comparing the data from a different sheet: Date Classification 7/16/2017 Running 8/22/2017 Running 8/28/2017 Jogging 8/31/2017 Talking <tbody> </tbody>

<tbody>
</tbody>

 

[Eric W]

Based on your image from post # 3, my original formula should work, IF the ranges are correct, AND the dates in the top row are actual dates of the 1st of the month. Since that image doesn't show the row/column indicators, I can't help adjust the ranges for you in the formula.

If the dates are text values, there are other options, such as a hybrid from sunilbsrv2k's formula.

If you wish to show an Excel readable table, check out the HTML Maker link in my signature, that's what I used. The process is pretty simple, and there's even a YouTube instructional video if you have questions. You're more likely to get help if people can copy your data and test with it directly.