Here is a quick Monday tip for data junkies.
If you want to shuffle a list of numbers or cells in excel in random order you can do that with “data > sort” menu option of excel.
- First insert a column next to the list you want to shuffle and enter random numbers in each cell in using
=rand(). See below:
- Now select the entire list and sort it by the new column with random numbers. (Menu > data > sort)
- If you want a fresh set of shuffled list, just hit f9 (recalculates all formulas) and sort again
Like this? Also learn how to sort horizontally, fill only weekdays while auto-filling dates
5 Responses to “Number to Words – Excel Formula”
As well as the Indian version, perhaps you could look into an English version as against the American version.
Things diverge after one hundred with one hundred one OR one hundred AND one.
I'm sure that it is always AND after n00 or n00,000 where there any of those zeros have a value. So five hundred thousand and sixteen. There could be two and's seven hundred and eighty-six thousand four hundred and twenty-six.
Chandoo, you are a genius.
Hi Chandoo,
Please take a look at my NumToWords and NumToDollars formulas that I shared here:
https://techcommunity.microsoft.com/t5/excel/excel-numtowords-formula/m-p/727433
That is a genius technique Robert. Thanks for posting it here.
100000000 One Hundred FALSE Million
Is there any reason for this error?