我有一张类似的 Sheet1,它每天都会更新:
+---------+----------+-----------+
| company | date | total_log |
+---------+----------+-----------+
| A | 20180910 | 32987 |
| A | 20180902 | 426 |
| A | 20180905 | 42135 |
| B | 20180906 | 64743 |
| B | 20180910 | 235647 |
| B | 20180902 | 2346 |
| C | 20180804 | 67536 |
| C | 20180910 | 34536 |
| C | 20180510 | 235356 |
+---------+----------+-----------+
如何根据 Sheet1 更新 Sheet2 上的日期和 total_log 列,并使用 Excel 自动获取每个公司的最大日期
+---------+------+-----------+
| company | date | total_log |
+---------+------+-----------+
| A | | |
| B | | |
| C | | |
+---------+------+-----------+