Previously I had asked how to get the value from a cell which lines up with the first nonzero cell in a range. Things are a LITTLE more complicated now.
Referencing the picture. I need to find the value in column c for the first F/G/H row that has a non-zero value (in this case row 138).
The answer I received before was selection as the solution. And it worked for a while until the client did something new--she didn't put a value in F/G/ AND H.
So I have to account for rows which have 1, 2, or 3 values in a row.
I'm only interested in which is the first row encountered with a value in F/G OR H.
(Must be formula. Some clients will not allow macros to run on their machines).