Finding latest data record with different dates

You can use the Sort or Pivot table

Hi, welcome to the forum

See if this will help. Assuming your data looks a bit like thtis...

	A	B	C
1	4/9/2015	aa	4/16/2015
2	4/10/2015	bb	bb
3	4/11/2015	cc
4	4/12/2015	aa
5	4/13/2015	bb
6	4/14/2015	cc
7	4/15/2015	aa
8	4/16/2015	bb
9	4/17/2015	cc
10	4/18/2015	aa

C1=MAX(IF($B$1:$B$10=C2,$A$1:$A$10,0))

This is an ARRAY formula...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Thank you!

Might help if I share what I am working with to explain it a bit better.

Cells c-z has data I want to use but only for the latest visit to each of these stores. Eg 18/2/2015 1 Stop Shop

A B
1 8/01/2015 1 stop
2 18/02/2015 1 stop
3 5/02/2015 142 Onepu Rd Dairy
4 8/01/2015 24/7 Convenience
5 9/02/2015 467 Dairy
6 2/03/2015 467 Dairy
7 9/03/2015 467 Dairy
8 12/03/2015 467 Dairy
9 1/04/2015 467 Dairy
10 7/01/2015 543 Mart
11 10/02/2015 543 Mart
12 18/03/2015 543 Mart

Did you try my suggestion?

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.