Excel Hack 44: Extract data from a matrix in Excel
Here’s a hack I uncovered while creating a mileage chart in MS Excel… I was searching for mileage information (distance between cities) for 16 Nigerian cities online, and came across a mileage chart sheet. On downloading the sheet, turns out it had mileage information for 453 cities in total. This was great, of course, as