Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Pablo
 
Posts: n/a
Default Finding & Capturing First Occurance

I have a couple of arrays (Months) & (Sales) and I am trying to capture a
customers first purchase for the year. So if a customer made a purchase in
March, April, September & October I want to return the value of the March
purchase.

Any idea how to do this?

Thanks,
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
could you provide more details about your layout?. There's the customer name
stoed, etc. Maybe post some example rows

--
Regards
Frank Kabel
Frankfurt, Germany
"Pablo" schrieb im Newsbeitrag
...
I have a couple of arrays (Months) & (Sales) and I am trying to capture a
customers first purchase for the year. So if a customer made a purchase
in
March, April, September & October I want to return the value of the March
purchase.

Any idea how to do this?

Thanks,



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
Finding Friday Arlen Excel Discussion (Misc queries) 1 January 23rd 05 05:08 AM
How can i imput a formula in excel for finding the area of a regu. Rona Excel Discussion (Misc queries) 2 January 15th 05 08:17 PM
finding templates Jlo New Users to Excel 1 November 29th 04 11:46 PM
frequency for each occurance bjg Excel Worksheet Functions 3 November 24th 04 02:13 PM
Finding duplicate nuumbers in a column Johnny the hat Excel Worksheet Functions 2 October 29th 04 03:28 PM


All times are GMT +1. The time now is 01:58 AM.

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

About Us

"It's about Microsoft Excel"