User Profile
AjayGujay
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: Generating an Formula using concatenation in excel
HansVogelaar While I was using the Defined Names in my computer it was working fine but now i am trying to share the same to my team members by posting the workbook to a teams channel it is not working for others. Is there something I need to do to make it work on other Computers As well.?2.1KViews0likes3CommentsRe: Generating an Formula using concatenation in excel
Hey Yes Hans, I can see that formula is now working in my Sample report... How to add the same function to my original one? Is this any macro kind of thing that I need to add? Sorry I am not used to Macros or XMML scripts Please help me out.3.1KViews0likes5CommentsRe: Generating an Formula using concatenation in excel
Hi Sergei, Thanks for the Input, but this is not a static cell where I am trying use this formula this formula is going to be used for around 120+ columns to do. XLOOKUP based on the column header. Which basically reorders my columns from the server to the order which my team needs. Can you help me how this can be made possible with the VBA?3.3KViews0likes1CommentRe: Generating an Formula using concatenation in excel
HansVogelaar Thanks for the Input Hans… I tried adding =Evaluate(formula) but it didn’t work because excel doesn’t have the evaluate function. Is there any way that I can give you the sample excel for this formula or somewhere we can talk about it?3.3KViews0likes11CommentsGenerating an Formula using concatenation in excel
Hi There, I am planning to generate a formula using concatenation operation in excel and it actually works but the only issue is it’s not executing it just gives the generated formula as output in the cell instead it should run that formula. Is there any function that would help me to execute that formula?Solved4.1KViews0likes21Comments
Recent Blog Articles
No content to show