I need to locate the last nonzero term in a row. The rows consist of
zeros and ones.
For instance:
__ A B C D E F
1| 1 1 1 0 0 3
2| 1 0 1 0 1 5
3| 0 1 0 1 1 5
As you can see in column F, I have my desired results (the number of
the column of the last 1). I have tried incorporating SUM and COUNTIF
functions to place where the last 1 would be in a row with a known
size, but I can't figure out how to account for the 0's that are
located within the first and the last 1.
Any ideas? This has plagued me for a couple days now.
Thanks,
Brent
--
wilby31
------------------------------------------------------------------------
wilby31's Profile:
http://www.excelforum.com/member.php...o&userid=27287
View this thread:
http://www.excelforum.com/showthread...hreadid=467919