How to lookup dates ranges within spreadsheet

[Boofy24]

Hi All

I am a bit of an excel novice and wondered if you can help me out please.

I have a spreadsheet of data containing products sales and dates. e.g. if a product was sold over a number of months there will be a separate line for each month

Product 1 - 2011/01 - £100
Product 1 - 2011/02 - £100
Product 1 - 2011/03 - £100
Product 1 - 2011/04 - £100
Product 1 - 2011/05 - £100
Product 1 - 2011/06 - £100

I want to be able to look up the first and last month there are sales for each product and also the month with the highest amount of sales (as i am looking over 4 years worth of data)

What is the best way to do this please?
Thanks!

 

[Trevor G]

Here is something to get you going then.

Excel Workbook
	A	B	C	D	E	F	G	H
1	Product	Sales	Month			Product	First month sales	Last month sales
2	Product 1	1000	2011/01			Product 1	2011/01	2011/06
3	Product 1	500	2011/02			Product 2	2009/06	2010/12
4	Product 1	750	2011/03			Product 3	2010/01	2010/12
5	Product 1	1500	2011/04
6	Product 1	1000	2011/05
7	Product 1	1000	2011/06
8	Product 2	500	2009/06
9	Product 2	750	2010/06
10	Product 2	600	2010/12
11	Product 3	100	2010/01
12	Product 3	250	2010/02
13	Product 3	250	2010/05
14	Product 3	500	2010/06
15	Product 3	500	2010/07
16	Product 3	250	2010/10
17	Product 3	750	2010/12
Sheet1

 

[Boofy24]

That's fantastic, thank you very much for all your help

 

[Trevor G]

Your welcome and good luck with your task and solution.