ratings

  1. JenniferMurphy

    Changing scales without exhausting Excel ;-)

    If I have a table with average ratings of a number of products by people who were given the choice of rating them on a -5 to 5 scale. (1-5 thumbs up, 0 thumbs, 1-5 thumbs down.) These products got generally negative ratings, which makes the relative ratings a little difficult to visualize. To...
  2. A

    VBA Filter with Multiple Criteria

    Mornin Ya'll. I've got a question on sheet 2 asking for a pressure, and a column on sheet 1 with multiple flange ratings. What I'd like the script to do is filter the flange ratings based on the pressure entered. For example, if the user entered 350 psi it would filter out everything below...
  3. 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...
  4. R

    Pivot Table and Pivot Chart questions

    So, I have this table where each row has data about a supplier's deliver, with a final "rating" for that delivery. A supplier may have multiple deliveries in a month, or none, of course. The Pivot Table has the Y axis showing the suppliers names, the X axis shows months, which aggregate all the...
  5. D

    Min or Max, but ignore 0.00 if other cell has a value >0

    I have three cells that each have a numeric rating. What I want to do is bring back the min/lowest value of the three ratings. With the exception of where one of the ratings is 0.00 but the one of the other two has a value >0. In other words if there are three ratings (below) <tbody> Rating #1...
  6. A

    Class Generator

    Hi All - I am looking for some help with a problem for work (assistant principal). What I would like to have done is to take the following information (Student Name, Behavior, Academics, Gender) and then generate a certain number of class lists that represent approximately equal distribution...
  7. C

    Help with VBA data new row each time

    I will try and explain what im doing just playing around with VBA and excel to see if i can get this to work. I have used this in the past but it has been so long since i have done anything with it im at a loss of where im going wrong. I have 4 sheets that im working with 1 - Stats 2 -...
  8. M

    Group items by rating

    I have categories in Col A and a corresponding rating in Col B. Col A is dynamic. Col B is fixed to:Avg,good,new, or null. Not all categories will have ratings (null). I am trying to group the categories by ratings - with specific formatting. See below. Desired result is in B10...
  9. F

    formula for finding differences after grouping

    sorry for poor title! If i have Names in column A, then a Rating (1, 2 or 3) in column B....Lets say JOHN DOE is listed in column A, 8 times. I want to find out if all his ratings are the same in column B. Column C just needs to indicate that not all JOHN DOE's ratings match. Hopefully...
  10. G

    100 points and descending

    Good Day, :confused: I need your assistance with this minor problem that is doin my head in. I have a list of numbers (my race ratings). Example: 86 100 84.5 ? 82 ...

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
Back
Top