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 ...
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.