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

[TIFF]

how?

I put your formula at the end of item1 column, change the data source to include from #3 to 8, the return value is 4. I don't know how, it's just the way it is.

 

[idolou]

I put your formula at the end of item1 column, change the data source to include from #3 to 8, the return value is 4. I don't know how, it's just the way it is.

你别变啊， 笨死了。

 

[TIFF]

你别变啊， 笨死了。

I cannot do the things that I don't understand. Tell me what's that A1:A30000 for?

By the way, when I saw the first function you provided, I knew you did not get the question.

 

[冷笑9声]

I cannot do the things that I don't understand. Tell me what's that A1:A30000 for?

那啥，无限行的范围。。

 

[mayo_wang]

Then I suggest you to revise your 1st post to be more clear then other experts can solve your problem quickly.
I do not think I can solve it just using simple functions in Excel.
I may have to use VBA programming in Excel or to move the data/table into Access and use SQL to solve it.
Either way you will not like, so just wait for other experts.

 

[idolou]

I cannot do the things that I don't understand. Tell me what's that A1:A30000 for?

that is just a range. Anyhow, the answer is there. 不是你笨， 是我笨。

 

[TIFF]

Then I suggest you to revise your 1st post to be more clear then other experts can solve your problem quickly.
I do not think I can solve it just using simple functions in Excel.
I may have to use VBA programming in Excel or to move the data/table into Access and use SQL to solve it.
Either way you will not like, so just wait for other experts.

You understood the question.

If simple functions cannot solve it, I will give up trying and seek other alternatives. Thank you!

 

[TIFF]

that is just a range. Anyhow, the answer is there. 不是你笨， 是我笨。

Yes, I know it's a range, and I changed the range to fit my data source, should I not do that?

 

[CatLostHerFish]

先做一次subtotal，在小计的基础上，做count or filter 可得

踢飞飞，看看这个，可行的。

 

[TIFF]

先做一次subtotal，在小计的基础上，做count or filter 可得

踢飞飞，看看这个，可行的。

谢谢，我试试。

 

[mayo_wang]

I tested idolou's way, I think it does not work.

 

[idolou]

I tested idolou's way, I think it does not work.

浏览附件385285

笨死， 把B换回A

 

[TIFF]

笨死， 把B换回A

But it needed to count on column B, not A. I knew you did not understand the question.

 

[mayo_wang]

笨死， 把B换回A

老大,同苯，你没有看懂题。 不只是统计有多少个region, Tiff want the output as

 

[TIFF]

老大,同苯，你没有看懂题。 不只是统计有多少个region, Tiff want the output as
浏览附件385286

You are so smart! 没有你谁理解我？泪汪汪的，以后跟你混了，麻油王大哥。