|
A | B | C | D | E
- 数据1 数据2 数据3 辅助公式列 筛选列
- 1 A 苹果 =A2&B2&C2 =COUNTIF($D$2:D2,A2&B2&C2)
- 2 A 苹果 =A3&B3&C3 =COUNTIF($D$2:D3,D3)
- 3 B 香蕉 =A4&B4&C4 =COUNTIF($D$2:D4,D4)
- 3 B 香蕉 =A5&B5&C5 =COUNTIF($D$2:D5,D5)
- 2 A 苹果 =A6&B6&C6 =COUNTIF($D$2:D6,D6)
- 1 B 香蕉 =A7&B7&C7 =COUNTIF($D$2:D7,D7)
- 3 B 香蕉 =A8&B8&C8 =COUNTIF($D$2:D8,D8)
|
|