![]() |
#2
|
|||
|
|||
![]()
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)) Code:
=IF(OR($A2="",$B2=""),"",(VLOOKUP($A2,nRT,2,0)>=$B2)) 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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
mylan | Word | 2 | 10-24-2012 12:24 PM |
Send OFT when target email arrives | RandWald | Outlook | 0 | 11-11-2011 10:52 AM |
![]() |
leroytrolley | Excel | 1 | 01-16-2009 04:19 PM |