| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merge base on same code number
Hi Groups,
I have such data which is one column (ex:B) has various same code number, but di other column (ex : A) has single different area. So, how can I make within one code number consist of many area in one cell. If I use "&" function, it takes longer time, how can i make this more quicker, data is very big. Regards, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merge base on same code number
Pran, Please post your workbook (or sample workbook) - scroll down and see "Manage Attachments". Have a great day, Stan -- stanleydgromjr ------------------------------------------------------------------------ stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115352 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merge base on same code number
Stan,
As below is sample work book.... AREA CODE SPPT No. 0130 SHGB No. 72/Kanci Kulon SPPT No. 0132 SHGB No. 72/Kanci Kulon SPPT No. 0131 SHGB No. 72/Kanci Kulon SPPT No. 0153 SHGB No. 75/Kanci Kulon SPPT No. 0154 SHGB No. 75/Kanci Kulon etc etc So, i wish that : CODE AREA SHGB No. 72/Kanci Kulon SPTT No. 0130, SPPT No. 0132, SPPT No. 0131 And So on... Please help "stanleydgromjr" wrote: Pran, Please post your workbook (or sample workbook) - scroll down and see "Manage Attachments". Have a great day, Stan -- stanleydgromjr ------------------------------------------------------------------------ stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115352 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merge base on same code number
Pran, I can not tell by your last post of flat text where your data begins, what column(s) they are in, etc. Please post your workbook (or sample workbook) - scroll down and see "Manage Attachments". Have a great day, Stan -- stanleydgromjr ------------------------------------------------------------------------ stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115352 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merge base on same code number
Hi,
Please download and install the following addin (http://download.cnet.com/Morefunc/30...-10423159.html) and then use the following array formula (Ctrl+Shift+Enter) =SUBSTITUTE(TRIM(MCONCAT(IF($C$6:$C$10=B14,$B$6:$B $10,"")," "))," SPPT",",SPPT") B6:B10 has the area and C6:C10 has the code. B14 holds the code Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Pran" wrote in message ... Stan, As below is sample work book.... AREA CODE SPPT No. 0130 SHGB No. 72/Kanci Kulon SPPT No. 0132 SHGB No. 72/Kanci Kulon SPPT No. 0131 SHGB No. 72/Kanci Kulon SPPT No. 0153 SHGB No. 75/Kanci Kulon SPPT No. 0154 SHGB No. 75/Kanci Kulon etc etc So, i wish that : CODE AREA SHGB No. 72/Kanci Kulon SPTT No. 0130, SPPT No. 0132, SPPT No. 0131 And So on... Please help "stanleydgromjr" wrote: Pran, Please post your workbook (or sample workbook) - scroll down and see "Manage Attachments". Have a great day, Stan -- stanleydgromjr ------------------------------------------------------------------------ stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115352 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merge base on same code number
Hi there,
I already downloaded for addin and simply copy the formula, so far the result is #NAME?, I checked and found that could be from MCONCAT syntax which is not listed in my excel function. Could give me more advice for this? Kind Regards, Pran "Ashish Mathur" wrote: Hi, Please download and install the following addin (http://download.cnet.com/Morefunc/30...-10423159.html) and then use the following array formula (Ctrl+Shift+Enter) =SUBSTITUTE(TRIM(MCONCAT(IF($C$6:$C$10=B14,$B$6:$B $10,"")," "))," SPPT",",SPPT") B6:B10 has the area and C6:C10 has the code. B14 holds the code Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Pran" wrote in message ... Stan, As below is sample work book.... AREA CODE SPPT No. 0130 SHGB No. 72/Kanci Kulon SPPT No. 0132 SHGB No. 72/Kanci Kulon SPPT No. 0131 SHGB No. 72/Kanci Kulon SPPT No. 0153 SHGB No. 75/Kanci Kulon SPPT No. 0154 SHGB No. 75/Kanci Kulon etc etc So, i wish that : CODE AREA SHGB No. 72/Kanci Kulon SPTT No. 0130, SPPT No. 0132, SPPT No. 0131 And So on... Please help "stanleydgromjr" wrote: Pran, Please post your workbook (or sample workbook) - scroll down and see "Manage Attachments". Have a great day, Stan -- stanleydgromjr ------------------------------------------------------------------------ stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115352 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I mail merge data base from Excel to word | Excel Discussion (Misc queries) | |||
| I want to transfer a data base file into Excel then do mail merge | Excel Discussion (Misc queries) | |||
| How do i set up a data base in excel for code 128 | Excel Discussion (Misc queries) | |||
| How do I set the number format to Base 12? | Excel Discussion (Misc queries) | |||
| Can you change the base number from 100 to something else with %'s | Excel Worksheet Functions | |||
Linear Mode
