Need help in Excel .. I'm importing external web data to Excel column one value daily / copy Hour changes. Now A7 is 22. Next hour, as A622 and so on ..
In column B, I need an incremental number starting with 1, in each column changing time in number value. Any formula will be helpful .. Put it in the cell Or you can call it
column A column b do not say nay 22 1 na na na no 2 2 nor na nor na 27 3 Na na na 4 na na na 34 5 <
b2 :
= IF (A2 = "no", "", maximum ($ B $ 1: b1) +1)
b1 , You should give the same result:
= IF (A2 = "no", "", COUNTIF ($ A $ 2: A2), "& lt; & Gt; not "))
No comments:
Post a Comment