Welcome Guest.

# 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?

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