When you open a CSV in Excel, Japanese headings and names appear as unreadable characters. In such cases, stop before you fix ...
When I entered the product code "00123" into Excel, it became "123". Even if I add the zeros and re-enter it, they disappear ...
Once you start using multiple criteria, MAXIFS and MINIFS make light work of questions buried in your data.