|
Posted to microsoft.public.excel.misc
|
|
|
Concatenating non adjacent cells
http://www.microsoft.com/office/comm...2c1&sloc=en-us
"Bob Freeman" wrote:
Hello - I am trying to create a field that concatenates cells that are
populated from the previous 12 cells on that row, but excluding blanks and
adding a * delimited character between each instance. Please find a 4 column
example below
ID 1 2 3 4 Result required
Z A C D A*C*D
Y B C B*C
X A B D A*B*D
I will be applying this to a 2007 version spreadsheet containing in excess
of 10,000 lines. There will be at least 5 blank cells on each row.
Many thanks - Bob
|