In the AJ column in the AJ column, a fixed value 1 number is randomly appeared in the A1 cell, and how to display a number in the 0-9 in the A2 cell in the cell cell in the K1 cell

Welcome Guest.

In the AJ column in the AJ column, a fixed value 1 number is randomly appeared in the A1 cell, and how to display a number in the 0-9 in the A2 cell in the cell cell in the K1 cell

+7

Votesk1 formula: = Index (A2: J2, MATCH (1, A1: J1,))

1, if there are multiple 1 in the first line, take the first one.

2, if the first line is not 1, return an error.

Ruby- February 20, 2022 |

+6

Votesk1 formula is as follows:

= if (A1 = 1, IF (AND (A2> = 0, A2 <= 9), A2, ""), ""

Diane Thompson- February 20, 2022 |