F febausa Member Feb 6, 2015 #1 Please help in find correct formula. I attach the manual example Attachments COUNT REPETITIVE CONSECUTIVE NUMBERS.xlsx COUNT REPETITIVE CONSECUTIVE NUMBERS.xlsx 10.6 KB · Views: 11
Hui Excel Ninja Staff member Feb 6, 2015 #2 M4: =IF(H4="","",COUNTIFS($H$3:H4,H4,$I$3:I4,I4)) Copy down
F febausa Member Feb 6, 2015 #3 Hui said: M4: =IF(H4="","",COUNTIFS($H$3:H4,H4,$I$3:I4,I4)) Copy down Click to expand... Hi Hui: Thank you,You are true excel ninja
Hui said: M4: =IF(H4="","",COUNTIFS($H$3:H4,H4,$I$3:I4,I4)) Copy down Click to expand... Hi Hui: Thank you,You are true excel ninja
