Change in values

[ssss]

Hi,

Can anybody please help?

I need to find a change in the value of current assets from the
previous year. However, I have different companies. Example of data:

Companies Date Current Assets
A 31/12/1999 $2
A 31/12/2000 $2
A 31/12/2001 $3
B 31/12/1998 $2
B 31/12/1999 $4

So for 2000 the answer would be $0. But i have different companies- so
i can't just copy the formula.

Please help!!!!!!

 

[Beth Unglesbee]

Hi there,

Let's assume your data is sorted first by company in
ascending order, then by date in descending order.

Company in column A, Date in Col B, Asset in Col D.

I put another formula in column D that looks like this:

=IF(A6=A5,IF(C5=C6,"",RIGHT(B6,4)),"")

This compares the company name from the previous line and
if they are the same shows the right most 4 characters
from the date column. Note, I was originally using the
Year(B6) function, but your dates are not seen as a date
type to Excel. So depending on your data, you can either
use the "right" function, or the "year" function.

HTH
Beth
Microsoft MVP - Excel