B bines53 Active Member Nov 15, 2014 #1 Hello Friend ! I have rows of numbers that checks whether there consecutive numbers, I want to get the result in G8 cell, without using H column. Thank you ! Attachments test 55.xlsx 8 KB · Views: 10
Hello Friend ! I have rows of numbers that checks whether there consecutive numbers, I want to get the result in G8 cell, without using H column. Thank you !
Mike H.. Active Member Nov 15, 2014 #2 bines53 said: Hello Friend ! I have rows of numbers that checks whether there consecutive numbers, I want to get the result in G8 cell, without using H column. Thank you ! Click to expand... Hi, Try this =SUMPRODUCT(--(B1:F5-A1:E5=1))
bines53 said: Hello Friend ! I have rows of numbers that checks whether there consecutive numbers, I want to get the result in G8 cell, without using H column. Thank you ! Click to expand... Hi, Try this =SUMPRODUCT(--(B1:F5-A1:E5=1))
