Welcome Guest.

2Answers

0-9 numbers in the A-J column in Excel,

Asked by: Carlos Robinson 41 views Software February 20, 2022

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

addition:

2 Answers

  1. +7Votes  

    k1 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 |

  2. +6Votes  

    k1 formula is as follows:

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

    Diane Thompson- February 20, 2022 |