Lacan
Active Member
- Joined
- Oct 5, 2016
- Messages
- 260
- Office Version
- 365
- Platform
- Windows
Hello Guys, 
Have this "ORIGINAL" table as a result of a filter function.
Despite the number of the rows below (because maybe have to adjust them in the future) how is the formula to get the "END RESULTS" example?
All the help is welcome!!!

Thank you very much!!!


Have this "ORIGINAL" table as a result of a filter function.
Despite the number of the rows below (because maybe have to adjust them in the future) how is the formula to get the "END RESULTS" example?
All the help is welcome!!!


Thank you very much!!!


Fórmula Principal para o Ficheiro VDF.xlsm | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | ||||||||||||
2 | ||||||||||||
3 | ORIGINAL | END RESULTS | ||||||||||
4 | CUSTOMER | POTENCIAL | ||||||||||
5 | APPLE | D10 | APPLE | D10 | SANTA | D05 | ||||||
6 | XPTO | D08 | XPTO | D08 | CCM | D04 | ||||||
7 | AUCHAN | D06 | AUCHAN | D06 | RDAM | D03 | ||||||
8 | WORTEN | D07 | WORTEN | D07 | GOUSE | D02 | ||||||
9 | SANTA | D05 | ||||||||||
10 | CCM | D04 | ||||||||||
11 | RDAM | D03 | ||||||||||
12 | GOUSE | D02 | ||||||||||
13 | ||||||||||||
14 | ||||||||||||
29-09-2024 |