Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / February 2007

Tip: Looking for answers? Try searching our database.

formula to display first and last items of a list

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
alfred.cloutier@gmail.com - 15 Feb 2007 17:47 GMT
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.