Hi I have an urgent problem, I hope many of you can help me solve.
I need to display the result from a cell in a row, only where it is populated and where it is the first populated cell.
i.e.
Column A B C D E F G H
Row1: , , , , , , 20, 23, 45
Result: 20 (as 20 is the first...