compensation

  1. S

    VBA Code for transpose for Large Data Set

    Dear All, Can you please help me to transpose data. I have three columns "Emp_ID, Compensation Plan and Amount. I want Compensation Plan to be transposed to Basic salary, HRA, Bonus and Commuting Allowance by Columns. I have 4000 employees list which has more than 18k rows. Please help...
  2. S

    Sum text that contains numbers - But ONLY the numbers.

    Hi all, I am trying to do a planning schedule, which includes different earnings, such as; sick days, holiday earned, lieue days earned/taken, compensation earned/taken. The hoiday earned, and sick days were very simple because all I did was color code "H" for Holiday, and to the very right had...
  3. H

    Lookup matching values

    I have 2 spreadsheets with several columns. On spreadsheet 1 I have Column A: ID Column O: Compensation Rate On Spreadsheet 2: Column A: ID Column D: Compensation Rate I want it to lookup by the id the compensation on Spreadsheet one. Thanks for the help
  4. M

    Compare 3 columns not in a string if match

    I need to compare compensation report. Columns I, M, and P all need to match in each row. What is the formula? <tbody> D E F G H I J K L M N O P Company Name Attainment Recurring Revenue Total Production Revenue AAA Inc 102 102 102 ABC Toys 185 370 370 BC...
  5. P

    Complicated formula assistance needed!

    Hello, all! I have a project that seems a little out of my league; so I figured who better to ask than the best! Okay... Explanation time. I need a formula to determine whether or not a well in my spreadsheet is elegible for compensation - just a TRUE or FALSE. Sounds easy enough, no? Wait for...

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