Excel challenges by jkp-ads.com
Introduction
Because I had some time to spare back in August 2019, I posted an Excel challenge on Daily Dose of Excel. If I get round to creating more challenges, I'll post them here. Below you'll find the links to the challenges.
Content
Comments
All comments about this page:
Comment by: RAM LAL (17-1-2023 14:24:00) deeplink to this comment
=INT(MOD(MOD(SMALL(ABS(ROUND((MMULT(INT(MOD(ROW(A1:INDEX(A:A,2^ROWS(B3:B20)))/2^TRANSPOSE((A3:A20-1)),2)),B3:B20)-B1)*10^9,-7))+ROW(A1:INDEX(A:A,2^ROWS(B3:B20))),{1}),10^7)/2^(A3:A20-1),2))
HOW TO USE FORMULA 2000 ROW
Comment by: Jan Karel Pieterse (17-1-2023 17:11:00) deeplink to this comment
Hi Ram,
I suggest you to ask your question here:
https://www.eileenslounge.com
Have a question, comment or suggestion? Then please use this form.
If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.