Script - Data Util #
Calculation #
growthRate #
Calculate the growth rate.
achievementRate #
Calculate the achievement rate.
CAGR #
Calculate the CAGR.
WordFill #
If there is a value in the right side of the selected reference column, fill the cell value in a DB format.
allDecimals #
In the case of numbers with decimal points, all decimal points come out.
upsidedown #
Return the data of the selected column and return it to the right side.
inputRandomValue #
Enter the sequential date or random integer.
sepText #
In the text that is mixed with characters+numbers, only the number is returned to the right side.
Handling Name #
tableToArray #
Copy the clipboard to set the table as a name definition.
shownamelist #
Call the currently defined name list box.
→ double click : activate name area
pivotRefresh #
Automatically update the Pivot Table.
LaunchTextSplitter #
split text from pdf table.
dietFileSize #
Excel file size diet. check all sheet and clear.
