→ freePrester: C1=ROWS(UNIQUE($A$1:A1))&"-"&COUNTIFS($A$1:A1,A1 05/16 11:47
→ freePrester: C1=ROWS(UNIQUE($A$1:A1))&"-"&COUNTIFS($A$1:A1,A1) 05/16 11:48
→ freePrester: 假設 A 行是有排序的前提下 05/16 11:49
→ lgtenos: 感謝 05/16 12:33
→ freePrester: 不排序的話 C1=MATCH(A1,UNIQUE(A:A),FALSE)&"-"&C 05/16 13:40
→ freePrester: OUNTIF($A$1:A1,A1) 05/16 13:40
推 cutekid: 學習了(Y) 05/17 08:46