Tom Sharpe

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

Tiling an Excel array in 2 dimensions, ideally not using VBA
Excel - Split cell with a delimiter and if delimiter not found get complete cell value to another cell
If two sets of dates fall within another set of dates
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