Forum Discussion

Jarek B's avatar
Jarek B
Copper Contributor
Jan 06, 2018

tricky one

here is my issue I struggle to solve for a while. If someone would be kind enough to help me I would be very grateful. I am not experienced in vb so I would like to stick to just formulas:

  

I need a formula for column E. In E count how many times in row value in column B is > than in column A, answer in E12 = 2 and then in E16 = 3 

Formulas and Functions

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 06, 2018

    Hi Jarek,

     

    Sorry, I didn't catch, what do you mean "how many times in row"? For row 12 how many times B12 more than all values in column A (but that's not your answer) or what?

    • Jarek B's avatar
      Jarek B
      Copper Contributor
      Jan 06, 2018
      every time B>A you can see 1 in D, D11=1, D12=1, (twice in row) and D14-16 ( three times in row), I need the formula that will calculate that and give me 2 in E12 and 3 in E16