applying formula to 2400 columns, but that each references a previous column's values?
I have a table of 2400 columns and 311 rows. Each column has values and no formula. However, I have a single formula I want to use on each column that references that column's values. For example, for column "80" I have next to it another column with this: Abs(
Col Sum(
(:Name( "80" ) / Col Sum( :Name( "80" ) )) *
Ln( :Name( "80" ) / Col Sum( :Name( "80" ) ) )
)
) / Ln( Col Number( :Name( "8...
vince_faller