Forum Discussion
Excel function / formula help
Hi
Need help with something probably very simple but cant find answer
Example
Cell A1 to equal a single value from C1:F1
| Answer1 | Answer2 | Answer3 | Answer4 | ||
| =C2:F2 | wee1 | ||||
| =C3:F3 | wee2 | ||||
| =C4:F4 | wee1 | ||||
| =C5:F5 | wee4 |
1 Reply
If this is what you are trying to achieve...
Try this...
In A2
=INDEX(C2:F2,MATCH(TRUE,C2:F2<>"",0))and then copy it down.
