abdelfattah
Well-known Member
- Joined
- May 3, 2019
- Messages
- 1,429
- Office Version
- 2019
- 2010
- Platform
- Windows
hello
i try use this function to get the values in column a to col b without any duplicated
this is what i got in col b
the right result
i try use this function to get the values in column a to col b without any duplicated
this is what i got in col b
Microsoft Excel .xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | duplicted | not duplicated | ||
2 | 10 | 9 | ||
3 | 20 | 8 | ||
4 | 20 | 8 | ||
5 | 10 | 9 | ||
6 | 52 | 6 | ||
7 | 3 | 12 | ||
8 | 2 | 13 | ||
9 | 5 | 11 | ||
10 | 88 | 4 | ||
11 | 90 | 2 | ||
12 | 100 | 2 | ||
13 | 88 | 5 | ||
14 | 90 | 2 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2:B14 | B2 | =1+RANK.EQ(A2,$A$2:$A$14)+COUNTIF($A$2:A2,A3)-1 |
the right result
Microsoft Excel .xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | duplicted | not duplicated | ||
2 | 10 | 2 | ||
3 | 20 | 3 | ||
4 | 20 | 5 | ||
5 | 10 | 10 | ||
6 | 52 | 20 | ||
7 | 3 | 52 | ||
8 | 2 | 88 | ||
9 | 5 | 90 | ||
10 | 88 | 100 | ||
11 | 90 | |||
12 | 100 | |||
13 | 88 | |||
14 | 90 | |||
Sheet1 |