column with numbers - I want to analyze numbers growth

[bob.elliott]

Hi!

Suppose, I have a two (or several) columns with numbers. I want to
analyze two or more columns in a different way, for instance I want to
know the growth in percentage and probably have some visual
interpretation (i.e. arrow up or down).

Is there an Excel plug-in or stand-alone software for this? If anyone
expirienced the same problem? I'm going to look for such a software, if
one have in mind some other "must-have" features that I missed?

Thank you!

 

[Paul Lautman]

Hi!

Suppose, I have a two (or several) columns with numbers. I want to
analyze two or more columns in a different way, for instance I want to
know the growth in percentage and probably have some visual
interpretation (i.e. arrow up or down).

Is there an Excel plug-in or stand-alone software for this? If anyone
expirienced the same problem? I'm going to look for such a software,
if one have in mind some other "must-have" features that I missed?

Thank you!

You could do this with a formula with maybe an IF statement for your visual
interpretation.

 

[bob.elliott]

I'm using now something like this
=IF(H10>=0;"Positive - Growth";"Negative - Resource Lost")

But it seems to be a routine to have some more visualization and
analysis... Probably this task is not for Excel, but for some financial
analysis tool?

 

[Paul Lautman]

I'm using now something like this
=IF(H10>=0;"Positive - Growth";"Negative - Resource Lost")

But it seems to be a routine to have some more visualization and
analysis... Probably this task is not for Excel, but for some
financial analysis tool?

I don't understand "But it seems to be a routine to have some more
visualization and analysis"???

What is this supposed to mean?

If you want pictures instead of words use a font such as Wingdings. If you
want different types of analysis, use a different formula.

 

[bob.elliott]

Well, hm.. this is true, but I really need some automation.

The input data always changes, so I always get a different data in
different format (i.e. cells and column number).

Probably, I need some add-ins or third-party....