Hi,
can some one please try this out.
there will be two columns.1st column have values which may be similar values.if similar value exist in 1st column then compare adjacent rows of similar values to check they are also similar or not.
i attached an excel example to tryout.it may contain 1000 rows,but practice purpose i just included 10.
Thank You
Bookmarks