I am counting the number of times the same director has served on a board, irrespective of id and year. I need just counting the same name if it appears in a column from a specific fixed start time, like from 2007.
I use this formula in excel =COUNTIF($C$2:C3,C3) to it. But due to thousands and thousands of observation excel is unable to do it or its very slow.
| id | year | name | count |
| 4 | 2007 | Mao Baodi | 1 |
| 4 | 2007 | Xiao Ziren | 1 |
| 4 | 2007 | Pan Lingman | 1 |
| 4 | 2008 | Pan Lingman | 2 |
| 4 | 2008 | Mao Baodi | 2 |
| 4 | 2008 | Xiao Ziren | 2 |
| 4 | 2009 | Mao Baodi | 3 |
| 4 | 2009 | Pan Lingman | 3 |
| 4 | 2009 | Li Liangzhi | 1 |
| 4 | 2009 | Pan Xiuling | 1 |
| 4 | 2009 | Xiao Ziren | 3 |
| 4 | 2009 | Wang Qi | 1 |
| 4 | 2010 | Pan Xiuling | 2 |
| 4 | 2010 | Li Liangzhi | 2 |
| 4 | 2010 | Wang Qi | 2 |
| 4 | 2011 | Wang Qi | 3 |
| 4 | 2011 | Li Liangzhi | 3 |
| 4 | 2011 | Pan Xiuling | 3 |
| 4 | 2012 | Li Liangzhi | 4 |
| 4 | 2012 | Wang Qi | 4 |
| 4 | 2012 | Pan Xiuling | 4 |
0 Response to Counting the occurrence of “directors name”
Post a Comment