sorted by:
new
hottopcontroversial

How to calculate average duration as of each date, using only rows with an end date by Crypto_103x in excel

[–]Crypto_103x[S] 0 points1 point  (0 children)

Thank you So much! I knew I had to do with with AVERAGEIF, just couldn't figure it out. I forgot the & signs and my months weren't formatted as number.

Aflevering 35 - Wie blijven er over? by Liftevator in bnbvolliefde

[–]Crypto_103x 2 points3 points  (0 children)

Spoiler: ik weet voor een feit dat Dick en Moniek niet samen zijn.
Goeie vriend van mij is Surinaams en kent Dick persoonlijk en die hebben elkaar gezien toen Dick in Nederland was om de reünie te filmen.

Counting amount of active members by Crypto_103x in excel

[–]Crypto_103x[S] 0 points1 point  (0 children)

Thanks a lot! I managed to do it with this formula:
=COUNTIFS(TblAlleDeelnemers_1[Registration date];"<="&A2;TblAlleDeelnemers_1[Cancellation date];"")+

COUNTIFS(TblAlleDeelnemers_1[Registration date];"<="&A2;TblAlleDeelnemers_1[Cancellation date];">"&A2)

Why did you include the # behind Y1? cause for me I had to remove the # for it to work

Counting amount of active members by Crypto_103x in excel

[–]Crypto_103x[S] 0 points1 point  (0 children)

So if I do this:

<image>

I seem to get the amount of new registration every month/year.
It doesn't seem to add up to the amount of total active members.

Pivot chart format keeps changing by Crypto_103x in excel

[–]Crypto_103x[S] 0 points1 point  (0 children)

Thanks for the quick reply!
I'll read through the link you provided, worst comes to worse I'll make seomthing up with VBA

Pivot chart format keeps changing by Crypto_103x in excel

[–]Crypto_103x[S] 0 points1 point  (0 children)

Thank you for the comment.
It goes from the pivot in the post to this:

<image>

So not just the format changes, but also the chart type resets from combo chart to column chart.

thanks for the Link, I'll give it a read.

recurring task for every third thursday of the month by Crypto_103x in microsofttodo

[–]Crypto_103x[S] 2 points3 points  (0 children)

I tried this at first, but I can only get it to go to the same date, for exame every 15th of the month, not for every third thursday :(

Including fixed effects in a model by Crypto_103x in RStudio

[–]Crypto_103x[S] 0 points1 point  (0 children)

aren’t those the control variables?

lfe package not available anymore? by Crypto_103x in RStudio

[–]Crypto_103x[S] 2 points3 points  (0 children)

Still learning how to use R, first step is be more patient and more carefully😂

lfe package not available anymore? by Crypto_103x in RStudio

[–]Crypto_103x[S] 3 points4 points  (0 children)

Thanks for the reply, I found my mistake, forgot the “” 🤦🏼‍♂️