VBA code or any formula

Vishaal

Active Member
Joined
Mar 16, 2019
Messages
393
Office Version
  1. 2010
  2. 2007
Platform
  1. Windows
  2. Web
Hi
I have a sheet where we have 15 values in a row
22
44
23
44
55
48
58
32
52
29
33
44
25
56
55
Now i want to know how many times 20 to 30 come in row 1 to 15 in continuing.
And
If i want to put a value, how can, i mean
If 10 to 20 comes in first row then A grade
Again If 10 to 20 comes in second row then B grade
If 10 to 20 not comes in in third row then C grade
If 10 to 20 not comes in fifth row then D grade

Formula will check the continuing of come 20 to 30 or not and It will check and give grade if 20 to 30 comes after 2 day, it will put e grade, if its come after 3 day then f grade
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
Now i want to know how many times 20 to 30 come in row 1 to 15 in continuing.

I hope this helps

Excel Workbook
AB
1
2224
344
423
544
655
748
858
932
1052
1129
1233
1344
1425
1556
1655
Hoja11
 

Vishaal

Active Member
Joined
Mar 16, 2019
Messages
393
Office Version
  1. 2010
  2. 2007
Platform
  1. Windows
  2. Web
Thanks bro, point one solved, pls help in other point also
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
You're welcome.

You can give examples of what you expect at each point
 

Vishaal

Active Member
Joined
Mar 16, 2019
Messages
393
Office Version
  1. 2010
  2. 2007
Platform
  1. Windows
  2. Web

ADVERTISEMENT

Thanks again bro...

I want this
Pls check the given sheet where we have 14 values in a row,
Row no. 22 40
1. 44 0
3. 23 60
4. 44 0
5. 34 60
6. 29 40
7. 29 40
8. 41 0
9. 52 0
10. 29 80
11. 46 0
12. 44 0
13. 48 0
14. 35 90

If u check then find that if the value between 20 to 40 come regular, a certain value 40 comes (row no. 6 &7)

And if the value between 20 to 40 come after one gap, a certain value 60 comes (row no. 1, 3, 4, 5)

And if the value between 20 to 40 come after double gap, a certain value 80 comes (row no. 8,9,10)

And if the value between 20 to 40 come after three continuing gap a certain value 90 comes (row no. 11,12,13,14)

I hope it will clear the point, pls provide any help.....bro
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows

ADVERTISEMENT

Can you explain your example, do not appreciate it well, what do you have and what do you expect from the result?
You could upload some images with explanations.

You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,510
Messages
5,523,318
Members
409,511
Latest member
hitesh222002

This Week's Hot Topics

Top