Excel Question

[TSinneed]

I would like to have excel find the first and last time a customer purchased an item in any quantity and return the date at the top of that column.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Here is an example:
Dates
Column 1 Customer Jan 2011 Feb 2011 March 2011 April 2011
Part #1 Sam 5 7 3 0
Part #2 Sam 0 0 5 9
Part #3 Sam 1 6 7 10
<o> </o>
Part #1 Tom 5 7 3 0
Part #2 Tom 0 0 5 9
Part #3 Tom 1 6 7 10
<o> </o>
I need to see for Sam and Tom, by part #, what their 1st month and last month purchase was.
<o> </o>
I have 14 customers, 55 months, and about 500 part numbers.

 

[Gerald Higgins]

Hi, welcome to the board.

In your example, what exactly do you want the results to be ?

 

[TSinneed]

What i want will look like this:

1st Purchased Last Purchased
Part#1 Sam Jan 2011 March 2011
Part#1 Sam Mar 2011 April 2011
Part#1 Sam Jan 2011 April 2011

Part#1 Tom Jan 2011 March 2011
Part#1 Tom Mar 2011 April 2011
Part#1 Tom Jan 2011 April 2011


Thus, i can copy these 2 columns into another worksheet to show when they started and stoped buying by part number and by customer.

Seems easy, but with 9700 rows and 60 columns, it is a big task.

Thanks, TS

 

[Gerald Higgins]

Instead of this . . .

1st Purchased Last Purchased
Part#1 Sam Jan 2011 March 2011
Part#1 Sam Mar 2011 April 2011
Part#1 Sam Jan 2011 April 2011

Part#1 Tom Jan 2011 March 2011
Part#1 Tom Mar 2011 April 2011
Part#1 Tom Jan 2011 April 2011

do you actually mean this . . .

1st Purchased Last Purchased
Part#1 Sam Jan 2011 March 2011
Part#2 Sam Mar 2011 April 2011
Part#3 Sam Jan 2011 April 2011

Part#1 Tom Jan 2011 March 2011
Part#2 Tom Mar 2011 April 2011
Part#3 Tom Jan 2011 April 2011

 

[TSinneed]

Sorry, yes. copy/paste issue. Thanks,

 

[Gerald Higgins]

OK I'll take a look.

I have to go offline now, but I'll post back later.
Maybe someone else can come up with a solution in the mean time.