1. N

    Filter Unique records with Adding and Concatenate from duplicate Rows

    Hi All, This is my first post here and hope will get my answer here. I have a table with 3 columns, store, Weighting and matrix. I need the unique store list from the table but weighting and matrix columns should be added or concatenated before deleting the duplicate rows. Please find the below...
  2. D

    Excel Weighted Percentage

    Hi There, I have question regarding weighted percentages. Apologies in advance if this isn't in the correct thread. We currently mark our employees from 0 - 100 in what we call there quality score we then apply a weighting to get our new score: Currently the weighting for quality 25 so we...
  3. 2

    Percentage Weightings

    Hi all, I'm trying to get cell P11 to gauge a percentage from a figure typed into cell O11. O11 = a percentage, to 2 decimal points. There are five ranges that O11 will fall into: <35%, 35%-45%, 45%-55%, 55%-65%, 65%+ There are weightings attached to these ranges: 1.5%, 3%, 4.5%, 6%, 7.5%...
  4. G

    Advanced SUMPRODUCT function for multiple weighted averages

    Hi I am an analyst and I need help with an advance use of the sum product function for weighted averages. I am trying to calculate three different weighted averages within 1 of 50 groups of data. Each of the 50 groups of data have a different weighting score (different importance). I have...
  5. Y

    Weighting Score

    Hello, I'm hoping someone can help me with this. I have a total score being calculated based on 5 options under 9 categories (below is the formula). I need to make add a 50% weighting to the first category and then evenly distribute to the remaining 8. Does anyone have the slightest idea how...
  6. T

    Performance report

    I'm tying to rebuild our sales rep quarterly/year-end performance report to account for quarterly metrics weighting changes. Generally the performance metrics (attainment to quota and product volumes) have the same weightings each quarter so calculating the year-end ranks are easy, (YTD...
  7. C

    Sumproduct weighted average

    Hi all I need to push feed some weighting into the formula below: =SUMPRODUCT(--('[Weather Archive.xlsx]Reports'!$A:$A>=C4)*('[Weather Archive.xlsx]Reports'!$A:$A<=D4),'[Weather Archive.xlsx]Reports'!$C:$C) My weightings are in the sheet 'regionalweighting', Column A has Region (North...
  8. O

    Weighting Correlation Co-Efficients to measure performance

    Hi, I have some interesting data based on soccer that I am trying to use to measure performance based on the correlation coefficients. I have data for each player in the English Premier League that shows how many goals they have scored and with this range of other data that contributes to...
  9. J

    Variable dutching calculator

    Hello, I am struggling to figure out how to go about this, perhaps someone can point me in the right direction? I wish to create a variable dutching calculator whereby, instead of all the runners in the field generating the same profit, one can be weighted to more than the rest. For example...
  10. A

    Sumproduct with trailing amount, ranking spreadsheet

    folks, anyone shed some light on why you woud add a trailing amount to a sumproduct formula? background: I am redoing a tender evaluation spreadsheet built a while ago and when it comes to the weighting of each respondents criteria, the person who built the spreadsheet has used a sumproduct...
  11. andrewb90

    Help - Adding up a row with weighted results

    Basically I have row #2 with columns b,c,d,e,& f. in each column there are a number of points in the cell. in column g I have the added total of all the points. Is there a way to make, say, column c worth twice as many points as those in column b?
  12. A

    Limiting within a formula

    Thanks in advance to anyone who can help with this!! I have a formula - which is giving me a percentage total - this is calculated by summing a series of totals from 6 rows of data i.e: Row 1: 1 2 3 4 5 = 15 Row 2: 6 7 8 9 10 = 40 Row 3: 11 12 13 14 15 = 65 Row 4: 16 17 18 19 20 = 90 =...

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