Hi
I need to look in a row of cells and see what is the first number that appears.
Example
Name D1 E1 F1 G1 H1
Jane 7 8 8 9 10
Paul 6 6 7 9
So in A1 for Jane I need it to show 7 and in A2 for Paul i need it to show 6.
Is there a formula to do this?
Thanks
Bookmarks