Formula to extract more than one data from the same client

Navigation
0

formula to collect more than one data from the same client, and this is placed in the first name found of the client, (it is worth mentioning that the base is arranged in alphabetical order) the base is as follows: 

ID                     nombre              facturas
A02032018000    DISTRIBUIDORA DE CARNES       3095
A02032018000    DISTRIBUIDORA DE CARNES       3803
A28022018M00    DISTRIBUIDORA DE CARNES       1520

and the process that I require is the following: 

ID                     nombre              facturas   Formula / recopilacion
A02032018000    DISTRIBUIDORA DE CARNES       3095    3095, 3803, 1520
A02032018000    DISTRIBUIDORA DE CARNES       3803
A28022018M00    DISTRIBUIDORA DE CARNES       1520

I have a single cell left with all the invoices of the same client instead of selecting the cell copy and paste in the same cell, I want everything to be in one cell.

    
asked by Emmanuel Herrada 14.03.2018 в 19:59
source

1 answer

1

There are two ways to solve this if you have Excel 2016 you can use the formula UNIRCADENAS

{=UNIRCADENAS(", ",1,SI($B$2:$B$4=E2,$C$2:$C$4,""))}

To activate the formula as an array use Ctrl + Shift + Enter .

Another option is to use Power Query , here link where I make a brief description of the new tools of microsoft for business intelligence.

In the query editor follow these steps to group your data:

Here is a detailed tutorial I did some time ago on this particular topic.

    
answered by 15.03.2018 в 19:34
Delete textbox wpf MVVM Spring Boot I do not run a Controller when I put it in a different package