• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. luis_marques

    Multiply and Sum each other columns

    Excel Wizard, thanks for both solutions in the Sample.xlsx and also for Power Query code (straightforward approach). Best Regards.
  2. luis_marques

    Multiply and Sum each other columns

    Many thanks, Bosco.
  3. luis_marques

    Multiply and Sum each other columns

    Perfect. Many thanks for your help.
  4. luis_marques

    Multiply and Sum each other columns

    Thanks. That is what i need. How do i inform pivot table to split data in the AT column?
  5. luis_marques

    Multiply and Sum each other columns

    Hi, Our ecommerce is hosted in a cloud plataform. The only format they offer to export order data is attached. I kept just 3 original rows for security reason. With this file in hand i use the macro in the SAMPLE.xlsx to split single cell data (Column AT) in several columns in a different...
  6. luis_marques

    Multiply and Sum each other columns

    P45cal, it is a weird format. More weird is that those columns are extracted from just one cell. I use a macro to extract information. See attached. I would appreciate a lot if you could help to solve this.
  7. luis_marques

    Multiply and Sum each other columns

    Hi. Any help? Please
  8. luis_marques

    Multiply and Sum each other columns

    Hi, I have a sheet where each row is an order. Each order may have since 1 product until n products. The export file of this data order present a pattern of data that repeats every each 14 columns for each product Those 14 columns are data of just 1 product of 1 order. I need to multiply 2...
  9. luis_marques

    Format text removing spaces and replacing for hyphens

    Hi, I need to replace old URLs for new ones, but i need capture text from de field called NOME (Name in english). For instance in the column A: NOME Roupa PJ Masks - Blusa PJ Masks - Corujita - Cinza - Malwee Then i need to format like this in a new column: NEW URL...
  10. luis_marques

    Extract data from single cell to multiple columns

    Thanks. It is a very interesting approach to display such data.
  11. luis_marques

    Extract data from single cell to multiple columns

    Perfect. It worked very well. Many thanks.
  12. luis_marques

    Extract data from single cell to multiple columns

    I attached a sample. Column A, several lines with information that need to be extracted right to next column like in the yellow cells in the sample.
  13. luis_marques

    Extract data from single cell to multiple columns

    Many thanks. I didn´t notice. Sorry. Is possible to make this VBA operation for many lines at same time and each line extracted to start at the right next column of original ones?
  14. luis_marques

    Extract data from single cell to multiple columns

    Thanks Bosco. How could be using VBA?
  15. luis_marques

    Extract data from single cell to multiple columns

    Yes, indeed i missed. I corrected, but extracted just one set of information. The second set or more the formula doesn´t extract.
  16. luis_marques

    Extract data from single cell to multiple columns

    Thanks Shrivallabha! I tried to implement, but i don't know whats was wrong. That is a sample of my database. In the yellow cell i typed your formula. Could you verify, please?
  17. luis_marques

    Extract data from single cell to multiple columns

    Bosco Hi, it works very well if i have two until three products (codes), but it doesn´t work if i have more than 3. What could be possible to deal with such problem? Every new product is recognized when you see: },{ One example of set of products in just a single cell...
  18. luis_marques

    Copy data from a sheet source to several created new sheets

    Hi, is that ok, or you need anything more detailed?
  19. luis_marques

    Copy data from a sheet source to several created new sheets

    I posted a sample of sheet. Thanks for your assessment.
  20. luis_marques

    Copy data from a sheet source to several created new sheets

    Hi, I made a drawing to explain my need. I have a sheet in woorkbook that is a source where each row is a order. New orders are always in the new rows that are being created and going down. I need to copy a model sheet in the wookbok for each order created. Then fill data from the source...
  21. luis_marques

    Extract data from single cell to multiple columns

    Hi , I need a formula to read a single cell and extract data to multiple columns like the attached example. Some criteria: 1. Data between comma and colon 2. Remove quotes 3. Remove brackets 4. Remove braces
  22. luis_marques

    Match a value from one list to another and extract a third value

    Hi, I posted the table in order to make clear. Please, i need to match a zipcode in one column in another full column. Then i need to extract the risk index from a third column to matched zipcode. Thanks in advance.
Back
Top