Hi!

Just add another array:

A1 = 3/1/06

B1 = 3/15/06

C1 = some name

Assuming th names are in column A.

=INDEX('data entry'!$A$3:$U$34,SMALL(IF(('data

entry'!$A$3:$A$34=$C$1)*('data entry'!$C$3:$C$34=$A$1)*('data

entry'!$C$3:$C$34<=$B$1),ROW($1:$32)),ROW(1:1)),CO LUMNS($A:A))

What does the asterisk in the formula do?
It's the multiplication operator. The (now) 3 arrays are multiplied

together:

(A3:A34=C1)*(C3:C34=A1)*(C3:C34<=B1)

For a deluxe explanation of how this formula works, see this

http://tinyurl.com/njzjh
Biff

"steve_sr2" wrote in message

...

That worked great. Thx. Couple of more questions. If I were to add an

additional element into the equation, for instance, employee name in

between

certain dates, how would the formula look. Also, What does the asterisk

in

the formula do?

"Domenic" wrote:

Yes...

In article ,

steve_sr2 wrote:

Thanks for the help....Should this be entered with Ctr+Shift+Enter?

"Biff" wrote:

Hi!

One way:

Use 2 cells to hold the date criteria:

A1 = 3/1/06

B1 = 3/15/06

Array entered:

=INDEX('data entry'!$A$3:$U$34,SMALL(IF(('data

entry'!$C$3:$C$34=$A$1)*('data

entry'!$C$3:$C$34<=$B$1),ROW($1:$32)),ROW(1:1)),CO LUMNS($A:A))

Copy across then down.

It'll start extracting from column A (name).

Biff

"steve_sr2" wrote in message

...

I have two sheets. Sheet1 has multiple lines of data. Based on

criteria

chosen in sheet2, I need to display in sheet2 all of the rows of

data that

match the criteria. I'm having trouble with multiple criteria

(i.e. for

name1, I want all matching rows of data in a certain timeframe.

Not all

data

in ColA is are same name and will not be in any particular order.

Sheet1

A B C D E F G H I

Bryan D Smith 2/1/06 1 2 2 6 6 1

Bryan D Jones 3/1/06 2 1 3 4 2 1

Bryan D Smith 3/5/06 1 1 1 1 1 1

Sheet 2 would return based on user selecting between dates of

3/1/06 &

3/15/06

Bryan D Jones 3/1/06 2 1 3 4 2 1

Bryan D Smith 3/5/06 1 1 1 1 1 1

I can get it to return all of the items for that match in column A

but how

do I for certain dates?

Here is my formula that I'm using to get all rows that match

{=INDEX('data entry'!$C$3:$U$34,SMALL(IF('data

entry'!$C$3:$C$34=$F$5,ROW($1:$32)),ROW(1:1)),3)}

Thanks in advance for any help!