VB Code or Formula

Vishaal

Active Member
Joined
Mar 16, 2019
Messages
261
@Vishaal
You will stand a better chance of getting help, if you tell us what you are trying to do.
A lot of members either cannot, or will not, download files for security reasons.
There are some add-ins available here https://www.mrexcel.com/forum/about-board/508133-attachments.html that will enable you to post a small amount of sample data to the board


Excel 2007 32 bit
A
B
2
2​
we need to check the digit of row number 2,3 and 4 in next rows (Row No. 2,3,4 and value is 2,5,6 - we will check 2,5 and 6 from row no. 5 and when we get the any digit 2,5 and 6 we will highlight that row
3
5​
4
6​
5
8​
6
9​
7
3​
8
5​
9
2
We will again start the same thing from here, I mean we will check the digit 2,5 and 3 from row no. 10
10
6​
11
7​
12
9​
13
6​
14
4​
15
1​
16
4​
17
4​
18
7​
19
2
We will again start the same thing from here, I mean we will check the digit 2,7 and 4 from row no. 20
20
9​
21
5​
22
4
We will again start the same thing from here, I mean we will check the digit 4,5 and 9 from row no. 23
23
3​
24
8​
25
9
26
27
28
29
30
31
We also need the report after how many row the digit comes, I mean in the above row answer is
32
After 5 row = 1 (You can check the digit of row no. 2,3,4 comes after five row and it is 2)
33
After 10 row = 1 (You can check the digit of row no. 9,8,3 comes after 10 row and it is 2)
34
After 3 row = 2 (You can check the digit of row no. 19,18,17 (Number are 2,7,4) which comes on row no. 22 & digit of row no.22,21,20 whic comes on row no. 25 after five row)
Sheet: Sheet1
 

Vishaal

Active Member
Joined
Mar 16, 2019
Messages
261
tried to post as you describe but its not looking good due to file is coming on full screen, well try to update a good file next time.

any solution.....
 

Forum statistics

Threads
1,082,037
Messages
5,362,793
Members
400,693
Latest member
jenlj

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