Count Duplicate values until a certain value is meet

xKidz

New Member
Joined
Apr 12, 2019
Messages
16
Hi,

My formula is in column C.
I need to count all the multi-drops, leaving out the blanks.
Once row with Column A "First Line" and Column B "Multi-Drop" are meet, restart the count.

This is the formula that i have on Column C


File-Copy-icon.png

<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">=IF(A2="First Line",C3,IF(A1="",C1,IFERROR(MATCH("First Line",A2:A1170,0),COUNTIF(B1:B3670,"Multi-Drop"))))</code>


It does the count as expected but it takes into consideration the blanks as well, and i would like it not to do so.
Any help is appreciated.

My desired results are in Column D, didn't manually input till the end.


619812d1555077568-count-duplicate-values-until-a-certain-value-is-meet-capture.png
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Forum statistics

Threads
1,223,897
Messages
6,175,271
Members
452,628
Latest member
dd2

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