Ooops!

I posted the wrong sample file!

Try this one:

http://cjoint.com/?jxhE0xClWR

Biff

"Biff" wrote in message
...
Do you think this will work?

Yes.

Do you think my above array formula will grind the system to a halt?

No.

Did you have the same formula in mind?

No. I had something completely different in mind. Not everyone likes to or
can use filters (me included) or, you might need this data on another
sheet AND you want it to be dynamic (not filter then copy/paste). (one of
the reasons I don't like filters) Then what do you do?

You do this:

Sample file: Extract_data 19kb

http://cjoint.com/?jxgj2rCtO0

The file is based on this thread. Select an ID number from the drop down.
The highlighted area is where the formulas are located. Actually, it's one
formula copied to all the cells.

For a detailed explanation see this:

http://tinyurl.com/j2x2w

Biff

"Epinn" wrote in message
...
Biff,

If I understand correctly, with AutoFilter custom we can only select a
maximum of two ID's at a time. Am I correct? If Jared wants to see all
ID's that are duplicated, can he try the following?

Sort column A that contains the ID number.

Put the formula in a blank column, say G.

=IF(COUNTIF(A:A,A2)1,"Duplicate","")

Please note that the formula is an array formula i.e. must be entered with
ctrl+shift+enter.

The argument for COUNTIF is A2 assuming row 1 is the column heading and A2
is the first piece of data. Adjust accordingly based on the number of
rows for headers.

Fill column G with the formula.

Then do AutoFilter to select "Duplicate" in column G.

Then sort on column A, ID no. again. Not really necessary.

Do you think this will work?

<<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.

Did you have the same formula in mind? Do you think my above array
formula will grind the system to a halt?

Appreciate guidance.

Epinn

"Biff" wrote in message
...
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