How to find same rows which have same internal in MS Excel? -

How to find same rows which have same internal in MS Excel? -

in excel have 3 columns:

sender mesagetype internal iekp disp.np 502940 iekp disp.np 502901 iekp disp.np 502919 iekp disp.np 503025 ...

number of rows have 10,000. now, want find 1 internal number have 2 diffrent sender (column).

any thought how solve this?

you can create pivot table internal column row label, sender column label , set values count(internal).

if need internal , senders no (number of different senders), can extract them separately using formulas.

excel excel-formula