formula to display first and last items of a list

  • Thread starter Thread starter alfred.cloutier
  • Start date Start date
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!
 
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.
 
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
Dependent drop down dynamic range formula, off sheet. 7
Counting multiple memberships 1
Take first word out of cell and put it in a new cell 5
Formula results display only after pressing Enter key 1
Complex Median Formula 0
Summary of Unique item values 2

Back
Top