RAND(Squawk)

Random Squawking - more of a really slow blog - various topics from coding to living. Lets just see how it goes.

Showing posts with label excel. Show all posts

Showing posts with label excel. Show all posts

Monday, 15 April 2024

Either Excel or Time Machine or Apple Desktop Broke my Spreadsheets and then fixed one of them

This is scary - where's my data ? *** The is a descriptive story of a data corruption event but does not as of April 2024 contain a defi...

Saturday, 19 November 2022

Excel rounding feature

** Update 2023 Added When Excel goes ( is used badly ) impacting careers I have an Excel spreadsheet that I use for keeping the accounts ...

Wednesday, 28 March 2018

Sum of digits function in Excel and perl. sd(n)

In Excel From : http://www.listendata.com/2013/02/excel-sum-of-digits-in-number-using-non.html 01. Formula - Sum & Index Assuming ...

Wednesday, 24 September 2014

Excel Average() is often wrong and over emphasises minorities and why 0 is your truthful friend.

Take this simple spreadsheet that records over 10 weeks the number of veterinary consults delivered in a small animal practice. In the co...

Sunday, 5 April 2009

The first shall be last and the last shall be first ( in Excel )

I had a need in Excel to swap the words round in a field. The was for address book processing where I wanted to change a "Last,First...

View web version

About Me

Gannett: Just a bloke, finding a way in the world one step at a time. This is blog is my pensieve.

View my complete profile

Powered by Blogger.