• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to get the how many times this come in this sheet

Vishaal

New Member
Hi Mickg, thanks for your previous help, pls check the below table and provide any solutions like macro/vb code

we have a data in excel and want to check that how many times a certain task will repeat, you can understand it by checking the below excel

60340

Result
1. we have found that after 7 row we find the value one time
2. we have found that after 6 row we find the value one time
3. we have found that after 4 row we find the value two time

so the result is

After 7 = 1
After 6 = 1
After 4 = 2

pls help any code..............
 
Vishaal
Waiting for logic of Your challenge ...
eg the number one ... comes after four rows ...
You have there 'result' and
after that ... You have again 'the result'
 
Vishaal
Waiting for logic of Your challenge ...
eg the number one ... comes after four rows ...
You have there 'result' and
after that ... You have again 'the result'

okkkkkkkkk
you are wrote that number one comes after four rows, yes it will start the search after four rows and when find the digit it will stop and again start the searching from here, new digits you can understand it by viewing the excel

note : its note necessary the chart will be same, may be first three digits will come find on 5th or 6th and when we find the digit it stop and start again from here the new digits
 
Back
Top