Quote:
Originally Posted by excelledsoftware
Its almost clear as to what you want. I good way of explaining is to include a desired result in your sample sheet. However if I understand right you want to "Concatenate" all of the values in each column into a single cell. The only thing not quite clear is how do you want each value separated. My assumption would be for row 3 with a cross section of 1 would result in 1.25;1.50;1.75;2.00
Is this correct and if so are you against it being a VBA script.
|
Not exactly. My question is not posed correctly. it is not Merge or Concatenate that i want to do, see attached file.
The function in AA3
=IF(COLUMNS($AA$3:AA$3)>COUNT($C$3:$Y$13);"";SMALL ($C$3:$Y$13;COLUMNS($AA$3:AA$3)))
works well for the defined area ($C$3:$Y$13), all height values are displayed in ascending order, each unique value in a single cell, from AA3 to DY3.
However, I would also like to write a function that is repeatable in the sense that i could just drag it downwards (or copy paste into cell AA20) for the next set of sub sample data (C22:Y39), here called Plot 8, without including the first set of data (Plot 7, ($C$3:$Y$13)).
So I need an altered version of the selection process in the function above. Or a completely new approach?
09-09-2014, 02:30 AM
Similar Threads
Sum values within a single cell
Windows 7 64bit 
Office 2010 64bit
Threaded Mode