Thread: [Solved] Table with values from several locations and years - need to find comp values
View Single Post
 
Old 06-07-2018, 05:14 PM
Ricardo Sousa Ricardo Sousa is offline Windows 10 Office 2016
Novice
  
Join Date: Jun 2018
Posts: 7
Ricardo Sousa is on a distinguished road
Default Table with values from several locations and years - need to find comp values
Dear All,
Please see table below.


As you can see the file has “sales” (column H) from different location by day, week number and year.
My question is:
Is it possible to create a formula at the column I that gives the “sales” from the comparable day last year?
Example: on the first line I would like to have in column I the value of the “sales” from the Sunday of week 22 of 2017 (the “sales” from that day are at column H.

Thanks very much for your help
Ricardo
Attached Images
File Type: png ricardo.png (78.1 KB, 18 views)
Last edited by Ricardo Sousa; 06-08-2018 at 08:00 AM. Reason: Inserting picture of table
Reply With Quote