| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Join tables like inner join in Access
Hi,
Is there anyway we can join tables in Excel like inner join in Access. It will extracts data from 2 tables where the values of the joined fields match |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Join tables like inner join in Access
Use filtering.
-- Hope this helps. Thanks in advance for your feedback. Gary Brown "ryanp" wrote: Hi, Is there anyway we can join tables in Excel like inner join in Access. It will extracts data from 2 tables where the values of the joined fields match |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Join tables like inner join in Access
Could u please give more detail? How can I use filtering to extracts data
from two tables? thanks "Gary Brown" wrote: Use filtering. -- Hope this helps. Thanks in advance for your feedback. Gary Brown "ryanp" wrote: Hi, Is there anyway we can join tables in Excel like inner join in Access. It will extracts data from 2 tables where the values of the joined fields match |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you combine tables (represent a "join") in Excel? | Excel Discussion (Misc queries) | |||
| MS Query Outer join with three tables | Excel Discussion (Misc queries) | |||
| how do i join 2 excel spreadsheets into access & import it back | Excel Discussion (Misc queries) | |||
| join two spreadsheets | Excel Discussion (Misc queries) | |||
| join 2 spreadsheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
