1. A

    How to Calculate Scoring for High, Medium and Low from a Series of Criteria

    <tbody> Criteria Range Score Account Balance $500,000.00 and $999,999,999.99 89 Account Balance $100,000.00 and $499,999.99 79 Account Balance $50,000.00 and $99,999.99 69 Account Balance $25,000.00 and $49,999.99 59 Discharge Date 121 - 180 68 Discharge Date 181 -...
  2. JenniferMurphy

    Best way to skip 1st & last cell in range in UDF?

    I have a little UDF that does some tallies on a column of cells (B2:B5). <tbody> R/C A B 1 Group Rating 2 North 25.2 3 South 14.7 4 East 52.0 5 West 33.8 6 Average 31.4 </tbody> I call the UDF from another cell like this: =Tally(B2:B5) I want to change that to include the cell...
  3. S

    How to assign a numerical value to a name

    Please help, I’m a excel beginner and have tried everything I could to figure my problem out. I am trying to create a spreadsheet for a team. I want to be able to get an average rating between my players. So I’m trying to list 1 players name and their rating and then be able to list all players...
  4. H

    Is it possible to have Cells Fill in a character if values are met?

    What I am trying to accomplish if is is possible is if the value on the left is within the Range then the Rating on Right will insert Stars 1/ Cell. Is this Possible? Thank you! <tbody> Values Ratings 80-100 * * * 60-79 * * 50-59 * </tbody>
  5. B

    Vlookup with Match or Index/Match Approximate Values

    I'm at my wits-end with this one. I think the solution is staring me in the face, but I just can't get it. I have a cross table a1 = 0 b1=65 c1=45 d1=33 a2 = 50 b2=71 c2=52 d2=37 a3 = 75 b3=77 c3=58 d3=41 Column "A" is the percent of Economically Disadvantaged Students in the...
  6. J

    Calculating ratings across a range of cells

    I have a workbook with a row of 78 cells, each of which has a 1-5 rating. I need to calculate the number of cells that are rated 1, the number rated 2, and so on. I've tried using the formula =COUNTIF($E26:CD26,"1") and then dividing by 78 but this does not return the average rating. How can...
  7. darrenmccoy

    Count Staff and Rating value totals - Formula help

    Can you guys help me work out the formulas to calculate the totals of each value that each staff member has? This example shows the count of the staff name appearing in Cloumn C and D, the the total times the Rating value appears against each staff name. I have 42,000 records to run this over...
  8. G

    Identifying the highest value for multiple records.

    Hello everyone, I expect this will be something that is very simple, but I am in a pinch and need a resolution to this without me researching. I have a file in column A (ID) I have an account code and each account has multiple ratings Column D. I want to quickly find and select the rows that...
  9. E

    Index Match Multiple Criteria - Two Tabs

    I am trying to do an index match. I want to match the Vendor ID and Max Manual Date in the Audit tab to the corresponding row in the Quality tab to get the Manual Rating and then to match the Vendor ID and Max of EtQ Audit Date to get the EtQ Rating. None of my formulas work. Can someone...
  10. J

    ON Time Delivery from Vendor Performance Rating Question

    Hello I have an ISO 9000 Requirement to track Vendor Performance. I need help tracking performance in Percentage on on time delivery. Pivot table: Requested Due date: C7 Vendor Name: D7 Date Received: O7 Performance Rating: P7 (Unable to determine % based on Completion dates Vs Due dates.)...
  11. A

    IF statement is not working

    Hi All, Can anyone help me out on below code. I have to update final rating in column D. following is the sequence if Column has rating then update in column d, else copy rating from column b & if column a & b does not have rating the copy rating from column c <colgroup><col width="64"...
  12. G

    macro if statement

    Hello again, i want to create a macro that will compute the rating. when I run the macro and click the button, I receive Run-time Error '13': Type Mismatch when I try to run the code. Debug highlights the 'IF' statements, but I can't figure out where the mistake is. Any help would be...
  13. T

    INDEX MATCH MAX multiple columns

    I have four columns labelled Level 1, 2, 3, or 4. Each contain an Average Rating of BLANK to 100 derived from a ROUND & AVERAGEIF formula. The highest Rating & Level will be used to select a value from an INDEX table on Sheet2 and displayed as a Deduct Value. However, the INDEX table only goes...
  14. S

    Excel OLAP cube formulas

    I have created an Excel user form that incorporates locked fields that populate with customer information from a SQL server by way of OLAP CUBEVALUE formulas. It works great, however I have run into a problem b/c I have other CUBEMEMBER information that I need to display per user selection...
  15. M

    RAG Rating on Excel Graph

    Hi All, I am having trouble adding a RAG rating to the right of an excel Graph. Is anyone able to help? https://www.guysandstthomas.nhs.uk/resources/about-us/board-minutes/2018-board-papers/february/board-of-directors-performance-report.pdf Something similar to Page 50 on the link above...
  16. D

    Relationship of costs of a product to increasing product ratings

    I have a California red wine collection. For each wine I have the Name of the wine (Col A), release year (Col B), Cost (Col C) and Rating on a 100 point scale from my favorite rating source (Col D). The costs of the wines in Col C have been normalized to same year dollars. It has always been...
  17. S

    How to put the highest rated player in a cell for a particular position

    Hi, I've created a table below: <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> GOALKEEPER COMPLETE WING BACK (RIGHT) CENTRAL DEFENDER COMPLETE WING BACK (LEFT) ANCHOR MAN ADVANCED PLAYMAKER ROAMING PLAYMAKER...
  18. S

    Using MATCH to match 2 columns

    Hi, I have a table below: <colgroup><col style="mso-width-source:userset;mso-width-alt:6363;width:131pt" width="174"> <col style="mso-width-source:userset;mso-width-alt:2998;width:62pt" width="82"> <col style="width:48pt" width="64" span="7"> </colgroup><tbody> team Matches Pld...
  19. S

    Matching 2 Cells to get the 3rd

    Hi, i'm hoping this is an easy one, i just can't get my head around the formula to use. Below is my spreadsheet with all my players on the left & every position they play in & their ratings. On the right is every individual player & their BEST rating. What i'm wanting is for on the right under...

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