Worked like a charm! It's a keeper. Again, thanks!

"Bernard Liengme" wrote:

On Sheet three starting in A1 I have three columns of text
apple dog blue
pear cat green
peach bird yellow
plum red
prune


On Sheet1 I have these formulas
=OFFSET(Sheet3!A:A,COUNTA(Sheet3!A:A)-1,0,1)
=OFFSET(Sheet3!B:B,COUNTA(Sheet3!B:B)-1,0,1)
=OFFSET(Sheet3!C:C,COUNTA(Sheet3!C:C)-1,0,1)
and they return, respectively
prune
bird
red

Hope you can adapt to your use
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Suzanne" wrote in message
...
Greetings. On one tab i have several projects (taking approx 6 columns
each),
each having several rows beneath with project steps. The project steps
each
have a corresponging Status colum (column to the right of the step).
I've constructed a summary tab that returns certain hi level data elements
for each project (using hlookup). However, i'd like to include a current
status column in the summary tab, for each project. Assuming the current
status is the last status listed in the status column, how to i return
that
value to the summary tab? Hope someone out there can help. Many thanks.

Formula for
summary tab this column? project tab
Start Status Proj1
Proj2
Proj1 2/1/07 On schedule Start: 2/1/07 Start:
3/3/07
Proj2 3/3/07 Behind schedule Step1: On schedule Step1:
Behind
schedule
Step2: Behind schedule
Step2: On schedule
Step3: On schedule
Step3: Behind schedule