Copyright © 2008 – 2019 DARE!! International
Page 28
As an example, this will result into the following Excel table:
5.1.3
Create the text string per frequency
This can be done using the following formula:
“=CONCAT(AD14;",";AE14;",";AF14;",";AG14;";")”.
-
“AD14” must be the cell where the frequency is stored
-
“AE14” must be the cell where the CF of the X-axis is stored
-
“AF14” must be the cell where the CF of the X-axis is stored
-
“AG14” must be the cell where the CF of the X-axis is stored
As an example, this will result into the following:
