Posted to microsoft.public.excel.programming
|
|
nested formula alternative
Hi,
May I know the use of -ROWS($1:1)?
It seems that this will always return -1
Rick Rothstein (MVP - VB) wrote:
This seems to work. Put the following formula in F2 and copy down...
=OFFSET(B2,-ROWS($1:1),COUNTA(B2:E2)-1)
Rick
"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
|