B
BryGuy77
Hello all,
In Excel 2007, have a data array that contains blank lines. Is it possible
to list only the cells with values? Ill give an example:
A1='blank'
A2='blank'
A3=5/5/08
A4='blank'
A5=7/7/08
Can I list this so it ends with: 5/5/08, 7/7/08? I tried CONCATENATE, but
the blanks return ", ". And now I'm lost.
In Excel 2007, have a data array that contains blank lines. Is it possible
to list only the cells with values? Ill give an example:
A1='blank'
A2='blank'
A3=5/5/08
A4='blank'
A5=7/7/08
Can I list this so it ends with: 5/5/08, 7/7/08? I tried CONCATENATE, but
the blanks return ", ". And now I'm lost.