Formula or VB Code in a data sheet

Vishaal

Active Member
Joined
Mar 16, 2019
Messages
261
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 ACol B
S.No.Student Work
12
23
36
48
54
62
73
86

<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 ACol BFirstSecondThird
S.No.Student WorkResultAfter how manyResultAfter how manyResultAfter how many times
12
23
36
48
54
62Yes3
73Yes4
86Yes5

<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 ACol B
S.No.Student WorkResultAfter How many times
12
23
36
48
54
62Yes3
73
86
98Yes3
104
115
120
130
147
153Yes6

<tbody>
</tbody>

Hope will get a solution....
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
42,298
Office Version
365
Platform
Windows
... 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

Active Member
Joined
Mar 16, 2019
Messages
261
Hi Peter_SSs,


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

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

Pls
 

Vishaal

Active Member
Joined
Mar 16, 2019
Messages
261
Waiting for any reply
 

Vishaal

Active Member
Joined
Mar 16, 2019
Messages
261
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
 

Forum statistics

Threads
1,082,344
Messages
5,364,803
Members
400,814
Latest member
gangstar67

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top