Extraction of employees no longer in service

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Extraction of employees no longer in service

FAQ

Thread Tools

Display Modes

03-27-2022, 06:37 AM

p45cal

Windows 10 Extraction of employees no longer in service

Office 2019

Expert

Join Date: Apr 2014

Posts: 962

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'.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with Extraction of Text in 1 TextBox only	Cendrinne	Word VBA	4	11-14-2021 09:55 PM
Log file extraction	xendistar	Excel	0	09-01-2016 02:08 PM
Data extraction from a cell!	JTevez	Excel	2	10-14-2015 11:56 PM
Resources, subcontractors not employees	Gene2720	Project	3	06-11-2013 04:48 AM
Email Extraction	dpad	Outlook	1	08-17-2010 06:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:55 AM.