Hi @GQRanalytics,
I think a Lag Column node and Math formula will do the trick. See my example workflow validation of consecutive values.knwf (9.9 KB) . Also look at this post another Excel - related question with a tip from @ipazin for a a book From Excel to KNIME
gr
Hans