Read and Update Excel Tables Using SUMIFS and INDEX-MATCH

by Charley Kyd on December 9, 2013

A growing number of Excel users in business are linking their reports and analyses to Excel tables. By doing so, they can update them in seconds rather than hours.

Users typically rely on two types of tables for their data: vertical tables and horizontal tables. Although each has its advantages, using two types of tables can create a challenge when you need data in one format but it’s currently in the other.

However, using three Excel worksheet functions will allow you to move data easily between these table formats.

[click to continue]

Previous post:

Next post: