Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-11-2018, 10:19 AM
ArviLaanemets ArviLaanemets is offline Target Met formula Windows 8 Target Met formula 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

Create an additional sheet e.g. RequestTypes with columns RequestType, Target.

Define the created table as Table (e.g. tRT), or define a dynamical named range (e.g. nRT) which includes datarange of created table.

As a bonus, you can define the data column of RequestType in tRT or 1st column of nRT as named range, and use this named range in your original table as Data Validation List source to select TypeOfRequest values.

Your formula OnTarget formula will be
in case you used defined Table:
Code:
=IF(OR($A2="",$B2=""),"",(SUMIF(tRT[Target],tRT[RequestType],$A2)>=$B2))
in case you used Named Range:
Code:
=IF(OR($A2="",$B2=""),"",(VLOOKUP($A2,nRT,2,0)>=$B2))
The formula returns TRUE when number of workdays is less or egual compared with target for reguest type, and FALSE when otherwise. When either TypeOfrequest or number of workdays remaind empty, an empty string is returned.
There is no limitations for target values - all requests may have same target, or every request type can have different target. It is up to you how you define them in RegustType sheet.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Target Met formula vba to replace old value by target value search almost key words matching manilara Excel Programming 6 11-19-2015 08:19 PM
Insert space before and after target text Marrick13 Word VBA 6 06-20-2014 07:46 AM
Target Met formula Envelope Printing is off target - need help please! mylan Word 2 10-24-2012 12:24 PM
Send OFT when target email arrives RandWald Outlook 0 11-11-2011 10:52 AM
Target Met formula Target line on a excel graph leroytrolley Excel 1 01-16-2009 04:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:13 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