Extracting common entries

Hi,

I have a list of application that can reoccur in the list, so.... its somthing like this:

Application A
Application B
Application C
Application A
Application B
Application C

How can I extract the common applicaiton and place them in another spread sheet?

Thanks in advance for any help

thanks it worked,

But is there a formula that I can use instead of using the advanced filters.

I need to create a template so that when the spreadsheet gets used again and again, and the application gets repopulated, the common entries are already extracted because the forumual has been set up.

Thanks in advance for any help.

Calli

Hey,

It help a bit, but I am still confused over how to extract the data into a SEPERATE spreadsheet. I tried using the formula you gave me and adapting the formula so that it recognizes that the data is on a sperate sheet. Well, it obviously didn't work. If you have any more ideas, please let me know.

Thanks in advance for any additional help.

Calli

Hey,

Sorry to bother you again, but the website you gave me doesn't help. I am more confused than I was before,

Here's the scenerio: I have a list below,

Applicaiton A
Applicaiton B
Applicaiton C
Applicaiton D
Applicaiton E
Applicaiton A
Applicaiton B
Applicaiton C
Applicaiton B
Applicaiton C
Applicaiton D
Applicaiton E

I need to setup a formula that will extract into a ANOTHER spreadsheet ONLY the common applications, so I will get something like this:

Applicaiton A
Applicaiton B
Applicaiton C
Applicaiton D
Applicaiton E

Again, thanks in advance for any help you give.

Calli

If the data in column A are static names, then you could use the SUMIF function.

Say if your data was laid out as follows, you could use the formula below to sum them on a separate table.
Col A Col B
ITEM QTY
Application A 25
Application A 25
Application B 30
Application C

Set up the table and then use this:

=SUMIF($A2:$B100,A2,$B$100)

If its not clear, I'll reply again with a spreadsheet sample if you think it may be of use.

Hi Froglet,

I know I'm responding back exceptionally late, but at the time I found a temporary solution. Now I've come up with another problem, similar to what I had before and was hoping you could send me the sample you were talking about in your post.

Thanks,

Calli