salaries

  1. C

    Top 10% 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
  2. Z

    Flip data from horizontal to vertical format for uploading

    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...
  3. J

    Subtotal / turning rows on/off

    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...
  4. R

    Overtime payroll sheet nightmare!

    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...
  5. D

    Averageing based on other cell values

    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...
  6. P

    Activate a file using "Input Box"

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

    Complex formula creation

    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
  8. D

    Value error using sumifs/sumproduct

    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...
  9. W

    Use Excel Macros to Loop through worksheet and process data

    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...
  10. P

    Normal Distribution not working properly Bell Curve

    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...
  11. P

    V Lookup not reading the correct data (skips the row and doesn't match)

    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...
  12. N

    Combine Row and Column Data

    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...
  13. B

    VBA to clear contents, paste into another worksheet based on criteria

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top