UC知道EXCEL问题,C列有50以内的数据,请高手帮忙分开.
来源：百度知道 编辑：UC知道 时间：2024/06/11 14:38:25
C列的数据是1-------------49.
我想分成:
1,2,7,8,12,13,18,19,23,24,29,30,34,35,40,45,46这组在D列用1代替.
3,4,9,10,14,15,20,25,26,31.36.37.41.42.47.48.这组在D列用2代替.
5,6,11,16,17,21,22,27,28,32,33,38,39,43,44,49这组在D列用3代替.
C列的数据:1,2,7,8,12,13,18,19,23,24,29,30,34,35,40,45,46.
在D列把这组数据变成1.
3,4,9,10,14,15,20,25,26,31.36.37.41.42.47.48.这组在D列边成2.
5,6,11,16,17,21,22,27,28,32,33,38,39,43,44,49这组D列变成3
那样就方便查找了.
我想分成:
1,2,7,8,12,13,18,19,23,24,29,30,34,35,40,45,46这组在D列用1代替.
3,4,9,10,14,15,20,25,26,31.36.37.41.42.47.48.这组在D列用2代替.
5,6,11,16,17,21,22,27,28,32,33,38,39,43,44,49这组在D列用3代替.
C列的数据:1,2,7,8,12,13,18,19,23,24,29,30,34,35,40,45,46.
在D列把这组数据变成1.
3,4,9,10,14,15,20,25,26,31.36.37.41.42.47.48.这组在D列边成2.
5,6,11,16,17,21,22,27,28,32,33,38,39,43,44,49这组D列变成3
那样就方便查找了.
在D1单元格输入公式:
=OR((C1={1,2,7,8,12,13,18,19,23,24,29,30,34,35,40,45,46}))*1+OR((C1={3,4,9,10,14,15,20,25,26,31,36,37,41,42,47,48}))*2+OR((C1={5,6,11,16,17,21,22,27,28,32,33,38,39,43,44,49}))*3
将公式向下复制。
怎么都是D列呀，不明白。