When referencing data in larger Excel spreadsheets, it can often lead to incorrect results because of errors when selecting data. To avoid this, use Excel Named Ranges.
Here's a quick video to do just that.
It's really quite simple.
top of page
Search
bottom of page
Comments