Concantenating non adjacent cells
Hello,
Apologies for this - My browser has not been updating so I have not been
able to see any responses - will now check
Apologies again
"מיכאל (מיקי) אבידן" wrote:
The answer/suggestion/solution will remain the same as in ALL your previous
posts.
Micky
"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
|