How to consolidate excel cell in order and remove duplicate?
Value of Excel Cell A1 : SR4.2/22-SR4.2/24
Value of Excel Cell A2 : SR4.2/23+1,SR4.2/COL/1
Value of Excel Cell A3 : SR4.2/22,SR4.2/21
How to make the value of excel cell B1 to B6:
SR4.2/21,SR4.2/22,SR4.2/23,SR4.2/23+1,SR4.2/24,SR4.2/COL/1
Last edited by london7871; 03-21-2016 at 09:50 PM.
There's no SR4.2/23 in your data - did you want to remove the extra 2/22 or make it be a 2/23??
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
well - this will do what you've asked:
Please Login or Register to view this content.
Last edited by xladept; 03-22-2016 at 02:03 PM.
Please note that SR4.2/22-SR4.2/24 = SR4.2/22, SR4.2/23, SR4.2/24.
Hi London,
I missed that - I'll work again on it tomorrow - and, thanks for the rep!
Please Login or Register to view this content.
Thanks jindon. It's work.
How about if the format of cell A is changed to SR4.2/22-24?
(i.e. both SR4.2/22-SR4.2/24 and SR4.2/22-24 can work at the same VBA)
Upload a workbook with all possible combination data and the result you want.
How to consolidate values in cells with different format as attached?
Last edited by london7871; 03-27-2016 at 09:27 AM. Reason: Enclosed with excel file for easy reference
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks