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