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

  1. Combinations

 

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.




To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].