Category: Excel
-
How to add a row number to an Excel table
Excel tables provide a lot of support for data processing and the use of structured references can improve readability. We want to number rows in an Excel table and we can do it really easily using structured references. =ROW(Table01[@])-ROW(Table01[[#Headers],[RowId]]) We simply find the row number of the current cell [@] using ROW and then subtract…
-
Office 2013 upgrade – red pill or blue pill?
The red pill and its opposite, the blue pill, are pop culture symbols representing the choice between the blissful ignorance of illusion (blue) and embracing the sometimes painful truth of reality (red). Wikipedia about The Matrix movie I have to decide whether to upgrade to Office 2013. If I want my life to be easy I should just take the blue…
Dr James Bayley 