Crate a Cross Table with only Total numbers

**Mido** · 08-24-2009, 03:14 PM

Hello everyone,

I want to make a crosstable (7 columns X 6rows) but the thing is that I only have the total number for each row and for each column, how do I do to get the whole numbers of the crosstable?

Thank you very very much

**shg** · 08-24-2009, 03:31 PM

Pardon ...?

**Mido** · 08-24-2009, 04:19 PM

I made an excel attachement like an example, I need to find the values in the ''?'' cells

**shg** · 08-24-2009, 05:08 PM

Any restrictions on values, e.g., all > 0?

Repeated values allowed?

What's the purpose?

**Mido** · 08-24-2009, 05:13 PM

No, there's no any restrictions on values, they represent number of persons, so all values should be positive. I just have to make a detailed table, but all I have are the total values.

Thank you very much again

**shg** · 08-24-2009, 05:21 PM

It doesn't cross-foot. The sum of the totals row is not the sum of the totals column.

**Mido** · 08-24-2009, 06:07 PM

Ow sorry shg, I made a mistake, here is a corrected file. How do you do the cross-foot??

**shg** · 08-24-2009, 06:21 PM

I added the row at the bottom and the column at right.

**Mido** · 08-24-2009, 06:30 PM

Ok, and do you think it's even possible to the get all the other values with just the totals? I think from the mathematic point of view, it is, but I don't know if it's possible with excel?!

**shg** · 08-24-2009, 11:46 PM

It requires VBA, which means anything is possible, given eough time and memory.

In general, I would assume that there are zero or more solutions. If all the column totals were 10, and all the row totals were 100, for example, there would be no solution.

Tell me more about why you want to do this -- it might be motivational.