Thanks, it works.
How can I make sure that if I repeat the command for x rows I will not
get twice the same string (being same numbers, even if different
order)?
Thank you!
On Sep 20, 9:19 am, Aindril De wrote:
> Hi Giorgio,
>
> Looks like the issue was here:
>
> *Function R
:25 am, Aindril De wrote:
> Hi Giorgio,
>
> Use the following UDF.
>
> *Function RandLotto(Bottom As Integer, Top As Integer, _
>
> Amount As Integer) As String*
>
> Dim iArr As Variant
>
> Dim i As Integer
>
> Dim r As Integer
&g
All,
I need to build an excel that generates X unique series of 5 random
numbers, lottery style (no repetition in the same series and no
repetition across the series).
I know the function RANDBETWEEN, but how can I include the "no
repetition"?
Thank you,
G
--
.
So keep it simple:
1. Run the solver for the first cell (H32)
2. Copy B2 and C2 into G34 and H34
3. Run the solver for the second cell (H33)
4. Copy B2 and C2 into G35 and H35
and so on.
Can you guys provide me with a macro script to do the job?
Thanks,
Giorgio
Hi,
I need to run the solver for a column of 1800 target cells.
The target cell is H32 to be zero changing B2 and C2. Spreadsheet is
called BetaNeutral.
Can you guys provide me with a macro script to do the job?
Thanks,
Giorgio
5day
drawdown.
Hope it's clear, please drop a line if it's not.
Thanks guys!
Giorgio
On Aug 20, 6:39 am, Dilip Pandey wrote:
> Hi Giorgia,
>
> Take a look at the attached solution once again. Thanks
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +
Thanks Dilip, but what are actually looking for is the count of the
consecutives...i need to now how long a drawdown lasts.
thanks,
Giorgio
On Aug 11, 3:46 pm, Dilip Pandey wrote:
> Hi Giorgio,
>
> Solved workbook is attached. Thanks,
>
> --
> DILIP KUMAR PANDEY
> MB
Of course it does. What a d**k I am :)
Thank you,
Giorgio
On Aug 12, 2:19 am, Chechu wrote:
> Hi,
>
> If I understand, you might solve it by doing:
>
> Your Data New Column
> Column A Column B
> -0.01 =IF(A2=0,0,B1+1)
> 0 =IF(A3=0,0,B2+1)
&
Hi all,
I have a series of % values that can be either 0 or negative. I need
to know the maximum number of consecutive negative values in the
column. So having: -1%, 0%, -0.2%, -0.5%, -1%, -0.4%, 0% my result
should be 4.
Additional info, if it can be helpful: this is a cumulated returns
(drawdown
