Hello,
I want a formula to give me the names of the agents of tabela 1 in vendedor column of mapa1, Excluding the blanks. but it is not giving me anything does somebody have any idea? I am stuck on this for 1hour. Thanks a lot!
=IFERROR(INDEX(Table1[Agent],SMALL(IF(NOT(ISBLANK(Table1[Agent])),ROW(tabela!D:D),""),ROW(tabela!D1))),"")
David
Last edited by rafamaniac; 01-09-2020 at 10:27 AM.
Can someone help me please? it's probably obvious but i am not very good at excel.
Here is what you need.
Uploading an attachment will assist Forum Members in finding the correct Solution for you. Create a dummy worksheet if necessary, add your start data and show where / what your expected results should be. TO ADD A FILE:
Go to 'Advanced. click on 'Manage Attachments. Select 'Browse & Choose your file, Select 'Upload and then close the Attachment window.
Thank you a lot BlindAlley
Glad to be of help. Let me know if you need anything else.
If this works can you use the thread tools to mark the thread as solved {and add to my rep}
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks