Tom Sharpe

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

Sumif with only first value of each group in column
Find maximum value in each row or column of an Excel array that is not a cell reference
Converting a python recursive function into excel
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