How to calculate no. of days from last incident? Multiple stores with > incident dates

Hello All

I am new to this forum,or any other forum for that matter and appreciate in advance any help that you may provide!

Have a list of multiple store numbers ,each with several incident dates. What i need to calculate is the last incident date for each store number.

See below data i am working with.

Store No. Report Date
100 24/01/2013
101 23/01/2013
100 18/01/2013
102 18/01/2013
103 07/01/2013
100 29/01/2013
101 29/01/2013
103 15/01/2013
104 25/01/2013
100 07/02/2013
101 25/02/2014
102 19/02/2013
102 27/01/2013
104 15/01/2013
101 20/02/2013
101 16/02/2013
100 20/01/2013
103 23/01/2013
101 11/01/2013


Many thanks,
Ana

Prepare a unique list of store numbers, i.e. 100, 101, 102, 103 etc. - suppose this is in column D, starting in cell D2 so you can have a heading above. Then you can put this array* formula in cell E2:

=MAX(IF(A$2:A$100=D2,B$2:B$100))

Adjust the ranges to suit if you have more data.

*An array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE), rather than the usual <Enter>.

Format the cell as a date in the style you prefer, then copy down the formula to the bottom of your unique list.

Hope this helps.

Pete

Pete, that is great, it worked just fine!
Thank you!

Glad to be of help - thanks for feeding back.

Pete