Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare two tables
I have 2 tables, column A contains ID, col.B names of employes, col.C
element of pays which it's adjustable. Sometime, same names employees are retail. Now, I need whis names are retail and how can I paste only same names on the second sheet, Thanks and regars, Mery |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare two tables
Korisnik "Mery" napisao je: I have 2 tables, column A contains ID, col.B names of employes, col.C element of pays which it's adjustable. Sometime, same names employees are retail. Now, I need which names are retail and how can I paste only same names on the second sheet, Thanks and regars, Mery |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare two tables
Apply a filter to the column which identifies "retail" and select that
from the filter drop-down. Highlight the visible data (plus headings if you have any) and click <copy, then select the other sheet and paste the data into it. Hope this helps. Pete On May 15, 12:11*pm, Mery wrote: Korisnik "Mery" napisao je: *I have 2 tables, column A contains ID, col.B names of employes, col.C element of pays which it's adjustable. Sometime, same names employees are retail. Now, I need which names are retail and how can I paste only same names on the second sheet, Thanks and regars, Mery- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare two tables
Thank's "Pete_UK", problem solved,
Regards, Mery Korisnik "Pete_UK" napisao je: Apply a filter to the column which identifies "retail" and select that from the filter drop-down. Highlight the visible data (plus headings if you have any) and click <copy, then select the other sheet and paste the data into it. Hope this helps. Pete On May 15, 12:11 pm, Mery wrote: Korisnik "Mery" napisao je: I have 2 tables, column A contains ID, col.B names of employes, col.C element of pays which it's adjustable. Sometime, same names employees are retail. Now, I need which names are retail and how can I paste only same names on the second sheet, Thanks and regars, Mery- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare two tables
You're welcome, Mery - thanks for feeding back.
Pete On May 16, 6:38*am, Mery wrote: Thank's "Pete_UK", problem solved, Regards, Mery |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare data in two pivot tables | Excel Discussion (Misc queries) | |||
Please help how to Compare tables in Excel | Excel Discussion (Misc queries) | |||
Need to compare 2 tables to generate 3rd table | Excel Worksheet Functions | |||
How to compare two tables in Access 2000? | Excel Discussion (Misc queries) | |||
compare tables | Excel Discussion (Misc queries) |