SMALL function

S

stewart.mcguire

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?
 
P

pinmaster

Hi,

Try:

=MAX(IF(Sheet1!A1:A100="john",Sheet1!B1:B100))
or assuming A1 is the cell the name "John" then
=MAX(IF(Sheet1!A1:A100=A1,Sheet1!B1:B100))
enter using Ctrl+Shift+Enter

HTH
Jean-Guy
 
R

Ron Coderre

Try something like this:

With
Sheet1
A1:B10 contains names in Col_A, dates in Col_B

Sheet2
B1: (a name to match)

This formula returns the largest date on Sheet1 that is associated with the
name referenced in cell B1

C1:=MAX(INDEX((Sheet1!A1:A10=B1)*(Sheet1!B1:B10),0))

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Top