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

Some videos you may like

This Week's Hot Topics