Admitting that the research I am currently doing is totally worthless, I concluded the way to summarize the frequency of selected data in Excel.
1. Generating criteria
For example, you believe in the data set, there are only several unique values such as "1, 2, 4, 5" though the data set is very large. Then create the column of these for unique values.
2. Using functions
Use "=frequent(data range, criteria range)" and select corresponding data and criteria range.
3. Aftermath
First select enough number of continuous empty cells. By enough, it means the the number of the empty cells should be equal to the number of the unique values-1 (the first cell is just where the frequent function is input in step2).
Second, press F2
Third, press "Shift" + "Control" + "Enter".
All is done now.
