By Neil Shorney, Director, Naturally Sales Ltd.
We guide you through creating a two-dimensional table to display information from large data sets.
In the first part, we’ll familiarize ourselves with a useful advanced lookup formula: SUMPRODUCT, then we’ll learn how we can save time populating tables by using a combination of absolute and relative references.
These are best looked at in an example, so you’ll find details in a file which you can download just here.
www.nsales.co.uk/excel-examples/Populating-a-table-with-absolute-and-relative-references-using-SUMPRODUCT.xlsx
No comments:
Post a Comment