Good pickup Max, same in current versions. Plan B then in my book :-)
Autofilter your data and filter on just 2003. Put -1 in an empty cell and
copy the cell. Select all the visible data (numerics only) and do edit / Go
To / Special / Visible cells only, then do Edit / Paste Special / Multiply.
Now just refresh your table. Not ideal because one set of data is all
negative, but you can now use the Grand Totals for rows as your delta field.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Ken Wright" wrote in message
...
Hmmm - must admit I missed the bit with th two fields in there - Will take
a
look and post back - Cheers for the catch Max.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--
<snip
|