#excel

IP地址Excel排序

公式如下 =SUMPRODUCT(MID(SUBSTITUTE(A2,".",REPT(" ",20)),{1,21,41,61},20)*10^{9,6,3, ...