LinkBack URL
About LinkBacks
keep your known sales figure in a separate area in the worksheet.
Then for calculating difference, use a VLOOKUP or and INDEX/MATCH combo to match up corresponding values against data in the pivot table
keep your known sales figure in a separate area in the worksheet.
Then for calculating difference, use a VLOOKUP or and INDEX/MATCH combo to match up corresponding values against data in the pivot table
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks