Thread: [Solved] Extraction of employees no longer in service
View Single Post
 
Old 03-27-2022, 06:37 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
In cell T2:
Code:
=COUNTIFS($K$2:$K$10,"",$B$2:$B$10,B2)=0
and copy down.
This assumes that a blank column K (DT_Cessazione) means that person is still employed.
This results in True/False. You can use this formula in conditional formatting and in whatever you mean by 'Extraction' or 'extrapolate'.
Reply With Quote