Hello All,
I have 1 excel sheet in which there are around 1000 rows. The excel looks like
<tbody>
</tbody> I need to filter the sheet for age (11,13,22,29) random numbers.
This is just a small example, the original sheet contains some 2000 rows and I need to filter for 200 random numbers and it is really time consuming and hectic to select each number in filter, as this is a regular task now.
Could anyone suggest a way in which I can put the filter for the random numbers.
Thanks in advance for your time and inputs.
I have 1 excel sheet in which there are around 1000 rows. The excel looks like
Name | Age | Roll No. | Address |
abc | 13 | 1 | abc |
bcd | 14 | 2 | bcd |
cde | 13 | 3 | cde |
def | 14 | 4 | def |
efg | 18 | 5 | efg |
fgh | 11 | 6 | fgh |
ghi | 19 | 7 | ghi |
hij | 16 | 8 | hij |
ijk | 22 | 9 | ijk |
jkl | 29 | 10 | jkl |
<tbody>
</tbody>
This is just a small example, the original sheet contains some 2000 rows and I need to filter for 200 random numbers and it is really time consuming and hectic to select each number in filter, as this is a regular task now.
Could anyone suggest a way in which I can put the filter for the random numbers.
Thanks in advance for your time and inputs.