Find highest Date

  • Thread starter Thread starter lunde
  • Start date Start date
L

lunde

Thought this was simple, but not for me ;)

I have a customer.xls sheet and an orders.xls sheet. What I need to find
is the highest purchase date for each customer in customers.xls looking
up into orders.xls. Lookup is based on email address which is unique.

Even more simple is to find number of orders for each customer. Here I
thought that a countif would do the trick, but it just returns "0" :(
 
This is an array formula that must be entered using ctrl+shift+enter
=MAX(IF(D2:D8="aaa",E2:E8))
 
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

Referencing other spreadsheets dynamically 4
Using an Excel Spreadsheet as A Data source for Miscrosoft Query 1
Data from 2 sheets to create a new sheet with user input? 1
Sumproduct function allow a lookup for one Date to check if it fallsin Date Range in other table 9
How do I find the highest of the most repeating values in a list ofnumbers ie. the max of the modes 1
Need help finding the right function, please 4
find the highest letter/number combination 4
Find Highest Date in a range 4

Back
Top