This is hard to explain. I have two rows, one row with 1 2 3 4 5 6 7 8 in each column and, for example, a value in column 2 4 6 and 8. I want to return a value, ideally in an array in one cell, that contains the column numbers (2 4 6 that contain values. So, I want to return each value that has a value in a different row below the top row. I hope this makes sense.
Also, is there a way to return a value that tells how many cells contain data within an array, or group of cells?
Thanks guys! If this doesn't make sense, please let me know.