Matching 2 digit numbers against 3 digit numbers and counting them with left, right middle

[Brian.Aerojet]

Hi Everyone,

I had a similar question from last week to the one I need this week.

I have added a Excel sheet to show example of what I'm looking to do.

In my excel worksheet attachment I have a column with Dates, a Column with 3 Digit Numbers that are ongoing, a Column with 2 digit numbers (26 of them and will always be the same) and then a column for the formulas that will count the last 3 digit numbers of what is in the 2 digit number column. the formula will go in Column C

I have a formula for Column A, I manually add column B 3 digit number (Only thing I do Manually on my Workbook), Column D was a one time add only (Don't need formula for this), and Column C will be where the new formula Im looking for, It will have formulas continuing beside the 3 digit numbers in column B (Depending on what 2 digit number is in Column D)

I will need the formula to count how many times the 3 digits matched from column D.

I have more notes explaining what im looking for in the attachment.

Thanks,
Brian

[AliGW]

It’s so similar that it does not warrant a new thread. Please continue here: https://www.excelforum.com/excel-for...in-cell-s.html