100%

Each event section has varying lengths. In each section, X, Y, and Z can make an appearance. If both X and Z appear in the same event section, they'd share half the height of a column representing that section. This chart, however, takes away all the significance from the timespan of each...

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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