Welcome Guest.

1Answers

How to screen a series of numerals contains the number I want I want

Asked by: Dorothy 29 views IT January 15, 2023

How to screen or the condition format highlight the number I want. For example, in this number of numbers, I want to find the number of groups of 12678 (such as 262, 817, 202) because there are a lot of value, this is only a part of the screenshot in a column.What should I do?

1 Answers

  1. +7Votes  

    Find (MID (a $ 1: A $ 9, colorn (a: c), 1 from), “12678”)/A $ 1: Jijiang A $ 9)^0,9), row ($ 1: $ 3)^0) =3, row (a $ 1: a $ 9), row (z1)), “”)

    After losing the formula, press the Ctrl+Shift+ENTER combination key, and then pull down enough (blank)

    In the formula, A $ 1: A Asiabao School can be changed to A $ 1: A $ 9360 Q &A 99 This may be adjusted according to the data

    Column (A: C), ROW ($ 1: $ 3) is 3 digits, adjustment according to the specific digits

    Crashing: column B gets the number of rows, the value of column C gets the value
    C1 input formula
    = If (b4 = “”, “”, index (a $ 1: a $ 9 &”, B4))

    Huanwu house is called from Hubei

    Answer: B4 should be B1,

    from Hubei

    Answer: In example, 202 should not be counted.class = “Gray3 SIZE-13″> From Hubei

    Question: Yes, 202 is not wrong, thanks for calculating

    from Guangdong

    Jerry Parker- January 15, 2023 |