1Answers

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

Asked by: Dorothy 29 views IT

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?

+7

VotesFind (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: In example, 202 should not be counted.class = “Gray3 SIZE-13″> From Hubei

Jerry Parker- January 15, 2023 |