How To Pick-Up 1st Number From A Row?

[xlmaniac]

Dear All,
I do have a sample data set across C1:F1(Numbers) as follows:-
C1=2
D1=3
E1=5
F1=6
In cell B1 I would like to populate the 1^st number i.e 2 from C1.
I know it is simple but could not get the same done.
Could somebody help me out pls?
Regards

 

[mole999]

I doubt this is what you want, but appears to be what you are asking for

in B1 =C1

 

[Peter_SSs]

Also try

=INDEX(C1:F1,MATCH(TRUE,INDEX(ISNUMBER(C1:F1),0),0))

If the problem still remains unsolved, please give more varied examples, the expected results and further explanation.

 

[xlmaniac]

Also try

=INDEX(C1:F1,MATCH(TRUE,INDEX(ISNUMBER(C1:F1),0),0))

If the problem still remains unsolved, please give more varied examples, the expected results and further explanation.

Dear Sir,
Thank you so much for helping me out once again with yet another mesmerising solution.
This is exactly what I was looking for.
Thanks once again.
Regards

 

[Peter_SSs]

Dear Sir,
Thank you so much for helping me out once again ...

You are welcome.