Excel document - FTE only

%3CLINGO-SUB%20id%3D%22lingo-sub-1935680%22%20slang%3D%22en-US%22%3EExcel%20document%20-%20FTE%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1935680%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHow%20can%20I%20make%20an%20Excel%20document%20FTE-only%3F%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20saw%20at%20same%20point%20an%20option%2C%20but%20I%20do%20not%20remember%20where%20is%20location%20in%20the%20menu.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThank%20you!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1935680%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1935846%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20document%20-%20FTE%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1935846%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F883434%22%20target%3D%22_blank%22%3E%40ClaudiaO%3C%2FA%3E%26nbsp%3BWhat%20is%20%22FTE%20only%22%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1935853%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20document%20-%20FTE%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1935853%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BHi%20Riny.%20Full-Time%20employee%20visible%20only.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1935860%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20document%20-%20FTE%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1935860%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F883434%22%20target%3D%22_blank%22%3E%40ClaudiaO%3C%2FA%3E%26nbsp%3BI%20suspected%20that%2C%20but%20than%20I%20don't%20understand%20what%20you%20mean%20by%20%22make%20an%20Excel%20document%20FTE%20only%22.%20Do%20you%20perhaps%20want%20to%20calculate%20FTE%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Hi all,

 

How can I make an Excel document FTE-only? 

I saw at same point an option, but I do not remember where is location in the menu.

 

Thank you!

 

5 Replies

@ClaudiaO What is "FTE only"?

@Riny_van_Eekelen Hi Riny. Full-Time employee visible only.

@ClaudiaO I suspected that, but than I don't understand what you mean by "make an Excel document FTE only". Do you perhaps want to calculate FTE?

@ClaudiaO 

 

Full-Time employee visible only.

 

Presumably meaning only the records of FTE are visible to you, the user. Said another way, FILTER out part-time, temp, etc?

 

If you are using the most recent release of Excel, there's a function called FILTER that could do it, "it" being to display only the FTE records.

 

Here's a resource that could help you write the formula using FILTER in your own case. https://exceljet.net/excel-functions/excel-filter-function

 

Or you could post a copy of your actual sheet (or a sample of it) just being sure to remove any real info of real employee names or other identifiable data elements (SSN, address, phone #, etc).

@ClaudiaO 

 

Of course, another way, if the Excel data comes from an outside source, would be to alter the process by which you extract the data in the first place.

 

[I'm retired now, but in my working career was the director of the HR/Payroll database for a major corporation, so I've worked with exactly this kind of situation many times. And am aware of the many wrinkles in using Excel to analyze HR/Payroll data.]