stars

  1. 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>
  2. A

    return stars based on where it falls in graph?

    I want column 4 to return the stars based on where the data falls in the table. I consider myself pretty good with excel but this one has me stumped. I though and if function couldn't figure that one out. Here is the Data Thanks! Was going to attach table but it says I cant... here is images...
  3. G

    vlookup vs Match+index

    Hi everyone, I have 2 seperate table on 2 different sheet: - a Cube Pivot Table - a table that I paste from another source Both table have a in Column A, an ID that is unique value for each row. I need to merge these 2 table in a new table. 1st table (Cube pivot Table) <tbody> 1000 jack x...
  4. H

    Extract set number in different lines in given string

    Hi Team, is anyone help me with below requirement ...in the given example string ...need to eliminate what is there in brackets and need the numbers in each line. If you see ** thes two stars will separate the each numbers in each string. I believe based on the these stars need to build the...
  5. M

    Cannot develop the correct formula to solve for X

    I'm trying to write a formula to solve for X in the image below. I want to know how many 5-star reveiws a client would need to get to an average of 4.5 stars if they already have 6 reviews averaging 4 stars. Any suggestions? It's driving me crazy because I was never too good at algebra.
  6. M

    EUROMILLIONS Prize Checker - Last Draw Vs Past Draws

    Hi all Since last 190 millions last draw of EuroMillions, I've been wondering about statistics and decided to play a little with it, although my lack of knowledge. I've downloaded the list of all draws and extracted it to Excel to check for some indicators in order to improve my luck. Here's...

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