请教一下人均985的泥潭dalao,excel公式这里怎么跨行选取不连续数据

clpx-avatar

clpx

2020-06-02T03:55:58+00:00

[img]https://img.nga.178.com/attachments/mon_202006/02/-7Q5-1mh9ZbT3cSzh-a3.jpg.medium.jpg[/img]就是像这里,我想取一个rank函数,但是由于分类汇总我多出了一些不要的行,我只想要取H3到H5,H7到H10,H12到H14,该怎么操作[s:ac:瞎]
[s:ac:凌乱]百度不到求助无果,万能的泥潭dalao救救我
JankZTempo-avatar

JankZTempo

Ctrl复选不行吗?
clpx-avatar

clpx

[quote][pid=426754869,22004737,1]Reply[/pid] Post by [uid=38637142]我不在的星期天[/uid] (2020-06-02 12:00):

Ctrl复选不行吗?[/quote]不行[s:ac:凌乱][s:ac:凌乱][img]https://img.nga.178.com/attachments/mon_202006/02/-7Q5-if5oZaT3cSyh-9r.jpg.medium.jpg[/img]