hello
i m using CONCATENATE formula to make summary of my data, but i m using long CONCATENATE formula. i want to use short formula instead of CONCATENATE
formula is here :
plz help to short this formula and accuracy is first
Please Login or Register to view this content.
You get better help if you add your excel file without confidential information, and the desired result.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hello oeldere
now time to go home. if u don't mind, i'll upload the workbook tomorrow,
thanx for reply
You can do that with the help of user defined function. Open your VBA editor and insert a module. Paste the code given below and close the vba editor.
Now on you sheet in the cell where you want to place your formula, try this array function (Ctrl+Shift+Enter).Please Login or Register to view this content.
Does this helps?Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Hello sktneer
i think i m mistaking somewhere
i m uploading a sample workbook,
Sheet("F2").Range("N5") = CONCATENATE formula, i m using formula Range.N5:N54,
Sheet("F2")linked from Sheet("OF")
the result of CONCATENATE formula just like this :
urPlease Login or Register to view this content.
plz check the sample workbook
thanx
http://www.sendspace.com/file/mp76ea
I get an vires alert when I try your link to download.
Please add the file on this forum without virus.
hello oeldere
file size is 1.99 mb
so i can't upload this forum
and there is no virus in file only .xlsm file
Make the file smaller so you can upload it on this forum.
We don't need the whole file, just a part of it, to get the idea what you're up.
Please also add the deired result and post it without confidential information.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks