With CellworXs® you will be able to easily:
- Convert a text string to a real formula that is properly evaluated.
- Count the number of unique items from a list with multiple item occurrences.
- Return individual unique items from a list by specifying an index number.
- Return a period value based on a 12 or 4 columns table depending on your period and frequency selection (see sample below).
- For more details or examples, please check the demo videos or download the CellworXs® user guide.
The following sample shows how one formula returns the different desired period and frequency values of a 12 column table, simply by changing the formula parameter of "period" and "frequency":
