• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. B

    chart creation

    Hi Is there any way to show which fall above or below the median based on compa ratio with a line at median, 10% and 20%. Then scatter points for the salarys at each level? Thanks
  2. B

    chart creation

    Hi Please can you someone create a scatter chart with trend line to reflect the data shown. Thanks
  3. B

    Grade Structure Chart inc actual salary vs median market value

    Hi I am seeking to create a chart that looks at actual pay vs market pay by grade. I am looking to show the median market pay, together with the actual pay but when you have 500 plus jobs at different job grade levels, and you want to show the amount of salaries above and below each grade as...
  4. B

    Employee overtime

    Hi Please can you help with the attached. Thanks
  5. B

    Stacked chart multiple months

    Hi Please can you help me chart the attached. Thanks
  6. B

    Employee overtime

    Hi Please can you let me know how to calculate employee overtime costs/gender/job/job family/department etc in excel. How do i best visualise this in terms of charts and kpis? Is there a method in excel by which i can present a summary of results found from the analysis? Thanks
  7. B

    Best charts executive pay review

    Im looking for some great chart ideas for executive pay. Any ideas much appreciated. No performance ratings or internal pay bands
  8. B

    Range Across Range? (With Values instead of dates)

    Hi I am looking for a solution to find if a range overlaps another range. Range 1Range 2 ABCDOverlap? 75000230000110260130000 22500400004351048090 37500600005182058440 800001100008975096880 600009500072090180000 I have looked at a few attempted solutions and they don't seem to work ...
  9. B

    Performance Appraisal Tool

    Hi Thank you for this it works well. Ben
  10. B

    averaging formula for blanks and zeros across two cells

    Hi I have the following formula for averaging cells or just bring back a number from one cell ... =IF(AND(BK5="",BU5=""),"",IF(AND(BK5<>"",BU5<>""),AVERAGE(BK5,BU5),IF(BK5="",BU5,IF(BU5="",BK5)))) This works if the cells have blanks in them, but i also need it to do similar if any of the...
  11. B

    Performance Appraisal Tool

    Hi Please can you let me know the formula you have used to create the RankingsTable. Thanks Ben
  12. B

    Performance Appraisal Tool

    Hi Narayan This looks interesting. I noted some cells without formula in so I am unable to tell what these are doing. Other than that I think this is looking good. Thanks Ben
  13. B

    Performance Appraisal Tool

    Hi I have been asked to analyse performance appraisal ratings for around 2000 employees. The performance appraisal ratings are ... Outstanding Exceeds Expectations Meets Expectations Needs Improvement Does Not Meet Requirements A score of 1 to 5 against these. Employees joined in different...
  14. B

    multiple criteria index match or vlookup

    Hi I have this formula...
  15. B

    conditional formula blank, value or average in cell

    Hi Thanks for this but while I want the formula to average, if either of the two cells is blank I just want the formula to pull back the cell with the data in it and not average that cell against the blank when it does. Thanks Ben
  16. B

    conditional formula blank, value or average in cell

    Hi i need an excel formula but cant figure out how to make it work. =average(cell1,cell2) unless either cell is blank then just bring back the value in the cell which has a value, and if both cells are blank then I need a formula that will just make the cell blank. Please can you help...
  17. B

    Range Look up

    Hi I dont know what the 2nd global grade will be. I know that the reward levels each have a range, I cant go outside of that range. So in the global grade is an 18 then I would need the next cell to return a 17. If I know that the reward level is a D, and the global grade is a 13 I can say...
  18. B

    Range Look up

    Hi I am looking to lookup a range and to have restrictions to what the range can lookup. The range is employee grades and for example internal grade D, global grade is 13-14, if currently employee is a 14 I want the formula to show in the next cell a 13. I have attached the document I am...
  19. B

    vba to extract all formula in a workbook

    Hi I dont have the skills to do this task but im looking for a vba that will do something similar to this ... http://code.adonline.id.au/list-all-formulae-in-excel-workbook/ Please can you help me. Ben
  20. B

    index match match

    Hi I am attempting to generate the most likely salary survey code from the attached example. I have a number of employees where I know part of the salary survey code and I know what their salary is which should best match against the median salary on the salary survey but i am not sure as to...
  21. B

    index match match

    I think for retrieving the salary survey code I just need to use the business unit and the job description and dont require the employee id. thanks Ben
  22. B

    index match match

    Hi I am looking to pull through the salary survey code in one column and the in another column will look to pull through job description. First column lookup: job description Second column lookup: salary survey code This by using the business unit, employee id, job description as these are...
  23. B

    index match match

    Hi I am working through a salary survey and need to look up last years data to compare with the new submission I am preparing. I have business unit, employee id, job description The data flows in this direction ie 1. bus unit, 2. emp id, 3. job description I need to retrieve the survey...
  24. B

    capturing formulas with explanation

    Hi I have a spreadsheet with a number of formulas in it. I am required to summarise what the formulas are doing, since the formulas are based on different columns, each column is in table and each column has a header. I am wondering if there's any method via which I can capture and summarise...
  25. B

    Random Details Picker VBA query

    Hi Thanks I have now got it to work - just need to work my way through it. Kind Regards Ben Howard
Back
Top