CAexcelguru
New Member
- Joined
- May 9, 2009
- Messages
- 6
Help!!
I am trying to find a formula, not vba, that will tell me the first column with data in it. For example, I have weeks across the top in columns I to U, weeks 1 in Column 1, to week 13 in Column U. In column F I have dates of when a product was first advertised and in columns I to U there is a $number from the first week an item was sold. In some rows, I have, for example, 0 in column I and J and $50 in column K or U. I want a formula that will tell me the column with the first value in it. I have 1000s of rows and I want to see for each row the first week a item was sold.
help appreciated.
I should add, I have tried MATCH(9.99999999999999E+307,I6:U6) but it returns the last column (U) with a value, not the first column (I)
I am trying to find a formula, not vba, that will tell me the first column with data in it. For example, I have weeks across the top in columns I to U, weeks 1 in Column 1, to week 13 in Column U. In column F I have dates of when a product was first advertised and in columns I to U there is a $number from the first week an item was sold. In some rows, I have, for example, 0 in column I and J and $50 in column K or U. I want a formula that will tell me the column with the first value in it. I have 1000s of rows and I want to see for each row the first week a item was sold.
help appreciated.
I should add, I have tried MATCH(9.99999999999999E+307,I6:U6) but it returns the last column (U) with a value, not the first column (I)
