1 Name against the id

[KC3]

Hi,

Please help me to get 1 name and number against the Email.

As I have 5-6 names against 1 email id but i need only 1 name what formula I will apply, please help me with that

[hic · Accepted solution]

Look at MinString() or FirstSortedValue()