Forum Discussion
each letter of word in to separate cells
Vimal_Gaur Provided you are using Excel365 or 2021, have a look at the attached file.
The green shaded areas is where I entered my formulas.
This is for 365, any solution for MS excel 2021?
Yes, it is possible to deconstruct the Lambda functions, though it is not something I would usually do.
Helper ranges are used in place of LET local named variables and the code within each Lambda function is placed directly within the formula cell. References passed by name are replaced by hard-wired references. One advantage of using helper ranges is that some, otherwise very good, Excel built-in functions, like COUNTIFS, only accept range references and fail with arrays.
The result of this process will be very close to one of the solutions you already have. To roll the solution back to pre-dynamic-array days one would have to use relative referencing to pick out the elements of the solution array or resort to CSE. Some would see such a process as achieving 'simplicity'; others see it as creating an error-prone mess; it all depends on one's view point.
- two process involved in your sheet, I need one process.
is there any option by VBAI expect so but, if your are not going to use the Excel formula language, why use a spreadsheet?
I do not understand where your requirements are coming from. Who says you need one process?
In the attached, I have used a hidden helper sheet. At casual inspection, one wouldn't even know it existed.
I have also solved the problem with PowerQuery a lot easier than it would be with VBA.
- Wow great!, can you let me know how to do in power query