#1   Report Post  
Old March 2nd 08, 11:30 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 4
Default match data by day

Hi Guys,

I have some excel sheets and have a question regarding grouping the data by
day. I want to compare sales figures for each day of current month compared
to last financial year corresponding month. The catch is that I dont want to
compare each date (ie compare 1st December of 2006 with 1st Dec 2007), I want
to compare data from the particular day (ie I want to compare sales figures
from the first monday of december 2006 to the first monday in December 2007.

I currently have a February Workbook. It has three worksheets (1,
Comparison Sheet, 2. Feb 2007 data, 3. Feb 2008 data)

The two data worksheets have a format of..

Date Day Ttl Sales Confec Hot Food Magazines , etc


So I want the comparison sheet to take the values from the 2007 data and
then search through the 2008 data match the values by day (eg say the 5th feb
2007 is a monday and the 1st feb 2008 is a monday - I dont want to compare
both first of feb figures, I want to compare the two monday figures.

I was hoping to get something that looks like this...

Date Day Ttl Sales Confec Hot Food Magazines , etc

5feb07 Mon 4,500 800 2900 800 ...
1feb08 Mon 5,200 770 3430 1000 ...

5feb07 Tue 4,600 750 3150 700 ...
2feb08 Tue 4,200 800 2800 600 ...


Hopefully I have explained myself ok.

The problem I am having is grouping the days automatically. At the moment I
am having to put the cell reference in manually for each day.

Your help is greatly appreciated!


  #2   Report Post  
Old March 3rd 08, 07:26 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,480
Default match data by day

Hi
01 Feb 08 is a Friday, not a Monday.

That aside, if you take the latest date and subtract 364, you will get the
equivalent day 1 year earlier

04 Feb 08 - 364 = 05 Feb 07
--
Regards
Roger Govier

"mcarrigg" wrote in message
...
Hi Guys,

I have some excel sheets and have a question regarding grouping the data
by
day. I want to compare sales figures for each day of current month
compared
to last financial year corresponding month. The catch is that I dont want
to
compare each date (ie compare 1st December of 2006 with 1st Dec 2007), I
want
to compare data from the particular day (ie I want to compare sales
figures
from the first monday of december 2006 to the first monday in December
2007.

I currently have a February Workbook. It has three worksheets (1,
Comparison Sheet, 2. Feb 2007 data, 3. Feb 2008 data)

The two data worksheets have a format of..

Date Day Ttl Sales Confec Hot Food Magazines , etc


So I want the comparison sheet to take the values from the 2007 data and
then search through the 2008 data match the values by day (eg say the 5th
feb
2007 is a monday and the 1st feb 2008 is a monday - I dont want to compare
both first of feb figures, I want to compare the two monday figures.

I was hoping to get something that looks like this...

Date Day Ttl Sales Confec Hot Food Magazines , etc

5feb07 Mon 4,500 800 2900 800 ...
1feb08 Mon 5,200 770 3430 1000 ...

5feb07 Tue 4,600 750 3150 700 ...
2feb08 Tue 4,200 800 2800 600 ...


Hopefully I have explained myself ok.

The problem I am having is grouping the days automatically. At the moment
I
am having to put the cell reference in manually for each day.

Your help is greatly appreciated!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Match data in 2 columns and return data from 3rd column gwtreece[_2_] Excel Worksheet Functions 1 April 4th 07 03:27 PM
Why do my data labels do not match source data? KeithRD48 Charts and Charting in Excel 1 September 11th 06 08:04 PM
Find, Match data and paste data between two workbooks Chuckak Excel Discussion (Misc queries) 0 September 1st 06 06:59 PM
index,match,match on un-sorted data Brisbane Rob Excel Worksheet Functions 3 September 24th 05 10:04 PM
The match and lookup functions can find literal data but not the same data referenced from a cell Jeff Melvaine Excel Discussion (Misc queries) 3 April 30th 05 01:29 PM


All times are GMT +1. The time now is 07:48 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017