excel：我想按日期对数日期进行排名，而日期在多行中出现相同的日期。不排名日期。排名值
有3列，日期，值，等级。
我手动输入了等级，但是正在为这样做的公式而努力。
我理解并且可以轻松地使用Excel等级函数，但在尝试按日期单独排名时不知道该执行此操作。 请让我知道，如果有一个公式，我可以将其拖动以填充值的等级（最高数字，数字1，数字2，数字3，数字3等）到每个单独的日期）。我无法发现一个公式，该公式可以让我拖延并按日期填写排名。
There are 3 columns, Date, Value, Rank.
I manually inputted the Rank, but am working on a formula to do this.
I understand and can easily work with the Excel rank function, but don't know how to do this when trying to separately rank by date.
Please let me know if there is a formula available that I could drag down to fill the rank of values (highest with the number 1, 2nd highest with the number 2, 3rd highest with the number 3, etc) by each separate date. I have not been able to discover a formula that would allow me to drag it down and fill in the rank by date.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
找到了解决方案。
参考附件图像，假设位于
a1上的“日期”单元格，解决方案将是：将此公式从
c2拖到c15将产生与我手动输入的相同结果。Found the solution.
Referring to the attached image, assuming that the "Date" cell located at
A1, the solution would be:Dragging this formula down from
C2toC15would produce the same results that I manually entered.