Change in values

  • Thread starter Thread starter ssss
  • Start date Start date
S

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!!!!!!
 
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
 
Back
Top