Excel document - FTE only

Question

Hi all,
&nbsp;
How can I make an Excel document FTE-only?&nbsp;
I saw at same point an option, but I do not remember where is location in the menu.
&nbsp;
Thank you!
&nbsp;

riny_van_eekelen · Answer

ClaudiaO&nbsp;What is "FTE only"?

claudiao · Answer

Riny_van_Eekelen&nbsp;Hi Riny. Full-Time employee visible only.

riny_van_eekelen · Answer

ClaudiaO&nbsp;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?

mathetes · Answer

ClaudiaO&nbsp;&nbsp;Full-Time employee visible only.&nbsp;Presumably meaning only the records of FTE are visible to you, the user. Said another way, FILTER out part-time, temp, etc?&nbsp;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.&nbsp;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&nbsp;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).

mathetes · Answer

ClaudiaO&nbsp;&nbsp;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.&nbsp;[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.]

Forum Discussion

Excel document - FTE only

5 Replies

Resources