Tom Sharpe

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

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)
Reverse columns of spreadsheet
Index match unique values with multiple criteria?
How to reference cell in formula where result met condition