Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 10-01-2025, 10:41 PM
ArviLaanemets ArviLaanemets is offline Information about cell - any formula existing which is linked to it Windows 8 Information about cell - any formula existing which is linked to it Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Are every one of tabs 2-7 for specific language? I.e. you removed all references to specific 3 languages? When this is the case, then:
In table on sheet Tab1, add (temporarily) 2 additional columns. Into one of them insert a formula, which checks the table on Tab4 containing a current value of Language4 column in Tab1, and returnig some value (e.g. TRUE or FALSE) depending the result. And into another one the formula, doing likely check for current value of Language7 in Tab1 and Tab7.

Now you can set Autofilter for Tab1 to be both of those added columns indicating the match was not found (e.g. both columns have FALSE in them). Filtered rows are the unused ones.

If each of Tab2-Tab7 did have links to several language columns in Tab1 (i.e. the division between them was not based on language), then there in not enough info in your post, to decide how to filter the unused rows.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Information about cell - any formula existing which is linked to it What formula can I use to get the information herodot Excel 6 08-15-2021 05:45 AM
Information about cell - any formula existing which is linked to it How can i add to a cell address? My existing formula isn't working. Footahype Excel 7 02-02-2019 01:19 PM
Information about cell - any formula existing which is linked to it Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula innkeeper9 Excel 2 09-13-2016 08:59 PM
Information about cell - any formula existing which is linked to it Can Tables or Information be Linked in Word? ddrowe Word 1 11-18-2011 11:50 AM
Information about cell - any formula existing which is linked to it Updating Existing Information akshaygopale Office 5 06-22-2011 06:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:42 AM.


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