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
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
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..............