Solution: solution: 4×3×2× 1=24,
24×4=96,
No.97 is 9 1357, No.98 is 9 1375, No.99 is 9 1537 and No.0 100 is 9 1573.
So the answer is: 9 1573.
Comments: The key to solve this problem is to analyze the meaning of the problem and then deduce it according to the data obtained from the analysis.
So how do you get rid of all the same data in the same column in excel, leaving only the first word? According to the following methods, it can be easily realized:
1. First, sort the data columns to be deduplicated (ascending or descending):
2. Then take the next column as the auxiliary column, enter the first space into 1, and the second space into the formula: =if ($ a3 = $ a2,2, 1), and then just press Enter (hint: the meaning of each value in the if function is like this = if (logical value, the value when it is true).
3. Drag the formula in 2 and apply it to the remaining cells below. The value of the cell next to the repeated word becomes 2, otherwise it is 1:
4. Click the filter function in the data to filter out rows with a value of 2:
Just delete these lines repeatedly, and the remaining words are unique.