|
|
#14
04-12-2021, 05:50 AM
|
|||
|
|||
It's maybe late now, but in case you can upgrade to Excel365 or Excel2019, this task will be much easier - like:
Code:
=IF(COUNTIFS($A$3:$A$153,$A3,$F$3:$F$153,"OVERLOADED")>0;"OVERLOADED";MINIFS($F$3:$F$153,$A$3:$A$153,$A3)) Code:
=MINIFS($F$3:$F$153,$A$3:$A$153,$A3) 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Search for specific data in a text string | teligence | Excel | 1 | 05-20-2017 11:51 AM |
| How to get groups of data on each page | aldumil | Mail Merge | 7 | 06-24-2015 01:28 PM |
 Sorting Groups of Data, keeping continuity
|
carter | Excel | 1 | 04-06-2015 01:25 AM |
|
Way to search for a string in text file, pull out everything until another string?
|
omahadivision | Excel Programming | 12 | 11-23-2013 12:10 PM |
|
Assign resource groups to tasks
|
jjmclell | Project | 2 | 12-17-2012 04:28 AM |
Windows 8 
Office 2016
Threaded Mode