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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top