You want to compare two lists, but "ABC" (full-width), "ABC" (half-width), and "ABC(ver2)" remain as different names. There ...
Stop opening Excel to work out a discount.
A built-in Excel customization and a tiny macro give table names the attention they deserve.
When you want to aggregate sales by "person in charge" or "product" in Excel, do you find yourself searching for the SUMIFS ...