I did say copy down AND ACROSS as needed. The formula was constructed to
pick-up extra rows and columns..

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"BALEMAN" wrote in message
...
Bob:

Your formula provided the dates that items came into the warehouse
correctly; but, did not show the number of items that came into the
warehouse
on that particular date.

"Bob Phillips" wrote:

On sheet2, A1, input

=IF(ISERROR(SMALL(IF(Sheet1!$B$1:$B$30<"",ROW(She et1!$A$1:$A$30),""),ROW($A1))),"",
INDEX(Sheet1!A$1:A$30,SMALL(IF(Sheet1!$B$1:$B$30< "",ROW(Sheet1!$A$1:$A$30),""),ROW($A1))))

which is an array formula, so commit with Ctrl-Shift-Enter, not just
Enter.

Then copy A1 down and across as far as you need.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"BALEMAN" wrote in message
...
Sheet 1's Column A is a list of consecutive dates (09/01/2006 thru
12/31/2006). Sheet 1's Column B lists the number of items that entered
our
warehouse on a particular date. Not every date in Column A has a
number
in
Column B, i.e., items were not received every day. I need a formula
for
Sheet 2 that would list ONLY those dates when items were received along
with
the number of items that were received on that date.