RICI: Excel Musings – Sorting and Randomising
Welcome to another edition of R1C1 – Excel Musings. In this edition I want to share some thoughts on sorting lists of data, and its opposite, randomising the order of…
Welcome to another edition of R1C1 – Excel Musings. In this edition I want to share some thoughts on sorting lists of data, and its opposite, randomising the order of…
Welcome to another edition of R1C1 – Excel Musings! The previous edition on array formulas was well received judging by the responses I received to the included Excel challenge. I hope…
Formulae lie at the heart of what makes Excel such a powerful calculation tool and although standard Excel formulae can solve most problems, situations still arise when we need extra intermediate…
THIS ARTICLE IS THE FIRST IN A SERIES – PART OF A NEW REGULAR COLUMN, FEATURING THE MUSINGS OF DAN MAYOH… As professionals in the actuarial field many of us use…