unknownymous
Board Regular
- Joined
- Sep 19, 2017
- Messages
- 249
- Office Version
- 2016
- Platform
- Windows
Hello Guys,
I was looking for the codes where I can search for the numbers on the data below so basically it's the [**]
<tbody>
</tbody>
Once I run the codes, I can have below data (number sorted ascending) on another sheet called "Check"
After:
<tbody>
</tbody>
Any help will be much appreciated.
I was looking for the codes where I can search for the numbers on the data below so basically it's the [**]
ID | Subject | Status | Note |
1 | Science [1] | YES | |
2 | Math [49] | NO | |
3 | Health [9] | YES | |
4 | Sports | YES | |
5 | History [29] | YES |
<tbody>
</tbody>
Once I run the codes, I can have below data (number sorted ascending) on another sheet called "Check"
After:
Subject | Number |
Science | 1 |
Health | 9 |
History | 29 |
Math | 49 |
<tbody>
</tbody>
Any help will be much appreciated.