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.
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.