Thread: SMALL function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] stewart.mcguire@btinternet.com is offline
external usenet poster
 
Posts: 1
Default SMALL function

Hello my friends.

I have 2 columns of data in Excel. Column A is a list of names, all the
names have more than one entry. Column B is filled with various dates.
I want to use the data on this sheet to populate a cell on another
sheet with the oldest date in column B for any selected name.

I know the SMALL function will have to be in there somewhere, but this
one has got me beat. Any ideas out there?