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!