Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Collate data from one spreadsheet into another spreadsheet
I have two spreadsheets. Spreadsheet A has a list of 500 clients. Spreadsheet
B has a list of over 5000 members. I need to know if any of the 500 clients in Spreadsheet A appear in Spreadsheet B, then collate this data in a new spreadsheet. We can assume the members' first name and surname are in separate columns. There is also a column with each member's account number. Is there a formula that can locate and extract the data I need? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Collate data from one spreadsheet into another spreadsheet
Suppose you have the members account number in ColA of both sheets; then try
the below in Sheet1 (500 records) which will check the membership number in ColA of Sheet2 (5000 records)..and return the text "Found" or return blank...Copy the formula down and once done you can sort the formula column and copy paste the data to a different sheet... =IF(COUNTIF(Sheet2!A:A,A1),"Found","") If this post helps click Yes --------------- Jacob Skaria "Anthony" wrote: I have two spreadsheets. Spreadsheet A has a list of 500 clients. Spreadsheet B has a list of over 5000 members. I need to know if any of the 500 clients in Spreadsheet A appear in Spreadsheet B, then collate this data in a new spreadsheet. We can assume the members' first name and surname are in separate columns. There is also a column with each member's account number. Is there a formula that can locate and extract the data I need? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Collate data from one spreadsheet into another spreadsheet
Excel 2007 Tables
Extract data from 2 tables and consolidate. No formulas or code used. Ranges dynamic. Assumes account# appears only once. http://www.mediafire.com/file/mfgno0h0yte/10_19_09.xlsx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking 2 spreadsheet using data from 1st spreadsheet | Excel Discussion (Misc queries) | |||
Variable data from one spreadsheet sent to new spreadsheet | New Users to Excel | |||
Can I pull data from a spreadsheet to another spreadsheet | Excel Discussion (Misc queries) | |||
How do I copy spreadsheet data as shown to another spreadsheet? | Excel Discussion (Misc queries) | |||
summarize data from one spreadsheet to other spreadsheet | Excel Worksheet Functions |