PDA

View Full Version : Quick Find of most recent date/time without having to sort.



Virginal
04-06-2012, 01:06 PM
I have a dataset with a large number of rows. I sort this by Shop, Sales Person, DateTime Last Sale.

I now want to find the most recent "date/time last sale" for each shop, the obvious thing seems to do a pre sort but that seems like using a sledgehammer to crack a nut.

I want to use the quickest way to find those dates and maybe doing the sort is not so resource hungry as I think.

All opinions welcome

GTO
04-06-2012, 05:09 PM
Did you try the suggestion Here (http://www.mrexcel.com/forum/showthread.php?t=626913)?

Aussiebear
04-07-2012, 02:17 AM
Cross posting....... when will they learn?