extract data

[mlaxx]

hy. i want to extract for each domain name the adress mail, departament and position based on maxim value from score and number of sources. how i cand do that?

[oeldere]

I made a table of the data.

After that I added a helpcolumn in column G
G2 = b2&c2 and drag down.

After that a pivot table to find the max values.

After that the expected results with the formula index / match.

See the attached file.