repetition

  1. C

    How to Calculation repetition Pattern a weeks

    Please help all master, i'm very confused to create the formula, i want to know how to calculation the repetition down in a weeks, Here is the Scenario : Down = 1 Up = 0 ID Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Count Repetition WiFi Error 1 1 0 0 1 1 1 2 Electricity Issue 0 0 1 1 1...
  2. P

    please, separate the quadruple of 8 digits without repetition

    please, separate the quadruple of 8 digits without repetition ex = 09 18 27 36 = yes 09 19 29 36 = can not have 3 digits 9, so it has repeated deletion separate only quadruple with 8 digits singles http://www.mediafire.com/file/clyc9117hy6667a/quadrupla_loteca.xlsx/file
  3. P

    hello, generate all the formations of the 3 letters .

    hello, generate all the formations of the 3 letters in the following criterion = no more than 5 letters for each of the 3 lines a = 01 02 03 04 05 06 07 08 09 1 0 b = 11 12 13 14 15 16 17 18 19 20 c = 21 22 23 24 25 26 27 28 29 30 31 So the formations will have 7 letters the maximum...
  4. K

    Require change to limit exact sum output combinations

    Using Excel2000 Hi, Till now I was using "pgc01 code" which is amazing, I found code under this link https://www.mrexcel.com/forum/excel-questions/277924-combination-help-5.html#post1424848 I require modifications code only output Permutation Repetition with a desire sums For...
  5. P

    separate cracks without typing.

    separate cracks without typing example 18 20 36 = yes for 6 digits without repetition 18 20 38 = not because there is a repetition of the digit 8 there can not be in the separation of the cracks, cracks with repetition of digits including zeros...
  6. S

    Repetition of values in Column x times upwards

    Good day to all, Hoping for help with the following issue, Column A contains the original data; Column B determines the number of needed repetitions for each value in column A, Column C needs to shows the results. What formula can be used for this operation to work. Thank you <colgroup><col...
  7. L

    Multiple Rows into an Open IE Form

    Hello! I've got a worksheet with around 47 names. This will vary as staffing fluctuates. I've got a secure website where each of these names are entered and/or searched for, at least once or twice a day. Hitting alt+tab, I can copy from the worksheet, move to IE, move back to Excel while IE...
  8. S

    Dynamic Form Fields

    Is it possible to create a form which repeats some of its fields, based on the value specified by user in real time. Ex: say the fields are, "Name:", "Type:", and "category:" . If the user value is 5 (Which will be available above those fields), it should repeat those three fields to the no. of...
  9. N

    Combination with repetitions into excel for multiple data

    Hi guys! New tothe forum and first post for me, I tried to figure it out on my own and by looking on this forum, but not sure my mind is completely clear. I have to say I'm quite new to this kind of statistics, so apologize if the question is actually easy! I want to calculate the total...
  10. Y

    Combination, Repeats (AAB,BBC) allowed, Repeats (AAC,ACA,CAA) only considered as One

    Say, generating possible combinations of 4 elements with [ABC]. 1) Repetition of elements are allowed: AABB, BACA, BBBA... 2) Repetition of combinations with similar elements are only considered as one combination: ABBC, BABC, BCAB, CABB.... How to code this? From this forum, I also find out...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top