Table 2, Table 1 excel less than a few people to find out how to use function

Users questions: Table 2, Table 1 excel less than a few people to find out how to use function calls for functions to be explained in detail the various parameters Shousheng, file transfer wrong, re-ask questions, the first back in to the sub.
Experts answer: try sorting method, I often use. 1, the new sheet (assuming the name Table 3) 2, Table 1, table 2 of the serial number and name of the column copied to the new form set out 3, Select Table III copied from the table a name, serial number allowed to sort the column 4, select Table III replication by the Table II over the name, serial number of the column allowed to Rank 5, checklists, ranking third in the had of the two names
  • This information provided by the users.Thanks!