1 row 2 column 3 column 4
11 12 13 14
534 22 11 44
11 455 556 33
22
13 11
123 44 444
Then has random sheet2 table to several groups of data
Column 1 column 2 columns and three columns 4 statistics in SHEET1 exist three duplicate data with a few lines of each row
23 33 22 11 2 rows [judgment after arrival 2 rows of data there are three duplicates, red mark]
3 rows [judgment after arrival 3 rows of data with three duplicates, blue note]
Could you tell me how to write? Formula, or function of the
CodePudding user response:
Write their own function? Is too high, I generally use Anytxt or docfetcher search out, then find out, manually change,