formula to search partial text in excel

[bprasenjit]

12345	00601
12345	601
23456	99506
23456	00506

Hi I have the above table it actually consists of 25000 records.

I want to search and paste rows in sheet 2 where the first column numbers are identical and the 3 characters from last of the second column are also identical

Regards

Pras

[dilipandey]

Hi Pras,

welcome to the forum.
Please change the thread title to reflect the query you are asking.. see forum rules:-

http://www.excelforum.com/forum-rule...rum-rules.html


Regards,
DILIPandey
<click on below * if this helps>