Join tables like inner join in Access

[ryanp]

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]

Use filtering.

 

[ryanp]

Could u please give more detail? How can I use filtering to extracts data
from two tables?
thanks