Top ten oldest and top ten newest

Someone solved a less complicated example of this for me in the past but my columns were in different orders and I cannot get it to work with my asset tag (unique identifier) being in column A now, sadly.

I'd like to just see the top ten oldest and newest installs. I thought this could be accomplished with LARGE and SMALL formulas? Please see all three tabs on attached file.

Thank you in advance!

How about just sorting by purchase date, then copying and pasting the first and last ten rows?

Hi

Although your details say Xl2003, you have posted an xlsx workbook, which means you must be using XL20007 or 2010.

Take a look at the attached workbook.
In column O I have calculated the age in days, by simply using the formula
=TODAY()-B12
This gives the actual age of each asset.

In column P I have shown the youngest age of each asset, by taking the value in column O away from 50000 with the formula
=50000-O2

Then, applying autofilter to the top row, on column O select> Number Filters>Top 10 and you will get the oldest assets (many are equal in age)

Doing the same thing for column P will give the Youngest Top 10

Hello jhiltabidel,

See the attached. Does this help?

Haseeb, This is perfect, thanks! Now I have to figure out how you did it.

Originally Posted by jhiltabidel

I appreciate the help, but I do need to see more than just the asset tag number, unfortunately. Thank you.

Hi
Apologies - the wrong copy of the file got posted.
It did not have the formulae in it, nor the selection for Youngest and Oldest.

Using the Filter for Top 10 on either column, will show all of the data, not just the Tag number.

You cannot have just the top 10 however, as there are 70 or so assets purchased on the same day.

Why are the rows off by 2?

That because, MATCH function start to look at A3 not from A1 in data sheet, used a dynamic named range Data. The range starts at A3 to down on Data sheet. Therefore rows are off by 2.

Hope this helps.

Hello Joe,

Use the whole column reference, instead of named range. This will give the accurate row numbers. See the attached.