Thanks for feedback.
Please note this is not really an array formula - no need to use
CTRL+SHIFT+ENTER
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Charlie" wrote in message
...
I figured there was an array formula way of doing it but got stumped (said
the tree to the lumberjack.) Thanks. :-)

"Bob Phillips" wrote:

=INDEX($A$1:$F$1,MAX(IF(B2:F2<"",COLUMN(B2:F2))))

which is an array formula, it should be committed with Ctrl-Shift-Enter,
not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets),
do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Charlie" wrote in message
...
I must be sleepy because I can't think of a better alternative to this.
I'm
using nested IF's to get the last entry in a row, and moving the column
header (percent completed) to the end of the row. This seems clunky,
plus
some sheets have 10% increments and the formula nesting is limited to
7.
Any
ideas?

25% 50% 75% 100% Pct Complete
Alpha 10/12/07 25%
Bravo 10/12/07 10/14/07 50%
Charlie 10/13/07 10/19/07 75%
Delta 10/15/07 50%

This is the formula down column F.
=IF(E2<"",$E$1,IF(D2<"",$D$1,IF(C2<"",$C$1,IF(B 2<"",$B$1,""))))

TIA
Charlie