自动分组/合并Excel [英] Auto Grouping/Merging in Excel

问题描述

我认为附加的图像比我可以在文字中更好地描述我正在excel中查找的功能。列内的内容如图所示？这对于所示的示例是可以实现的，但是当最多可以说30个组和多个子组类型时，我想知道excel是否可以自动检测并通过列表进行分组，如图所示。 >

解决方案

你可以使用条件格式化获得类似的结果。选择整个表格并创建一个新的条件格式规则并选择公式并输入= A1 = A2将格式字体设置为白色（我使用非常浅灰色显示数据仍然存在）

要获得边框，请再次执行相同操作，此时输入公式= A1&A2，使顶部边框变黑。

它不完全一样，但是很接近。

I think the image attached describes better than I can in words the functionality I am trying to locate within excel.

Is there a way to auto group based on the contents within the columns as shown? This is achievable for the example shown, but when there are up to say 30 Groups and many sub group types, I am wondering whether excel can auto-detect and work its way through the list, grouping as shown as it goes.

解决方案

You can get a similar result using conditional formatting. select the whole table and create a new conditional format rule and choose formula and enter =A1=A2 set the format font to white (I've used very light grey to show that the data is still there)

To get the borders, do the same again and this time enter the formula =A1<>A2 and make the top border black.

It's not exactly the same as yours but it's close.

这篇关于自动分组/合并Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！