Forum Discussion
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:
...
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?
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