Tom Sharpe

Tom Sharpe has asked 2 questions and find answers to 41 problems.

Stats

About

Formerly lecturer in Health Informatics at University of Manchester, now working part-time for National Haemophilia Database (UKHCDO), using Excel, Access and SQL Server.

Tom Sharpe questions

Using Excel N function with arrays
Date comparison not working in Excel formula

Tom Sharpe answers

In MS Excel, how can I VSTACK a Sequence generated from on start and end?
Excel Start date in range within 365 days
How to count number of timestamp entries per day
Converting a 2D range into a 1D array with spaces in Google Sheets
How to convert big numbers between HEX and DEC in Excel without using VBA?
Sum range and subtract sum of subrange
Explain ArrayFormula expansion rules
Determining if date is between start/end dates, and averaging days since start
IF statement inside QUERY in Google Sheets
Google sheets; Arbitrary range as string