Numbers - Different above and below.

[david gabra]

Hi

This analysis would so helpful since if possible.

This follwing needs to be performed separatley for each employee.

I wouid like to know if excel can identify a value that is different to the one above it


The first line for each employee should state "first" since that is the base from which we will test
all other values.

If the value above is higher than the cell above - should state "higher"
If the value above is same as the cell above - should state "same"
If the value above is lower than the cell above - should state "lower"

I have provided a worked example.

Thank you

David

 

[bosco_yip]

In E2, copied down :

=IF(A2<>A1,"first",IF(C2=C1,"same",IF(C2>C1,"higher","lower")))

or,

=IF(A2<>A1,"first",TEXT(C2-C1,"""higher"";""lower"";""same"""))

Regards
Bosco

 

[david gabra]

That works as needed.
I did not imagine it could be done so simply.
Many many thanks for your help

 

[david gabra]

Hello,
Would it be possible to add an enhancement that show the % change (increase, decrease, or same) of each line by line.
I have added a worked example, and all the formulae from above.
thank you
David

 

[bosco_yip]

Hello,
Would it be possible to add an enhancement that show the % change (increase, decrease, or same) of each line by line.
I have added a worked example, and all the formulae from above.
thank you
David

E2, copied down :

=IF(A2<>A1,1,IF(C2=C1,0,IF(C2>C1,(C2-C1)/C1,(C1-C2)/C1)))

and,

Format cell >> Number >> Percentage

Regards
Bosco

 

[david gabra]

Cool!!!!!!
how can I make it -so that is the it is a decrease - the ''% will be negative.
just thought of that now.
I know I filter using the prior column - i want just if this is possible.
all my attempts failed :-(

thanks