Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 543
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
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
<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
<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,
<tbody>
</tbody>
Hope will get a solution....
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....
