subtotalatom
New Member
- Joined
- Feb 3, 2020
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
Hello
=TEXTJOIN(",",TRUE,UNIQUE(IF(D9=D9:D12,C9:C12,"")))
i am trying create a formula that returns the value of the highest sales person to one cell based on the highest percentage. however what i need it to do is return the mulitple names to the same cell if there are multiple sales persons with the same highest percentage.
i have managed to use the formula above to return the names of the multiple names to the same cell. the issue im having is this just returns duplicates so it doesnt matter if sales person A has 80%. it will return sales person b and c name to the cell because they have same value of lets say 50%
anyone have any idea?
=TEXTJOIN(",",TRUE,UNIQUE(IF(D9=D9:D12,C9:C12,"")))
i am trying create a formula that returns the value of the highest sales person to one cell based on the highest percentage. however what i need it to do is return the mulitple names to the same cell if there are multiple sales persons with the same highest percentage.
i have managed to use the formula above to return the names of the multiple names to the same cell. the issue im having is this just returns duplicates so it doesnt matter if sales person A has 80%. it will return sales person b and c name to the cell because they have same value of lets say 50%
anyone have any idea?