Folks,
I have an Excel 2003 question. I have a particular column filled with character information, but not every cell in the column has data in it. I want to retrieve only the non-blank information from this column into another column. So for instance, I am retrieving data from column C and C1, C4, C9, and C19 all have valid text data in them. I want Column D, rows 1 - 4 to contain the values in C1, C4, C9, and C19, and so forth. I believe this solution probably requires a lookup function along with and isblank function ( or something like this ), but my solutions are not coming along as well as expected and I don't have as much time as I would like to play with this. Can anyone please suggest a solution for this? Thanks so much.
Scott
I have an Excel 2003 question. I have a particular column filled with character information, but not every cell in the column has data in it. I want to retrieve only the non-blank information from this column into another column. So for instance, I am retrieving data from column C and C1, C4, C9, and C19 all have valid text data in them. I want Column D, rows 1 - 4 to contain the values in C1, C4, C9, and C19, and so forth. I believe this solution probably requires a lookup function along with and isblank function ( or something like this ), but my solutions are not coming along as well as expected and I don't have as much time as I would like to play with this. Can anyone please suggest a solution for this? Thanks so much.
Scott