Formula or VB Code in a data sheet

[Vishaal]

Hi and Thanks in advance

i have post earlier some problem and get the solution but that was in complete and also i have lost that post url.

Problem is, i have following sheet

Col A	Col B
S.No.	Student Work
1	2
2	3
3	6
4	8
5	4
6	2
7	3
8	6

<tbody>
</tbody>

In the above sheet i have approx 140 row and in coloumn B, we have approx 70 values

and i want the three different result from this sheet

1 - We will check the value 2, 3 & 6 (S.No. 1, 2 & 3) from the S.No. 4 and when we find the any value we will update it as the given sheet,
After it will check the rest 2 value and we will update it as the given sheet
After getting 2 value, we will start the check last value and update it when we find it according to the given sheet

Col A	Col B	First		Second		Third
S.No.	Student Work	Result	After how many	Result	After how many	Result	After how many times
1	2
2	3
3	6
4	8
5	4
6	2	Yes	3
7	3			Yes	4
8	6					Yes	5

<tbody>
</tbody>

2 - We will check the value 2, 3 & 6 (S.No. 1, 2 & 3) from the S.No. 4 and when we find the any value we will update it as the given sheet,
After that we will again take the value 2,4,8 (S.No. 4, 5 & 6) from the S.No. 7 and when we find the any value we will update it as the given sheet,
After that we will again take the value 8,6,3 (S.No. 7, 8 & 9) from the S.No. 10 and when we find the any value we will update it as the given sheet,

Col A	Col B
S.No.	Student Work	Result	After How many times
1	2
2	3
3	6
4	8
5	4
6	2	Yes	3
7	3
8	6
9	8	Yes	3
10	4
11	5
12	0
13	0
14	7
15	3	Yes	6

<tbody>
</tbody>

Hope will get a solution....

 

[Peter_SSs]

... i have lost that post url.

Try clicking 'Subscribed Threads' towards the top left of the forum.

Another option:
Click My Profile at the top right of the forum.
Towards the top of the left hand column there is 'Find latest posts' and 'Find latest started threads'

 

[Vishaal]

Hi Peter_SSs,


Thanks for help, tried but not find.................

can you please provide the solution............

Pls

 

[Vishaal]

help pls

 

[Vishaal]

Waiting for any reply

 

[Vishaal]

Hello

 

[Vishaal]

Help pls

 

[Vishaal]

Its a good excel challenge, pls provide the solutions if have

 

[Joe4]

This shows you every single post you have made on this board: https://www.mrexcel.com/forum/search.php?searchid=9831219
So you should be able to locate the old URL are talking about (note that there is more than one page).

 

[Vishaal]

Hi Joe4,

Thanks for checking the post and comment

We have already told you that i have search and not find

Also that solutions was incomplete.

So brother, pls if possible pls provide any formula or code,

Again thanks for comment