Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help to filter data from multipule sheets to specific sheet
i have a data in sheet1, sheet2 and sheet3. Data in all sheets have unique
id(number). I have to filter data with unique id in sheet3 if the same unique id exists in sheet1 or sheet2 the data of column B or C incorporated in sheet3 in specified column of the unique id row. Sorry friends my english is not good. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help to filter data from multipule sheets to specific sheet
Hi,
If I didn't misunderstand you you want to compare the ID in sheet3 with the ID in sheet 2 or 1 and if it exist to bring the data from column B , if so use =sumproduct(--(a1=sheet2!$A$1:$A$1000),sheet2!$B$1:$B$1000) if this is not what you are looking for please provide an example mentioning columns and sheet number "Khawajaanwar" wrote: i have a data in sheet1, sheet2 and sheet3. Data in all sheets have unique id(number). I have to filter data with unique id in sheet3 if the same unique id exists in sheet1 or sheet2 the data of column B or C incorporated in sheet3 in specified column of the unique id row. Sorry friends my english is not good. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help to filter data from multipule sheets to specific she
In sheet 1 I have having about 15,000 rows in the following columns
A1(Unique id) A2 Names of persons A3 Address A4 Amount for the year 2005 A5 Amount for the year 2006 A6 Amount for the year 2007 (Blank / no date) In sheet 2 i have 22,500 rows and have following columns A1 (Unique id) A2 Names of person A3 Address A4 Amount for the year 2007 Same above column in sheet 3, sheet 4 and sheet 5 I have to update the rows of column A6 of sheet 1 through column A4 of sheet 2, sheet 3, sheet 4 and sheet 5 "Eduardo" wrote: Hi, If I didn't misunderstand you you want to compare the ID in sheet3 with the ID in sheet 2 or 1 and if it exist to bring the data from column B , if so use =sumproduct(--(a1=sheet2!$A$1:$A$1000),sheet2!$B$1:$B$1000) if this is not what you are looking for please provide an example mentioning columns and sheet number "Khawajaanwar" wrote: i have a data in sheet1, sheet2 and sheet3. Data in all sheets have unique id(number). I have to filter data with unique id in sheet3 if the same unique id exists in sheet1 or sheet2 the data of column B or C incorporated in sheet3 in specified column of the unique id row. Sorry friends my english is not good. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy specific data form sheets into master sheet | Excel Worksheet Functions | |||
Showing Specific Data from Master Sheet to Another Sheet | New Users to Excel | |||
linking data to specific sheets | Excel Discussion (Misc queries) | |||
referencing specific data accross many sheets in a final sheet cha | Excel Discussion (Misc queries) | |||
unable to filter by specific data on a column if the rows exceed 1 | Excel Worksheet Functions |