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!
Gary''s Student - 15 Feb 2007 19:04 GMT
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.

Signature
Gary's Student
gsnu200706
> I have a number of lists in a single column, each list is separated by
> a blank row.
[quoted text clipped - 4 lines]
>
> Thanks!
T. Valko - 15 Feb 2007 19:19 GMT
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
>I have a number of lists in a single column, each list is separated by
> a blank row.
[quoted text clipped - 4 lines]
>
> Thanks!