Tom Sharpe

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

Date comparison not working in Excel formula

Tom Sharpe answers

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
VBA haversine formula
Google spreadsheet, comparing durations
index match with wildcards and multiple criteria
How to OFFSET from a dynamic named range and use that range in SUMPRODUCT?