Find numbers that repeat a certain number of times
I have a table with a few rows and two columns. I'm looking for a way to find numbers that repeat four (4) or more times in the table.
e.g. in the example below I have 22-4, 4-4 and 15-4. I want the 4 to go into the cell in row 9.
Currently I do this manually, which is ok for one spreadsheet, but I do this a number of times a day and it gets a bit tedious. The rest of my spreadsheet is pretty automated with only a few things I have to do manually, like inserting images into cells that I can't do with functions.
I have not yet been able to figure out how to check for these numbers that repeat four (4) or more times.
And if I have a table where there are two numbers that repeat four (4) or more times, then I would have another row for the second number. I guess this complicates matter again, but I guess I could have an if statement to check if the field is empty or if a number is already listed before populating the next cell?
Within this table I only work with numbers 1 – 22. I will never have a zero (0) and never have a number higher than 22... I don't know If that makes things easier at all?
MacBook Pro 14″