Extract Rows where Numbers are not in Sequence

[teco]

Dear All

I need your support. I want to Extract those rows where the Numbers against Names are not in sequence. For Example

NAME NUMBER

KP_G_5151_ABC 23
KP_G_5151_ABC 24
EA_NS_UL_0589_ZXC 119
EA_NS_UL_0589_ZXC 121
EA_NS_UL_05809_ZXC 120
DUM_EB_NS_GUL_5040_OPI 580
DUM_EB_NS_GUL_5040_OPI 578
DUM_EB_NS_GUL_5040_OPI 579
DUM_EB_NS_GUL_5040_OPI 581

The output should highlight or extract below Names bcoz Numbers against them are not in sequence

NAME NUMBER

EA_NS_UL_0589_ZXC 119
EA_NS_UL_0589_ZXC 121
EA_NS_UL_05809_ZXC 120
DUM_EB_NS_GUL_5040_OPI 580
DUM_EB_NS_GUL_5040_OPI 578
DUM_EB_NS_GUL_5040_OPI 579
DUM_EB_NS_GUL_5040_OPI 581


Thanks

[AliGW]

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

[teco]

Thanks AliGW.Will take care next time i make any post and will comply with the forum rules since it helped me alot

[teco]

Cross posted the post here as well(only)
https://www.mrexcel.com/forum/excel-...-sequence.html

[Alf]

Assuming that your data is in column B and starts in cell B2 perhaps a macro like this could be of help

Please Login or Register  to view this content.

Alf