Finding & Capturing First Occurance

P

Pablo

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,
 
F

Frank Kabel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mapping strings to integers 6
Month days over a time period 5
Value of the first day of a year in a list 5
Find/Replace Select Numbers in a Cell 3
Copy previous record into form field 0
Pivot table and customer analysis 1
number of months and days between two dates without approximation 3
SUMIF 1

Top