|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 Last edited by Ricardo Sousa; 06-08-2018 at 08:00 AM. Reason: Inserting picture of table |
#2
|
||||
|
||||
Hi and welcome
as all members cannot access external links please post your sheet on the forum (click Go advanced - Manage attachments). Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Thanks very much for your tip
|
#4
|
|||
|
|||
As it looks like you have defined a Table, and assuming for a location you have not more than 1 row on same day (on fly):
Code:
=SUMIFS([Ext. Price],[Name],[@Name],[day week],[@[day week]],[week],[@week],[year],[@year]-1) |
#5
|
|||
|
|||
Hi Arviaanemets,
this is brilliant. completely solved my issue. Thanks very much for your help |
#6
|
|||
|
|||
Quote:
the tip you gave me was FANTASTIC, but now i have another issue with that table i created 3 pivots - one for week sales, one for monthly sales and one for year to date sales. the question is: do you know a way to have the monthly and year to date to display like for like numbers? Again thanks very much for your help. |
#7
|
|||
|
|||
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find matching values between 2 docs | sam1234 | Word | 3 | 11-27-2017 04:05 PM |
code to find account and sum up values | Brian13 | Excel Programming | 2 | 05-31-2017 09:26 AM |
Find and replace multiple values, according to table value - excel formula | EtanM | Excel Programming | 3 | 04-11-2016 01:43 AM |
Display multiple values as new values based on selection from template. | MvdB | Excel | 2 | 09-29-2015 08:51 PM |
find 2 values i a table to find the right prise | Vibov | Excel | 1 | 01-11-2015 07:25 AM |