Hello Mr Excel
many times I have to solve this type of list
I need to multiply each cell from column A based based on the number in column B, then add count number from each unique name
how to do this job faster instead of doing it manually?
thank you very much
many times I have to solve this type of list
I need to multiply each cell from column A based based on the number in column B, then add count number from each unique name
how to do this job faster instead of doing it manually?
thank you very much
Book1.xlsx | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | no | name | ...to duplicate | …to count | >>> | no | name | duplicate | count | ||
2 | 1 | José Luis | 2 | 1 | José Luis | 2 | 1 | ||||
3 | 2 | Juan | 5 | 1 | José Luis | 2 | 2 | ||||
4 | 3 | Miguel Ángel | 3 | 2 | Juan | 5 | 1 | ||||
5 | 4 | José | 1 | 2 | Juan | 5 | 2 | ||||
6 | 5 | Francisco | 7 | 2 | Juan | 5 | 3 | ||||
7 | 6 | Jesús | 3 | 2 | Juan | 5 | 4 | ||||
8 | 7 | Antonio | 4 | 2 | Juan | 5 | 5 | ||||
9 | 8 | Alejandro | 2 | 3 | Miguel Ángel | 3 | 1 | ||||
10 | 9 | Pedro | 3 | 3 | Miguel Ángel | 3 | 2 | ||||
11 | 10 | Juan Carlos | 4 | 3 | Miguel Ángel | 3 | 3 | ||||
12 | 11 | … | 4 | José | 1 | 1 | |||||
13 | 5 | Francisco | 7 | 1 | |||||||
14 | 5 | Francisco | 7 | 2 | |||||||
15 | 5 | Francisco | 7 | 3 | |||||||
16 | 5 | Francisco | 7 | 4 | |||||||
17 | 5 | Francisco | 7 | 5 | |||||||
18 | 5 | Francisco | 7 | 6 | |||||||
19 | 5 | Francisco | 7 | 7 | |||||||
20 | 6 | Jesús | 3 | 1 | |||||||
21 | 6 | Jesús | 3 | 2 | |||||||
22 | 6 | Jesús | 3 | 3 | |||||||
23 | 7 | Antonio | 4 | 1 | |||||||
24 | 7 | Antonio | 4 | 2 | |||||||
25 | 7 | Antonio | 4 | 3 | |||||||
26 | 7 | Antonio | 4 | 4 | |||||||
27 | 8 | Alejandro | 2 | 1 | |||||||
28 | 8 | Alejandro | 2 | 2 | |||||||
29 | 9 | Pedro | 3 | 1 | |||||||
30 | 9 | Pedro | 3 | 2 | |||||||
31 | 9 | Pedro | 3 | 3 | |||||||
32 | 10 | Juan Carlos | 4 | 1 | |||||||
33 | 10 | Juan Carlos | 4 | 2 | |||||||
34 | 10 | Juan Carlos | 4 | 3 | |||||||
35 | 10 | Juan Carlos | 4 | 4 | |||||||
36 | 11 | … | |||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I2:I35 | I2 | =COUNTIFS($G$2:G2,G2) |