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