1. V

    Conditional formatting colour scales on different cell

    Hi, I have used colour scale to format the % complete cell but I need the format to be the same in column a so I can hide column b. Is there an easy way of doing this I want to keep the colour scale? Thanks <tbody> <colgroup><col><col></colgroup><tbody> Status percent complete Complete 100%...
  2. H

    Add contributing %s to max 100% total

    Hi. I have a spreadsheet <tbody> D E 1 Question 1 90% 2 Q1 assessment criteria 1 20% 3 Q1 assessment criteria 2 30% 4 Q1 assessment criteria 2 40% </tbody> Under Question 1 there are three things users have to report on their progress with. They type in the % figure and...
  3. willow1985

    Max IF formula

    Hello, I am trying to get a Max IF formula to work. At first I thought of using an index match with Max however I read online that the below formula would be a better fit: =MAX(IF(('% Complete'!A1:A6=A1),'% Complete'!$B$1:$B$7)) I need the formula to return the Maximum percentage from the...
  4. Z

    return certain value

    hello, i would like to know if i want excel to return certain values based on results received. example: if employee reaches 95% then he gets 1 if 98% then 2 100% then 3 120% then 4 200% then 5 what is the equation to use for such examples
  5. B

    Weighted Measure - Different Criterias

    Hello, I'm looking for help on creating a measure that give me an overall score based off of other score Metrics. I have 2 tables: First table provides the employee scores for the metrics being measured: <tbody> dDate RankGroup Full Name Production% Quality% Adherence% Friday, June 28, 2019...
  6. K

    Adding a vertical line in conditional formatting data bars at 100%

    Hello, I have a budgeting sheet where I'd like to show a vertical line against some progress bars at a value other than zero. In particular, I'd like to highlight where budgets are at more than 100%. It looks like conditional formatting can only handle that if the value you're targeting is zero...
  7. sharky12345

    Highlight cells less than 100% but ignore blanks

    I'm trying to use the conditional formatting option to highlight cells where the value is less than 100%, (the cell values are percentages), but I need to ignore any cells that are blank. Can anyone help me please?
  8. C

    Average formula combined with IF formula

    Hi, What formula would I use for the following. I have 4 or 5 percentages which I need to average. If any of these 4 or 5 values are 0% then the average would need to be zero. For example if I have 100% 0% 75% 100% - I need the average top show as 0% and not 68.75% Can anyone please help, I...
  9. R

    Want a formula or PIVOT to get the percentage of SLA met from True or False criteria

    Hi Folks, Need two options for this guys. If Pivot how can I configure the sheet raw to populate on sheet Dashboard percentage base on the TRUE and FALSE details from SHEET Raw Second approach if pivot will be hard formula I can use on Sheet DB to give me percentage;) SHEET RAW <tbody> 1 A...
  10. F

    VBA Remove only certain duplicates

    I have a spreadsheet with data in columns A thru F. In column A are contract #'s and in F are percentages. If there are duplicates contract #'s in A, and in column F one of the duplicate contracts is at 100% I need to delete the one that is not 100%. If neither is 100% I need to keep both. Is...
  11. R

    Check that all tabs are at 100% scaling

    Hi, I have multiple workbooks and would like to check that what the scaling is on each of the tabs before I print it out. Maybe some script that gives me a report tab maybe. Thanks Rich
  12. M

    Ranking Groups with Multiple Criteria

    <tbody> A B C D E GROUP TARGET ACTUAL % ATTAINMENT EXPECTED RANK A 9 17 188.9% 1 A 7 13 185.7% 2 A 6 11 183.3% 3 A 12 18 150% 4 A 6 9 150% 5 B 1 11 1100% 1 B 3 9 300% 2 B 4 8 200% 3 B 1 2 200% B 6 6 100% 4 C 7...
  13. L

    Urgent Ranking Help Requested

    Pleas help. I have been attempting to get this Rank thing to work for 4 hours. I'm quite frustrated. I need to Rank the below individuals based on QA1,QA2,Sales, and Absences from 1-14 with 1 being the highest out of the four categories. <tbody> QA1 QA2 Sales Absences Nicole 0%...
  14. H

    100% round down

    Hi I have an audit matrix document which calculates %age scores for multiple sites. The score should always show a full number (i.e 80%, 90%, etc...), and I am happy for standard rounding to apply (i.e round down for .4 and below, round up for .5 and above) However, I don't want this to apply...
  15. K

    Pivot Table & Percentages

    Hi all, I have a the below pivot table. I have a formula which produces true and false. For this particular month in State 1, True is 0 where False is 4. So i want to show a percentage for a report I have to do, which gets updated every month. I only want to show the percentage of true against...
  16. W

    A better formula?

    There has to be a better, more concise formula than this. I have revenue, and I want to compute favorability between a new period and an old period. Higher revenue in the new period than the old period is good, less is bad. The % increase or decrease should follow suit. If the old period had...
  17. R

    Getting numbers of scores to get average

    Hi guys, Need some experts to shed light on me. Trying to come up with a formula to get how many 100% scores do I need to get to 98% if my table looks like this: <colgroup><col><col><col><col></colgroup><tbody> Current Attempts Running Score Goal How many 100% audits needed? 87 96% 98%...
  18. C

    Finding Percentage Drop

    I need a formula that will show the "Header" that correlates with the first time a value drops by at least 90%. In the example below, in the Yellow column, it should say "Q4 2015". Please help! This data package is huge. I need a formula to apply or I may spend the next 10 years doing it...
  19. Welsh Mark3

    Using Logic to get first and last name from cell with fulls names

    I have a columns of data that contains a persons full name, which I am trying to split into first and last name. I could use the text to columns feature and use space as the delimiter, but this is not 100% perfect. Some scenarios that cause issues ar e Mark A Edwards Mark Edwards Sr Mark A...
  20. M

    Calculating Bonus attainment %

    I'm trying to write a formula that returns a % attainment based on a bonus achievement when referring to a target range. The goal range is below from 0% to 200%. if the achievement was 265, the attainment% would be 100% (shown here). How do I write the formula so it calculates the exact %...

Watch MrExcel Video

This Week's Hot Topics

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