diems
Board Regular
- Joined
- May 3, 2010
- Messages
- 71
Hi everyone,
The vba formula described down below should count consecutive values but it doesn't seem to work properly.
It should count i.e. 150,151 = 1 or 150,152 = 1
My question is; does anyone knows a different vba formula that will do this (if possible a normal formula instead of a array formula).
Thank you for any help offered.
The vba formula described down below should count consecutive values but it doesn't seem to work properly.
It should count i.e. 150,151 = 1 or 150,152 = 1
My question is; does anyone knows a different vba formula that will do this (if possible a normal formula instead of a array formula).
Thank you for any help offered.
Code:
[A1].FormulaArray = "=SUM(0+(R10C:R20C-TRANSPOSE(R10C:R20C)=1))"