Forum Discussion

Peer81234's avatar
Peer81234
Copper Contributor
Sep 27, 2024

Random numbers from 0 to 100 procent?

Hello everybody,   I'm trying to let Excel do something but I don't know how. This is what I have. I have for each day in a year a number reaching from 1.0 to 59.9 kWh (for example) in 7 days nex...
Excel
  • m_tarler's avatar
    m_tarler
    Sep 27, 2024

    Peer81234  In the attached I created a simulated random array of values in A2:G53 and the bins in I2:I8

    then used the formula:

     

    =COUNTIF(A2#, "<="&I2:I8)/COUNT(A2#)

     

     I also included another option next to that using the FREQUENCY() function but that is for each bin and not cumulative and it appears you wanted cumulative

     

    I forgot to mention that A2# is shortcut for the entire 'spill range' produced by the formula in A2 which is that A2:G53 range.

m_tarler's avatar
m_tarler
Steel Contributor
Sep 27, 2024

Peer81234  In the attached I created a simulated random array of values in A2:G53 and the bins in I2:I8

then used the formula:

 

=COUNTIF(A2#, "<="&I2:I8)/COUNT(A2#)

 

 I also included another option next to that using the FREQUENCY() function but that is for each bin and not cumulative and it appears you wanted cumulative

 

I forgot to mention that A2# is shortcut for the entire 'spill range' produced by the formula in A2 which is that A2:G53 range.

  • Peer81234's avatar
    Peer81234
    Copper Contributor
    Sep 28, 2024
    Hi M Tarler,

    That is exactly what I need! Thank you for the reply and also the frequency option which I think is also a good idea!
    Now I can see which battery would be the best option for us.

    Greetings Peter

Resources