PC Review


Reply
Thread Tools Rate Thread

column with numbers - I want to analyze numbers growth

 
 
bob.elliott@aks-labs.com
Guest
Posts: n/a
 
      26th May 2006
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!

 
Reply With Quote
 
 
 
 
Paul Lautman
Guest
Posts: n/a
 
      26th May 2006
(E-Mail Removed) wrote:
> 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.


 
Reply With Quote
 
bob.elliott@aks-labs.com
Guest
Posts: n/a
 
      26th May 2006
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?

 
Reply With Quote
 
Paul Lautman
Guest
Posts: n/a
 
      26th May 2006
(E-Mail Removed) wrote:
> 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.


 
Reply With Quote
 
bob.elliott@aks-labs.com
Guest
Posts: n/a
 
      27th May 2006
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....

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I convert a column of positive numbers to negitive numbers JMason Microsoft Excel Worksheet Functions 1 22nd Jan 2009 02:12 AM
Excel, change column of negative numbers to positive numbers? Nita Microsoft Excel New Users 3 27th Nov 2007 04:54 AM
Converting a Column of Numbers Displayed as Text to Numbers cardan Microsoft Excel Programming 4 12th Sep 2007 05:45 PM
Excel Formula - Add column of numbers but ignore negative numbers =?Utf-8?B?dmlldyBmb3IgRGlzdHJpYnV0aW9uIExpc3QgbWVt Microsoft Excel Worksheet Functions 1 7th Apr 2006 03:13 AM
Calculating growth with negative numbers =?Utf-8?B?VHNpcGk0bWU=?= Microsoft Excel Worksheet Functions 2 29th Dec 2004 05:17 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:42 AM.