If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
using vlookup help
Every few weeks I get an excel sheet which consists of several columns of
items. The first column is the name of the complete item and across the sheet each subsequent row contains the parts contained in the finished ( complete ) item. When I get a new sheet there are additions in the sheet and sometimes removed rows . How can I use vlookup to list the new / removed items ? Right now I have to manually view both sheets and go through them to see the new/deleted items. |
#2
|
|||
|
|||
using vlookup help
Use conditional formatting to highlight the new and the deleted items.
You can do it with a formula such as =COUNTIF(Sheet1!A:A,A1) and pick a format colour. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "-keevill-" wrote in message ... Every few weeks I get an excel sheet which consists of several columns of items. The first column is the name of the complete item and across the sheet each subsequent row contains the parts contained in the finished ( complete ) item. When I get a new sheet there are additions in the sheet and sometimes removed rows . How can I use vlookup to list the new / removed items ? Right now I have to manually view both sheets and go through them to see the new/deleted items. |
Thread Tools | |
Display Modes | |
|
|