Comparison of Data

L

Lisa

Hi

I have a list of names and address in Excel, some have which have been
worked on and changed. I cannot find a forumla or function which will enable
me to compare my before and after lists in order to indicate what has
changed?

Does anyone know how I could do this?

Thanks
 
B

Bob Buckland ?:-\)

Hi Lisa,

You may want to use the link below to also post in the MS Office Excel discussion group. When posting there please include the
version of MS Excel you're working with and what comparison result you're looking to find (i.e. just to note which ones are
different before/after, or specific detail of the change for example) and a description of how the two lists are laid out and if in
a single file or multiple files.

==========
Hi

I have a list of names and address in Excel, some have which have been
worked on and changed. I cannot find a forumla or function which will enable
me to compare my before and after lists in order to indicate what has
changed?

Does anyone know how I could do this?

Thanks>>
--
Please let us know if this has helped,

Bob Buckland ?:)
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com
 
L

Lisa

Hi Bob

Thanks for your response, I'll do that

Bob Buckland ?:-) said:
Hi Lisa,

You may want to use the link below to also post in the MS Office Excel discussion group. When posting there please include the
version of MS Excel you're working with and what comparison result you're looking to find (i.e. just to note which ones are
different before/after, or specific detail of the change for example) and a description of how the two lists are laid out and if in
a single file or multiple files.

==========
Hi

I have a list of names and address in Excel, some have which have been
worked on and changed. I cannot find a forumla or function which will enable
me to compare my before and after lists in order to indicate what has
changed?

Does anyone know how I could do this?

Thanks>>
--
Please let us know if this has helped,

Bob Buckland ?:)
MS Office System Products MVP


LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com
Click to expand...
 
S

Steve Rindsberg

Hi

I have a list of names and address in Excel, some have which have been
worked on and changed. I cannot find a forumla or function which will enable
me to compare my before and after lists in order to indicate what has
changed?

Does anyone know how I could do this?
Click to expand...

Assuming you mean that you have two lists, you could save each to Comma
Separated Value (CSV) or similar, then use the FC utility from a command prompt
to compare the two.

Compare the files, put the differences in a text file called DIFFS.TXT:

FC FirstFile.csv SecondFile.csv > Diffs.TXT

To get FC help:

FC /?
 
Top