In this instance, I imported data into a database from a list (text) in
Excel. About 2000 rows. All but about 12 of the rows imported. I pulled the
imprted data back into a spreadsheet and want to find the ones that didn't
import. Can Excel do this automatically or do I have to scroll through all
2000?

"Dave F" wrote:

Well, there are a bunch of ways to compare lists of data, but the answer to
your question depends in part on what you're comparing. Numbers? Text?
Count of items in a list? Alphanumeric text strings?

Etc.

Give us some info on what you're comparing.

Dave
--
Brevity is the soul of wit.


"DeeKayT" wrote:

I would like to find a way for Excel to automatically point out differences
between two lists. Can be either two worksheets or workbooks. I knwo how to
compare side by side but want Excel to do the work.