Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Old address information updated to current addressi
I want to end up with a spread sheet that uses old information and updates it
to current name and address information I have two spread sheets. SS1 contains 36,000 rows of current information. Each row has separate cells each of which contains either a unique number, a name, an addresses or various other information. SS2 is my target audience and contains 7,000 rows of 2006 information. Each row contains the same separate cell information as SS1. 99% of SS2 unique numbers rows are also in SS1. I want to know which unique number rows on SS2 are also on SS1 by indicating "yes" in a separate column on SS1. Once I have the updated target audience targed on SS1, I will delete the excess rows. I am trying to make sure that I have the current addresses for all the 2006 unique number rows. -- Charles |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Old address information updated to current addressi
Hi,
Let's assume that the information is in column A on both spreadsheets, so in a column in SS1 enter =MATCH(A1,SS2!A:A,0) copy formula down, where there is no match you will see #N/A sort by #N/A and delete these rows if this helps please click yes thanks "Charles" wrote: I want to end up with a spread sheet that uses old information and updates it to current name and address information I have two spread sheets. SS1 contains 36,000 rows of current information. Each row has separate cells each of which contains either a unique number, a name, an addresses or various other information. SS2 is my target audience and contains 7,000 rows of 2006 information. Each row contains the same separate cell information as SS1. 99% of SS2 unique numbers rows are also in SS1. I want to know which unique number rows on SS2 are also on SS1 by indicating "yes" in a separate column on SS1. Once I have the updated target audience targed on SS1, I will delete the excess rows. I am trying to make sure that I have the current addresses for all the 2006 unique number rows. -- Charles |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use current cell address as beginning of macro | Excel Discussion (Misc queries) | |||
Reacting to updated information | Excel Worksheet Functions | |||
updated cell with current time\date if any data in a row has chan | Excel Worksheet Functions | |||
How to resize Data, form with current wksht information | Excel Worksheet Functions | |||
Current date and time updated automatically | Excel Discussion (Misc queries) |