Good day!
I want to make a function formula instructing to list down all the same
records based on the inputed by the user, the thing I can't solve. Below is
the table example.

Table:
A B C D
1 ID NUMBER NAME Course Points
2 1000218 Mandy BS Computer Science 5
3 1000214 Jehu BS Nursing 7
4 1000215 Hernan Civil Engineering 8
5 1000216 Jomar Information Technology 2
6 1000217 Apple Associate in C.S. 4
7 1000218 Mandy BS Computer Science 9
8 1000219 Ermin BS Nursing 7
9 1000218 Mandy BS Computer Science 8
10 1000221 Jay Civil Engineering 3

Sample output result that i want to come out:

input id number: 1000218

1000218 Mandy BS Computer Science 5
1000218 Mandy BS Computer Science 9
1000218 Mandy BS Computer Science 8

Is this possible to do?

Your help is very much appreciated.
Jared

Take a look at DataFilterAutofilter. It does exactly what you want (and a lot
more), although you select the ID from a drop down list, not by entering it in a
cell.

If you really want to have the selected ID entered, it would be a simple macro
to create.

--
Regards,
Fred


"jared" wrote in message
...
Good day!
I want to make a function formula instructing to list down all the same
records based on the inputed by the user, the thing I can't solve. Below is
the table example.

Table:
A B C D
1 ID NUMBER NAME Course Points
2 1000218 Mandy BS Computer Science 5
3 1000214 Jehu BS Nursing 7
4 1000215 Hernan Civil Engineering 8
5 1000216 Jomar Information Technology 2
6 1000217 Apple Associate in C.S. 4
7 1000218 Mandy BS Computer Science 9
8 1000219 Ermin BS Nursing 7
9 1000218 Mandy BS Computer Science 8
10 1000221 Jay Civil Engineering 3

Sample output result that i want to come out:

input id number: 1000218

1000218 Mandy BS Computer Science 5
1000218 Mandy BS Computer Science 9
1000218 Mandy BS Computer Science 8

Is this possible to do?

Your help is very much appreciated.
Jared

The easiest way to do it is to use the AutoFilter.

Select the column header ID NUMBER
Goto the menu DateFilter AutoFilter
Click the drop arrow and then select the ID number of interest.

To remove the filter just goto the menu DataFilterAutofilter. It toggles
on/off just by selecting it.

This could also be done using formulas but it's more complicated and may not
be the best solution if you have 1000's of rows of data.

Biff

"jared" wrote in message
...
Good day!
I want to make a function formula instructing to list down all the same
records based on the inputed by the user, the thing I can't solve. Below
is
the table example.

Table:
A B C D
1 ID NUMBER NAME Course Points
2 1000218 Mandy BS Computer Science 5
3 1000214 Jehu BS Nursing 7
4 1000215 Hernan Civil Engineering 8
5 1000216 Jomar Information Technology 2
6 1000217 Apple Associate in C.S. 4
7 1000218 Mandy BS Computer Science 9
8 1000219 Ermin BS Nursing 7
9 1000218 Mandy BS Computer Science 8
10 1000221 Jay Civil Engineering 3

Sample output result that i want to come out:

input id number: 1000218

1000218 Mandy BS Computer Science 5
1000218 Mandy BS Computer Science 9
1000218 Mandy BS Computer Science 8

Is this possible to do?

Your help is very much appreciated.
Jared