director

Hello, I am trying to provide commissions statements to my sales people. My sales report lists all levels for each account: Salesperson, Sales Manager, and Director. In some cases, the employee ID in all three columns is the same person (the department director manages a few highly important...

Hello guys. I have made a sheet preparing payslips for emloyee however I am adding a rule to see if the employees is a Director then the calculations in each columns are done on cumulative basis. i.e. every employee has monthly LEL(1a) = 6032/12=503, LEL-PT(1b) = 2392/12=199 and PP-UEL(1c)=...

Hi, I am looking for formula that match keyword in from 2 files. File1: <colgroup><col></colgroup><tbody> Keywords Exclude intern accountant accounting admin advertising advisor analyst architect assistant to vice president assistant to vp Attorney auditor Author...

Hello, I have to build monthly Income statements (IS) for 47 projects and one combined (IS) based on Trial Balance (TB) exported from accounting system into Excel. Under each account of the TB there are 48 rows related projects (47 projects and one not assigned to projects, in total 48...

Hi, need to automize the description based 3 criteria. - Personnel number (#3 and #4 are letters short for department) - Personnel code (random) - Appointed period would like to have the description within such format: e.g:Finance_Department_01.01- 01.07.2012_PN_876789 (Indicated in red)...

Hi everyone, I have the following table <colgroup><col><col><col><col></colgroup><tbody> Office Position Start Date Termination Date New York Manger 20-Jan-16 11-Nov-17 Chicago Director 20-Jan-16 28-Dec-18 Miami Senior Manager 20-Jan-16 13-Feb-17 Boston Director 20-Jan-16...

Hello, I need to automatically find the managers who will be responsible for each employee in a company. There are many hierarchy levels and each manager is responsible for his team of subordinates. I have all the columns A - K and I need to fill in columns L-M-N with the names (or job title)...

Can someone tell me if there is a simple way to retain the original results of a formula when the source data is sorted? I have two sheets: an Organization List and an Organization Chart. The Chart is a visual representation of the hierarchy (who reports to who). If you can imagine some arrows...