How to program my macro to choose between multiple modes and no modes

First, I really am a novice in excel and I'm not even sure that I'm even asking the right question.

Background: We have created a macro that takes 30,000 or so rows and organizes it so that the mode of each variable (in this case the variable is a combination of Operator Name and Operation) appears at the top of the range. We then use vlookup to analyze the mode of each Operator Name+Operation in a separate template.
There are three problems:
1. Sometimes there are multiple modes. Currently the program randomly choose which mode to appear on the top. However, I would like to choose the lowest value mode to appear at the top.
2. The second problem is that if there is no mode the program currently chooses a random number to appear on top. I would like it to leave the top cell blank instead or to return an N/A so that I will no that there is no mode.
3. The third problem is that the mode is not valuable for analysis unless it repeats more than 7 times. Currently even if it repeats 2 times it still returns that number at the top. Instead, I would like the macro to leave the cell on top blank or return a N/A.

Thank you for your help!

Thank you for your help.
Here is the link to the Template: https://drive.google.com/open?id=1Nx...CzO5dbaUqR3QRX
The data in the template is after the macro, called "mode", has run.
When the macro is run, the result of the macro is Column P, Q, R, and Solumn S. The mode for this data appears at the top of each group in the following locations:
S2
S553
S1120
S1163
S2207
S2522
S2699
S2925
S2948
S3214
S3573
S4102
S4380
S4882
S5390
S5936
S6502
S6518
S7068
S7328
S7859
S8429
S8954
S9487
S10036
S10037
S10553
S10560
S10600
S10605
S10623
S10909

Sheet 2 of the template is where I manually found the mode for each group. You can see in the third column that several times there was no mode and the macro chose a random number to put at the top. There are also several cases where the mode repeated less than 7 times and in this case I would like the macro to leave the cell blank on top.

Is this enough information to explain my situation?