ExcelBanter - Join tables like inner join in Access

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Join tables like inner join in Access (https://www.excelbanter.com/excel-discussion-misc-queries/195315-join-tables-like-inner-join-access.html)

ryanp

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

Gary Brown[_4_]

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

ryanp

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

All times are GMT +1. The time now is 07:35 PM.