Tom Sharpe

Tom Sharpe has asked 2 questions and find answers to 25 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

Use regexmatch with Switch case
Compare 2 Lists Return Matches
How do I return a reference to the first element of a named range?
Sorting by alternate numbered rows without losing data
Finding unique between two groups
Perform Rolling Sum Based on Another Column's Value in Excel Table
Creating a Timesheet with at different rates
Excel - list in two columns each unique-pair from two source columns in excel
How to get first significant figure from a number in Excel?
Difference between two dates expressed as years, months, days (in one column)