jamiguel77
Active Member
- Joined
- Feb 14, 2006
- Messages
- 378
- Office Version
- 2016
- 2010
- 2007
- Platform
- Windows
- Web
HI
I have this data, the idea is to detect on column A, which data is repeated, triplicated, quadrupled.... and generate 1 single row.
the expected result is:
is possible with formula? or need VBA?
thanks
I have this data, the idea is to detect on column A, which data is repeated, triplicated, quadrupled.... and generate 1 single row.
LCCH MD ejemplo bmw Pedimentos de importacion v1.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | ||||||
2 | Invoice1 | Invoice Sales | GUID | Qty | ||
3 | 5045 | A7859 | 9609AB33-46E3-493B-B397-136BFFFC2004 | 10 | ||
4 | 5089 | A3242 | E26D032C-870F-48D5-AEB9-EFD2797C0425 | 5 | ||
5 | 5089 | A3278 | A612ED53-5DF8-4EDB-AA76-B02615D630CC | 18 | ||
Hoja1 |
the expected result is:
LCCH MD ejemplo bmw Pedimentos de importacion v1.xlsx | |||||
---|---|---|---|---|---|
E | F | G | |||
1 | EXPECTED RESULT | ||||
2 | Invoice Sales | GUID | Qty | ||
3 | A7859 | 9609AB33-46E3-493B-B397-136BFFFC2004 | 10 | ||
4 | A3242, A3278 | E26D032C-870F-48D5-AEB9-EFD2797C0425, A612ED53-5DF8-4EDB-AA76-B02615D630CC | 5,18 | ||
5 | |||||
Hoja1 |
is possible with formula? or need VBA?
thanks