Finding & Capturing First Occurance

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
Hi
could you provide more details about your layout?. There's the customer name
stoed, etc. Maybe post some example rows
 
You must log in or register to reply here.

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 5
Final "bug bash" before Windows 10 Autumn Creators Update 4
Find/Replace Select Numbers in a Cell 3
Months of review 7
Pivot table and customer analysis 1
SUMIF 1
Using SUM with INDIRECT function 8
SUMIF conditions 3

Back
Top