Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

extremley urgent excell problem

Posted on 2011-10-26
5
Medium Priority
?
228 Views
Last Modified: 2012-05-12
Hi Guys

I have 2 spreadsheets, the information in three columns is the same on both spreadsheets
 being that

columns in sheet 1  F= Track   G = Artist   E = Album
Columns in sheet 2 B = Track  C = Artist  D= Album

in sheet 1 there are 43656 rows
in sheet 2 there are 5593 rows

i need to remove the information that is in sheet 2 from sheet1 and put the difference in sheet 3

This one is really urgent
can anyone help me with this one

Jimbo
0
Comment
Question by:Jimbo1954
5 Comments
 
LVL 14

Expert Comment

by:sentner
ID: 37031088
Does the entire row need to match, or is one of the fields going to be unique?  
0
 
LVL 1

Expert Comment

by:galbaneto
ID: 37031138
I don't know if there is a 1 step process for that. In excell you can remove or highlight the differences between two columns, that being said, you can remove from sheet 1 the duplicates and work with the conditional function to capture the differences and send to sheet 3.

Take a look on this Microsoft support site:

http://office.microsoft.com/en-us/excel-help/filter-for-unique-values-or-remove-duplicate-values-HP010073943.aspx

I hope it helps.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 37031286
Jimbo,

Couple of questions, please...
(1) Is this a one-off, or will you be doing this regularly?
(2) If the answer to (1) is "Yes", can you upload the file here?

Thanks,
Brian.
0
 

Accepted Solution

by:
Jimbo1954 earned 0 total points
ID: 37031854
Sentor,galbaneto,and Redmondb

thank you all for replying

i managed to find digdb,that had a tool to solve my problem

but thank you all again
0
 

Author Closing Comment

by:Jimbo1954
ID: 37398696
Thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question