Thread: [Solved] Target Met formula
View Single Post
 
Old 06-11-2018, 11:23 PM
ArviLaanemets ArviLaanemets is offline Windows 8 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
Here are 2 variants with same outcome - one using Named Ranges, another using defined Tables (and a Named Range lRT as Data Validation Source, because Data Validation doesn't allow to use Table formulas).
Attached Files
File Type: xlsx TargetWorkbook_Names.xlsx (11.8 KB, 14 views)
File Type: xlsx TargetWorkbook_Tables.xlsx (14.4 KB, 12 views)
Reply With Quote