repeating numbers

  1. P

    Find repeating values that occur only X times

    How can I specify the frequency / occurrence of repeating values that need to be found in a column or across different columns? For example, if a column had 1,2,3,3,4,4,4, I want Excel to only find values that repeat 3 times, and the answer should be 4. Someone gave a very good tip on how to...
  2. T

    repeating numbers

    actually not a question, more like an Excel trick someone could use. Formula to produce an array of numbers, starting from 1, repeating that number x times. After that, repeating the next integer x times. Until the maximum y is met. From then on, it repeats itself. This description might be...

Some videos you may like

This Week's Hot Topics