I have a column (row 3) from C:Z some columns have data some do not. I want to find the column where the first data appears and then also the last.
I want to copy this formula down to the rest of the rows.
For example, row 3 may have numbers in column E, F,G and V. I want a formula to find the value and pull back what is in column E. Then with another formula I want to do the same thing, but pull back the value in V. Then, in row 4 numbers may be in H, P,Q,W and I want the value in H and the value in W.
I want to copy this formula down to the rest of the rows.
For example, row 3 may have numbers in column E, F,G and V. I want a formula to find the value and pull back what is in column E. Then with another formula I want to do the same thing, but pull back the value in V. Then, in row 4 numbers may be in H, P,Q,W and I want the value in H and the value in W.