MS Excel排序公式
Microsoft Money曾经是一个出色的计划，可以跟踪养老金投资组合，因为它显示了每周，每月，每月3个月和每年的价值变化，现在不再得到支持，我一直在试图找到替代方案。我现在有一个带有MS Excel的I Mac，但是我正在尝试进行以下类型并显示以下内容，并尝试按照MS Money Mons的了解。 [样本] [1] 该数据每周更新，并想知道是否可以复制MS货币。 [1]：https：//i.sstatic.net/blahl.png
Microsoft money used to be a brilliant programme for keeping track of a pension portfolio in that it showed value change weekly, monthly, 3 monthly and year to date, now it is no longer supported I have been trying to find an alternative. I now have an I Mac with MS excel on but am trying to do a sort and display on the following and try keep track as per MS Money did.
[Sample][1]
This data is updated weekly and would like to know if it is possible to replicate MS Money.
[1]: https://i.sstatic.net/BLahL.png
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
好的，让我们尝试您所说的话，看看是否可以让您关闭：
命名范围（ link> link ）日期和值
运动（当前价值 /值 /值1周前
）
每周 ：
YTD：
假设那些名为范围的人，并且日期完全相隔每7天。如果还寻找最接近1个月前，3个月前和年初的日期。
它也将当前值作为开始时值的百分比
ok so lets try the things you said about and see if we can get you close:
name the ranges (link) dates and values
weekly movement (current value / value 1 week ago):
1 month movement:
3 month movement:
ytd:
this assumes those named ranges and that the date is exactly every 7 days apart. if also looks for the closest date to 1 month ago, 3 months ago and start of year.
also it does a current value as percentage of the start value for the period