A mapping table is a handy way to automatically translate labels between systems and reports. As with just about anything in Excel, there are many ways to implement a mapping table. For example, we could create a helper column to store the amounts with the SUMIFS function as I discussed in this Journal of Accountancy…
The post Mapping Table without a Helper Column appeared first on Excel University.
from Blog – Excel University https://ift.tt/2WXHbFr
0 Comments