Requirement description: according to A column (name), the B column (tag) collect information in column C (summary), name the first appearance of the summary for all labels, following A row shows empty,
Problem: baidu to a kind of method, namely in the C2 column input formula:=the IF (A2=A1, "", PHONETIC (an INDIRECT (" B" & amp; The ROW () & amp;" B: "& amp; The ROW () + COUNTIF (A: A, A2) - 1)))
Encountered a problem, the formula can run on some computer, some computer is running on, display an error, because the formula is used to colleagues, his computer can't run, continue to baidu, said some PHONETIC this function is Japanese, Excel input method can't use English, but also not line, after changed really can't find the reason, have come to for the great god, thank you,
