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!

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!

Give each list a defined name like: List1, List2, List3 etc.

For the first entry in any list:

=INDEX(List1,1)

For the last entry in any list:

=INDEX(List1,ROWS(List1))

Biff

wrote in message
ups.com...
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!