Forum Discussion
Sort Numbers Within A Cell In Excel?
Marco365 Thanks for the file and clarification. Rather than creating a lot of manual steps, I thought it was best to create two pivot tables ("pt"). on the basis of the data sheet "1 Sort by cell....."
The first pt counts the number of numbers in each month of the year.
A second pt creates a list of all dates in the data, with a filter on the number with digits in descending order. I called it "DescNr". This is the basis for individual pt's for each of these numbers. They look like this:
Don't worry! You don't have to create every pt for each "DescNr". Under options on the Pivot Table Analysis ribbon, you can select "Show Report Filter Pages...". This will create one pt for each of the items in the filter field.
Perhaps you find this approach acceptable. Almost fully automated and not much room for error.
Hi Riny,
I am not able to do it so far, I am not sure why.
I have added more to what I am trying to get done in this file. Let me know if you can see it and if you can help, otherwise I would post the file to get some help. Thank you so much
Marco365 Sorry, but you need to be more specific. What I do get is that, for instance the number in E1 = 351. The largest number that can be created from these digits is 531. Similar for E2 and E3. The digits in the respective numbers can all be "re-grouped" to (the largest number) 531. Now, E4 (on 18 sep 2020) has the number 131. How does this one relate to the 531 in J17, also 18 sep 2020? Similar for the next one (331 on 16 sep). And why is there a number "532" in the list of 531's, dated 17 sep 2020? (See picture). Perhaps you accidentally typed it wrong and it should also be 531 and on 14 sep 2020. But why?
Why not create an example of, say, the first 10 numbers on your list and manually produce the full output of what you need, noting down exactly, the logic for each step.
Hi Riny, so sorry for the confusion, that is what I was thinking of doing creating a brand new spreadsheet showing what I need to get done manually. I will work on it. Should I do a different post or use this one again? I am not too familiar with this platform, I don't want to have things all over the place.
Marco365 Always best to start one thread regarding one problem and not mix in other questions on the go. I noticed that you uploaded the same file and question at the end of the thread in the link below.
https://techcommunity.microsoft.com/t5/excel/assign-a-number-to-the-different-values/m-p/1148488
Best for now is that you take some of your dates and numbers and carefully produce the output you need, explaining the logic of every step needed to get there. What you have given so far is not clear, at least not to me.
I am sure it is kind of confusing, I thought so myself. I have attached another spreadsheet with 3 sheets with instruction in the sheet or see the sheet title. Let me know if that is clear and is possible to achieve. Thanks