Wednesday, 15 May 2013

excel - How to increment the values in one column depending upon the dynaimic values of other column -


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 .. 

  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 < 
  
 
 
 Put it in the cell  b2 :  
  = IF (A2 = "no", "", maximum ($ B $ 1: b1) +1)   
 Or you can call it  b1  , You should give the same result:  
  = IF (A2 = "no", "", COUNTIF ($ A $ 2: A2), "& lt; & Gt; not "))   
  Enter image details here    

 








Posted by



at





































No comments:















Post a Comment
Subscribe to: Post Comments (Atom)