salaries

I am looking for a formula for the following: List of names and salaries for the top 10% of a compinies top earners List of names and salaries for the bottom 10% of a compinies top earners

Hi, Is it possible to change data format in Excel. My data in excel is as follows: Name of GL GL Code Jan-19 Feb-19 Mar-19 Apr-19......until Dec-19 Salaries 8205 $100 $200 $300 $400 $1200[/PHP][/HTML] Tax...

i have a list of names / salaries that extend multiple years (columns). i would like to add a function that i can turn on/off cells representing salary to see the total at the bottom with/without certain salaries. i want to be able to toggle name 2 on and off to see how the totals change in...

Hi I am trying to create an overtime sheet for my Hospital's salaries department and I am stuck! They need to have an out put of the exact hours worked (eg 09:00-17:00) for each day. Some people my work onsite in the hospital on several occasions per day so the exact hours for these need to be...

Hi I have a spreadsheet with my staff listed across row 1. Row 2 contains their salaries and row 3 contains their department. I want to average the salaries of employees based on their department e.g. Alan Tom Helen 100 150 200 HR HR Admin I looking for a formula that would return...

Hi all, I would like to write a VBA code so that to open and activate a file, which I will choose using an input box: e.g. Salaries 1-2018.xlsx The path of this is: ‘C:\Users\User\Payroll\Salaries 1-2018.xlsx” In input box I have to enter the file name, e.g. Salaries 1-2018 or...

Hi there I am looking to create a formula to pull the total amount of people in a certain department and their salaries. All this info is in my data tab but I do need it summarized on a different tab

I'm trying to sum columns/rows with multiple criteria using sumifs and sumproduct, but get value errors. My data table looks like this: <tbody> 1000 2000 3000 Total 1000 # Emp# Salaries Bonuses Pension Total Salaries Ben A 121 1568.98 500.00 (29.65) 2039.33 150.00 0.00 </tbody> My...

Hello All, I am new to this forum and I am hoping some one can help me out in this matter. What I like to achieve is: - Loop through a worksheet row by row - Based on an index value, copy the selected row multiple times and then split the cost by percentage assigned - Write the result to a...

Hi everyone, I'm trying to do a normal distribution bell curve on a range of salaries. The x-axis seems not to be reading the salaries and hence I am not getting the right bell curve shape even though my data is normally distributed. I've done this before and it worked so I'm confused why its...

Hello everyone, So I thought I would try to share this problem with you, this forum has been very helpful to me. So I have a worksheet of data with names and salaries for each month (I have reduced the number of months for this purpose). I am building a separate worksheet to analyse those...

Hello all, I tried searching for a thread that addresses this question, but I was not able to locate one. I may not have worded my search correctly. I receive a hospital's accounting trial balance that has hospital department numbers as row headers across the row 1 and account type numbers in...

I have data in a tab, called "SourceData" in the following order: <colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody> <colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody> Curr Company Department Account Account Name Jan Feb Mar Apr USD 1 100 55100...