I attacched a sample.
The problem is that the data is formatted like this
I need:![]()
A B C User A sent 1 recived 5 User B sent 1 recived 5 User C sent 2 recived 3 User D sent 7 recived 2
Max Sent = User D
Max Recived = User A,User B (or if is too difficult just the first occurence)
I tried using LOOKUP, MATCH, INDEX MAX with no results
Thanx
Bookmarks