Hello Guys,
I am making an excel Database for my newspaper.
I have huge database of Articles and their Authors and Regions that the article is talking about. I want to make an sheet for statistics. For each Author how many times his name is listed in specific column, also the same idea for the Regions.
I was doing it manually, but Since this database is huge one, i can't do it manual.
See Example
I Need to make this stats Chart or Table to be filled automatically, like if i listed another article for the Author A, automaticaly the Author 'a' Table +1
Thanks
I am making an excel Database for my newspaper.
I have huge database of Articles and their Authors and Regions that the article is talking about. I want to make an sheet for statistics. For each Author how many times his name is listed in specific column, also the same idea for the Regions.
I was doing it manually, but Since this database is huge one, i can't do it manual.
See Example
Thanks
Last edited: