LinkBack URL
About LinkBacks
Dear All,
I have data in which Product code and Product name is mentioned,In the same date,some product has same last four digits in its product code, I want find those product how to do it.
I attached sample sheet for your reference.
Dev.
Dear All,
I have data in which Product code and Product name is mentioned,In the same date,some product has same last four digits in its product code, I want find those product how to do it.
I attached sample sheet for your reference.
Dev.
Hi devawad, the quick way: Paste the following in D2 and copy down:
=RIGHT(LEFT(B2,SEARCH("(",B2&"(")-1),4)
This populates D with the last 4 NUMBERS of your product codes. Now select columns A:D and sort on column D to put similar items together.
NOTE- Some of your serial numbers (at the bottom) have differing formats. Grouping those might require different formulae.
Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
Last edited by leelnich; 05-25-2017 at 02:25 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks