1. P

    Cominbie 2 league tables into 1

    Hello Is there a way of combining 2 league tables into 1 league, (From different Sheets) Predictions A Tab – Contains league table 1 highlighted in green Predictions B Tab – Contains league table 2 highlighted in yellow The issue A+B League Table Tab – I want this to...
  2. M

    Prediction/Forecast - Excel

    Good day any help I can attain will be awesome. Issue: Based on two cells I would like to know the probability that the next input will meet the desired result. Example Months Yield (The expected yield in 5months is 10%) 5 10% 1 3% (The current...
  3. F

    Find Y, with X variable with set of data that forms bell curve.

    Hello All! I'm creating a PV system design tool (for my own use, but I'd will post it open source afterward for folks to use). Here is a portion of the data I'm working with: <tbody> TABLE 2: Minimum Radiation Feb Mar Jan Rank...
  4. T

    Forecast function

    Hello, I am trying to forecast the price by city from a data set. Here is an example of what it looks like: <tbody> CITY 6/17/2011 12/2/2011 2/26/2012 4/30/2012 8/2/2012 11/21/2012 1/11/2013 2/14/2013 5/3/2013 7/30/2013 11/8/2013 1/9/2014 2/11/2014 AIKEN, SC $ - $ - $ - $ - $ - $ - $ 14.74...
  5. B

    VBA code to get a value from 2 matching cell filled with color

    hello, i dont know much about VBA coding but if anyone is willing to help, i run a predictions league and i would like to be able to make a code so if the home teams scores 1st and the person who predicted the result put the home team to score 1st too, i get a value of 2 points, if the results...
  6. B

    Need advice with this formula for my football predictions

    Hey, I run a football (soccer) predictions league for me and my friends and after so many years of doing it all manually i want to make it work with formulas but i cant get them to work properly, im very close to completing it but theres always 1 result that doesnt work properly. Here is the...
  7. R


    Hi all, New to mr excel and still relatively new to excel but loving it ... I'm looking to be able to get a projection or forecast value from a previous weeks data so that each week going forward always has a projection value based on previous weeks results ... Hope this makes sense? I've...

Some videos you may like

This Week's Hot Topics