View Single Post
 
Old 04-12-2021, 05:50 AM
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

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))
And when you'll use e.g. value 0 instead of "OVERLADED", it simplifies again!
Code:
=MINIFS($F$3:$F$153,$A$3:$A$153,$A3)
Reply With Quote