Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 12-03-2023, 08:03 AM
p45cal's Avatar
p45cal p45cal is offline extract data from table based on data from another table Windows 10 extract data from table based on data from another table Office 2021
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

In the absence of a workbook:
Code:
=FILTER(TableA,ISNUMBER(MATCH(TableA[ID],TableB[ID],0)),"None found")
Reply With Quote
 

Tags
extract criteria



Similar Threads
Thread Thread Starter Forum Replies Last Post
extract data from word table thiennguyen93 Word VBA 1 07-27-2022 07:16 AM
Extract data from multiple table a4avinash Excel 4 02-28-2022 08:30 AM
extract data from table based on data from another table Automatically extract data from a table into another word document OfficeAssociate99 Word VBA 1 05-28-2017 11:19 PM
extract specific pivot table data to a new sheet theexpat Excel Programming 0 02-18-2016 10:08 AM
extract data from table based on data from another table How to Extract Data from table based on pattern. PRA007 Word Tables 4 03-17-2015 11:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft