Forum Discussion
Doppelte Werte in Tabelle zählen
Hallo,
ich habe eine Tabelle welche Anrufe auflistet. In einer Spalte stehen die Nummer, welche angerufen haben. Hier möchte ich zählen wie oft Nummern mehr als einmal und wie oft angerufen haben. Gibt es hier eine Formel?
Vielen Dank!
5 Replies
Hello DBraun,
Here is one possibility. You could create a drop-down list of all of the numbers. See how here:
https://contextures.com/xlDataVal01.html
Then, let's say your list of numbers is in column A and your drop-down list is in cell C1. In cell C2 you could put the following formula:
=COUNTIF(A:A,C1)
Simply change the number in the drop-down list and see how many times it appears in cell C2.
Try a Pivot Table on column A. Set the phone number as the column header and a counter of phone numbers as the value.
Don't know the menu options in German, but in the English version you find pivot tables under DATA / Summarise with Pivot Table. From there, follow the instructions. I trust you can get it to work. Have a look at the attached example in case you aren't familiar with Pivot Tables. Just add/delete or overwrite phone numbers and refresh the pivot table. The frequency of calls to each number will show instantly. Just make sure that the column header in the call listing ("Call_To:" in my example) doesn't change.
