Excel function to return a row's column number that has data
Posted on 2011-04-20
Thanks as always in advance for your help.
I have a file that gets created from an export from a program. The way the export program sends the data out causes the data for a particular row to either be in column A, B or C (it varies). One row the data will be in A, the next in B the next back to A, the next to C etc.. Each row has only one column's cell that will have data.
I have looked for a function that would look at columns A:C find which column of the particular row had data and get that data. Essentially pulling all the data in to One Column for all rows.
I've looked at Hlookup; Index etc.. but can not get anything to work. Probably because I'm writing the code wrong.