Of course, I test my formula. Did you try that?

I did. The calculation time was so long I thought it wasn't working! <VBG

Biff

"Teethless mama" wrote in message
...
Of course, I test my formula. Did you try that?

"T. Valko" wrote:

Did you test that?

Biff

"Teethless mama" wrote in
message
...
In sheet 2:
A1: holds January
B1: holds February
C1: holds March
and so on...

A2:
=IF(ISERR(SMALL(IF(TEXT(dates,"mmmm")=Sheet2!A$1,R OW(INDIRECT("1:"&ROWS(names)))),ROWS($1:1))),"",IN DEX(names,SMALL(IF(TEXT(dates,"mmmm")=Sheet2!A$1,R OW(INDIRECT("1:"&ROWS(names)))),ROWS($1:1))))

ctrl+shift+enter, not just enter
Copy across and down as far as needed


"Jman" wrote:

I want to work with two sheets.

I have a sheet"1" column (a1) "names",
column (b2) "dates"

Example
a1
John Mcarther ....1-15-07
David Chrysler.....1-06-07
Chris Bobby .......2-15-07
Dan John.............3-15-07

b1
1-15-07
1-06-07
2-15-07
3-15-07

What i want to do in Sheet 2 have. Column A1 Named (january) and B2
(february) and B3 (March) and so on thru the whole year.

When i enter the name and date in sheet one.. I want that data to
automatically be transfered in the appropriate "month column" in sheet
2.

example

a1
(January)
John Mcarther
David Chrysler

b1
(Februrary)
Chris Bobby


C1
(March)
Dan John.