Query Source :Excel Macros Google Group
Solution Type : User Defined Function
Query by : Lavprasad Kori (MIS Executive, Hindustan UniLever Limited)
Solution by : Ashish Jain (Microsoft Certified Application Specialist;Lead Trainer, Success Electrons)
Query/Problem :
I want an urgent help for the below metioned data.Attaching hererwith the data file.
I want a help to count the zero value if it comes continues 5 times or more than 5 times then count as 1 time & If it comes continue less than 5 times then ignore it.
Solution:
1. Press Alt + F11.
2. Paste the following code there.(Create a User Defined Function)
3. Press Alt+Q.
4. Type “=Count_5_Zeroes()” in AD4 as above in the picture.
5. You’re done in just 4 simple steps.