Let's say your data is in column A. It has lists. Each list is separated by
a single blank

In B1 enter:
=A1
In B2 enter:
=IF(OR((A1=""),(A3="")),A2,"")
and copy down

Column B will show the first and last cell in each of the column A lists.

--
Gary's Student
gsnu200706


" wrote:

I have a number of lists in a single column, each list is separated by
a blank row.

Is there a formula that will display only the first and last item of
each list separately? In other words, each list needs to have its own
first and last entry.

Thanks!