Japanese version. Here is a formula that performs a cross tabulation in Spill.This formula automatically reflects the increased data when the source data for cross tabulation increases, without the need to edit the cross tabulation sheet. Functionally, it is similar to what can be done with a pivot table.If that is sufficient, there is no need to use Spill. The advantage of this method over pivot tables is that it does not require manual updating of data.Therefore, when performing multiple cross tabulations from the same dataSpill is more advantageous because there is no need to update the data.Note that this method may not be available for older versions of Excel … Continue reading Formula for cross tabulation in Spill.(Microsoft Excel)