如何在同一组中找到价值中位数？
态
分享与我所包含的图片相同的组（季度）。我已经对它们进行了编码，以显示它们相应的值，并在右侧包括示例中位数。我希望这使我的问题更容易理解。
我需要为零件正在更改的较大列进行此操作。是否可以自动化此过程？如果是这样，我需要什么样的公式来输入“？”的位置。被放置在右下角所见吗？
另外，它可以在图片中不像图片中的组（四分之一）排序的列上使用吗？
感谢您提前提供任何帮助！
Hi there, I'm trying to find the median of the values (Price) that share the same group (Quarter) as in the picture I have included. I have colour-coded them to show their corresponding values and included example medians on the right-hand side. I hope this makes my question easier to understand.
I need to do this for a larger column where the Quarters are changing. Is it possible to automate this process? If so, what kind of formula would I need to input where the '?' is placed as seen in the bottom right-hand corner?
Also, would it work on a column where the group (Quarter) is not sorted like in the picture?
Thank you for any help in advance!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
这可能适合您的目的，而不是列出中间数据，而是该公式列出了您范围内的四分之一的唯一列表，并在每个相应的季度计算中位数。
您所要做的就是更改季度和价格范围，
a2：a7和b2：b7在我的示例中，与您的数据对齐。无论季度在什么顺序中，该公式都将工作。
This might work for your purposes, instead of listing median along side data, this formula takes a list of unique the quarters in your range and calcualtes the median for each corresponding quarter.
All you have to do here is change the quarter and price range,
A2:A7andB2:B7in my example, to line up with your data.This formula will work no matter what order the quarters are in.