Current location - Zhou Gong's Dream Interpretation Encyclopedia Official Website - Divination by drawing lots - Microsoft Excel, how to find a jumping number in a list of numbers, such as 1, 2, 3, 5, 6, 7, with a 4 in the middle, and why? ...

Microsoft Excel, how to find a jumping number in a list of numbers, such as 1, 2, 3, 5, 6, 7, with a 4 in the middle, and why? ...

A 1？ Enter 1, A2 enter 2. . . There are a few numbers missing randomly in the middle.

Enter the formula in B 1 = IF(A2- 1 & lt； & gtA 1，" X "，"")

Copy the formula of B 1 and display the missing position directly.

Related articles