formula to display first and last items of a list

A

alfred.cloutier

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!
 
G

Guest

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.
 
T

T. Valko

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to choose from the last column of a given row 1
How do I format list of names formatted last,first to first last? 13
Multiple List Analysis 0
Formula (or code) return the largest number of duplicates in a list. 16
First, Last occurance of date in column 5
Max Value of conditional list 6
Extract first value and last value from a table 1
Find the last number in a row 6

Top