I can't see how to use DataPilot for this.
What I need to now to do what I want is:
Is there a function to test if a cell is empty?
How do I concat a constant string to a cell content?
When I copy a formula, how do I prevent cell H4 to change to H5, H6, H7 ...
(while H6 in the same formula still should change this way)?
If I get the last questions answer I can complete my work, if I get all
answered I can understand what I have done next month as well :)
/David Pettersson
David Chapman wrote:
Perhaps the DataPilot may be of use to you - it is similar to the Excel
Pivot Table feature...
http://www.openofficetips.com/blog/archives/2004/09/datapilot_101.html
http://www.openofficetips.com/blog/archives/2005/08/datapilot_revis.html
http://www.openofficetips.com/blog/archives/2005/08/datapilot_revis_1.html
On 11/14/05, David Pettersson <[EMAIL PROTECTED]> wrote:
Hi,
I use calc for data processing in my research. I have a number om
columns which looks simplified like this
num A B C D E F
1 a x l
2 c y f
3 a y k
A want to add another column that contains all the data in compressed
form like this
num A B C D E F Compr
1 a x l A(a)C(x)E(l)
2 c y f A(c)D(y)E(f)
3 a y k B(a)C(y)F(k)
That is I want is the results from
for each column: if cell not empty
-> concat <column_heading>(<cell_content>) to result;
else
-> concat nothing to result;
Here, <column_heading> is the content of the cell in the column in
question on row number 4.
What I actually want to do is to find out all types of combinations that
occure in the data and to find its frequencies. The number of colums is
to large to do this by "sort and count". I would be grateful for other
ways to achive this goal as well.
Thanks
David Pettersson
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
My OpenOffice Calc Website
http://www.openofficetips.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
