how do i compare 2 spread sheets if the content of a cell is avai.

H

Hayitsme

On one spread sheet i have all available products.
On the other spread sheet i have a unknown list of products which are
contained in the first spread sheet.
How can i set up a formula to show me all the products not listed on the 2nd
form?
 
S

Saadi

Hayitsme may be this could work.
its from Frank Kabel in return of my question, same as your

- define a name for products name like D1:D100 on sheet 2 for all the
unknown products (menu 'Insert - Name - Define). e.g.
call this name 'sourcelist'
- select first cell of all products like A2 on sheet 1
- goto 'Format - Conditional Format'
- enter the following formula
=COUNTIF(sourcelist,A2)
- choose your format

use this or give us main sheet format that could help me to simplyfy it

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I achieve my xl spread sheet in Alphabetical order 1
how do i insert todays date in a spread sheet just prior to print 2
Excel 2003 make 1 date cell automatically change another date cell 4
copy excel spread sheet & graph to word doc without formulas 1
How do I set a constant multiplier in an equation? 3
Create a document from a spread sheet using data from another spre 1
Formula not being Friendly 3
Compare two sheets and combine into one 2

Top