Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concantenating non adjacent cells
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add cells on two adjacent rows but non-adjacent columns | Excel Worksheet Functions | |||
adjacent cells? | Excel Worksheet Functions | |||
Yes or No for adjacent cells | Excel Worksheet Functions | |||
By selecting cells adjacent to cells tally sheet | Excel Worksheet Functions | |||
How do I fill (copy) nonadjacent cells to adjacent cells? | Excel Discussion (Misc queries) |