taino8632
Board Regular
- Joined
- Nov 16, 2004
- Messages
- 90
- Office Version
- 365
- Platform
- Windows
I am using the following formula to determine the second to last numeric value in a row.
=LOOKUP(2^15,$C2:INDEX($C2:$BB2,MATCH(2^15,$C2:$BB2)-1))
However, in cases where there is only one value in the row I am getting an #N/A error. How do I account for this error? I want to return a blank if there is only one value in the row.
Thanks for your help.
=LOOKUP(2^15,$C2:INDEX($C2:$BB2,MATCH(2^15,$C2:$BB2)-1))
However, in cases where there is only one value in the row I am getting an #N/A error. How do I account for this error? I want to return a blank if there is only one value in the row.
Thanks for your help.