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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

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

Excel 2003 make 1 date cell automatically change another date cell 3
Cask beer being recognised by UNESCO as a UK intangable part of British life and its brewing and cultural history. i may not have said that very well 5
Create a document from a spread sheet using data from another spre 1
How do I set a constant multiplier in an equation? 3
Cleaning up spread sheets 1
Macro that Finds the First Value in a range using a Combobox (drop down menu) 2
Inserting rows in a protected sheet - Office 2003 2
formula 2 display selected objects ONLY in new sheet from another 1

Back
Top