On many of these measures, investment supermarket Hargreaves Lansdown is the most profitable company in the FTSE 350. Last year it generated revenues of Â£358 million, of which 45 per cent (Â£162 million) ended up as net profit.
Rand Function Examples. In the following spreadsheet, the Excel Rand function is used to generate random numbers between different limits. Note that the above formulas will return a different random number every time the spreadsheet recalculates. To force a recalculation at any time, press the F9 key. For further details of the Excel Rand Function, see the Microsoft Office website.
In the adjacent column, use the following RANK formula and copy/drag for other cells (here I have used it for 10 numbers only, hence A2:A11. You can adjust the range accordingly). =RANK(A2,$A$2:$A$11) Thatâs it. You would have a list of random numbers from 1 to 10, and none of the numbers would repeat. NOTE: Remember to convert cells with RAND function from formula to values, else it will recalculate and change the list of Random Numbers every time you change anything in the workbook.