人生若精通excel，何至秋风悲画屏

[TIFF]

汲取上次教训。楼主，打10万CFC币过来，我告诉你一个简单的，不用那些复杂公式。

少啰嗦，知道就把答案贴出来，真有效再说。

 

[笨妈笨爸]

少啰嗦，知道就把答案贴出来，真有效再说。

我汲取教训了，你没有。上次那个你要理解为什么可以那样做了，这次也不用来问人了。哎，知识是油价。

 

[atla]

我汲取教训了，你没有。上次那个你要理解为什么可以那样做了，这次也不用来问人了。哎，知识是油价。

你怎么能对踢飞介样 ？！！！！

 

[笨妈笨爸]

你怎么能对踢飞介样 ？！！！！

浏览附件385323

别吓我。吓跑了，你踢飞哥永远没答案了，到时候他会扁你的。

 

[atla]

别吓我。吓跑了，你踢飞哥永远没答案了，到时候他会扁你的。

别跑，站住，踢飞是美女，很美的那种，你快回心转意吧，她要生气拉，，，，，

 

[TIFF]

我汲取教训了，你没有。上次那个你要理解为什么可以那样做了，这次也不用来问人了。哎，知识是油价。

上次那个什么？我就没记得你告诉过我什么有用的油价知识。

 

[笨妈笨爸]

上次那个什么？我就没记得你告诉过我什么有用的油价知识。

那好吧，再二一次。

 

[笨妈笨爸]

 

[笨妈笨爸]

1. Think about the three bright color columns are from your original table.
2. Insert two columns to the right of the blue column.
3. Insert one row to the top.
4. Put this formula in C2: =B2+C1*($A2=$A1), drag to the last CFC row.
5. Put this in D2: =($A2 <>$A3)*(C2>0), then drag to the last CFC row.
6. Leave the bottom black row empty and summarize the column D in the next row (the 5 row).
7. Go to the blue 5 cell, make it equal to the 5 row at column D.
8. Now you copy column C and D to columns F and G.
9. Repeat the 7th step to make those cells with '2'.
10. Now hide C, D, F, G together with the two black rows. You will see the results you wanted.
11. You can change the numbers freely to see how the bottom numbers 5 and 2 will change accordingly.
12. Adding rows to the table might cause you a little trouble, hopefully you can fix it by yourself.
13. Important step: Give your CFC cash to me if you do think this is helpful.

 

[CCL]

楼主，要不试试用“advance filter" ?

不过这样得Item1 和Item2 分开做

把Region 和 Item 1 两列拷到一个单独的表里， 用advance filter 把 Region 列的 unique value 放到新的两列，这样你就可以得到Item1有多少个region了。同样再弄Item2 的

 

[TIFF]

1. Think about the three bright color columns are from your original table.
2. Insert two columns to the right of the blue column.
3. Insert one row to the top.
4. Put this formula in C2: =B2+C1*($A2=$A1), drag to the last CFC row.
5. Put this in D2: =($A2 <>$A3)*(C2>0), then drag to the last CFC row.
6. Leave the bottom black row empty and summarize the column D in the next row (the 5 row).
7. Go to the blue 5 cell, make it equal to the 5 row at column D.
8. Now you copy column C and D to columns F and G.
9. Repeat the 7th step to make those cells with '2'.
10. Now hide C, D, F, G together with the two black rows. You will see the results you wanted.
11. You can change the numbers freely to see how the bottom numbers 5 and 2 will change accordingly.
12. Adding rows to the table might cause you a little trouble, hopefully you can fix it by yourself.
13. Important step: Give your CFC cash to me if you do think this is helpful.

看在你打这么多字的份上，先把钱给你。我现在看电视，不想试excel，明天再试。如果不行你把钱还我哦。

 

[笨妈笨爸]

看在你打这么多字的份上，先把钱给你。我现在看电视，不想试excel，明天再试。如果不行你把钱还我哦。

Oh, Yeah!

 

[mayo_wang]

看在你打这么多字的份上，先把钱给你。我现在看电视，不想试excel，明天再试。如果不行你把钱还我哦。

那我的报酬呢？

 

[TIFF]

Oh, Yeah!

你的钱很快要比我的多了。

 

[TIFF]

那我的报酬呢？

你还需要钱啊？帮助同学是你应该做的事哈。