Dec 15 2021 02:32 AM
@Riny_van_Eekelen Então, essa formula ela concatena eu preciso que liste uma lista embaixo da outra...
Dec 15 2021 08:26 AM
@Guilherme_Garibaldi Not sure I follow. Thought I answered your question. If not, please upload a sample file with the type of data you have and how you want to concatenate it.
Dec 15 2021 12:48 PM
No caso função "único" iria trazer os nomes que estão repetidor com 1 nome só....fiz um exemplo para você entrender melhor.
Dec 15 2021 11:02 PM
@Guilherme_Garibaldi If this is a one time task, I would not go for VBA or a complicated formula. In stead, copy both lists into one (Step 1) and then use "Remove Duplicates" from the Data Ribbon. See picture below and/or the attached file.
Dec 16 2021 03:21 AM
Dec 16 2021 04:17 AM
Dec 16 2021 04:33 AM
@Guilherme_Garibaldi Don't understand Spanish and the on-line translator isn't very well. That may cause my lack of understanding. But, I have re-read your posts and with some creativity, I perhaps get it now. Would you consider Power Query?
Have your two lists of Sellers. Connect to each of them with PQ, Append and Remove duplicates. Basically the same as my initial suggestion but it's automated. Change you lists, press Refresh and the report with unique sellers in one column will be updated instantly.
Dec 16 2021 05:17 AM
Dec 16 2021 05:21 AM
@Guilherme_Garibaldi The link below would be a good start.