Dear excel(lent) users,

When I make a comparison of two sets of information from two different files
I compare date from columns.

For instance in Column A I have data from file one (copy-c/Copy-v) and from
the second file I make a selection by using an if statement.

If a certain cell in column D in File 2 is filled (with a date), then I
want the entry from the cell of column B in the same row. I use
=ALS('[File2]Sheet1'!$D3<"";'[File2]Sheet1'!$B3;1) Where ALS is dutch
for IF.

When I perfom this I get the following sequence (for instance):
1356
1357
1358
1359


1362
1363

1365

1367
1368
1369
1370


The problem is that this gives me empty lines. How can I skip these empty
lines so it will only give me the entries that have a date in Column D. I
want the sequence to be like this:
1356
1357
1358
1359
1362
1363
1365
1367
1368
1369
1370

Can this be automated?

Thanks for your help !!
--
** Fool on the hill **