Forum Discussion

Rajesh_Sinha's avatar
Rajesh_Sinha
Steel Contributor
Mar 06, 2021

Re: How to sort numbers with a space in the one cell

My dear friend I'm well versed with all you have written here,, my concern was,,, being a answerer ,, it's the prime responsibilities that one must show the correct way to create UDFs,,, VBA stuffs,,, and their implementations,, if I'm not wrong hardly 1% users can handle this new arrival feature,,, . So please show the way you have created this function !!

2 Replies

  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Mar 07, 2021

    Rajesh_Sinha

    I am not quite sure what you hope to see from me.

    Having tackled the problem as a challenge, I posted the resulting method as an antidote for the usual 'tips and tricks' genre, which would lead the reader to believing that single-cell filled formulas with relative referencing is the only way to develop spreadsheets.  I left posting until the OP had been given methods that would work with any version of Excel to avoid pressurising them into updating their software.

     

    In case it is of interest to anyone, I have attached a copy of my workbook.  It is a macro-enabled workbook both because it contains the XLM4 function EVALUATE and it contains a macro that creates defined names and uploads formulae prepared on the worksheet.  Besides the main formula that relies on LAMBDA functions and LET, it also implements formulas that just rely on FILTER and SORT.  I could revert the functionality further, but my intention was to illustrate a possible future for Excel, not its past.

  • JMB17's avatar
    JMB17
    Bronze Contributor
    Mar 06, 2021
    To be fair, I did not specify the specific version in my response and neither did you. I just said "if you have these functions", you made reference to "higher version", and Peter said "modern version" and also noted his was a mixture of legacy and "insider beta functions". His response is as specific, if not more, as either of ours.

    If someone is an "insider beta", then it is reasonable to expect they have the knowledge to create named formulas through name manager as they are likely more knowledgeable users.