我导出我的信用卡详细信息为csv，然后使用文本到列，让他们以可读格式表，如下图所示。
我如何查询/整理这些年来我在特定商店总共花了多少钱（如果商家相同，只需添加金额值），这样看起来就像这样
编辑：添加文本数据。注意！在示例数据中，只有K市场Haikko作为商家两次
Date (YYYY-MM-DD as UTC),Merchant,Txn Amount (Funding Card),Txn Currency (Funding Card),Txn Amount (Foreign Spend),Txn Currency (Foreign Spend),Card Name,Card Last 4 Digits,Type,Category,Notes
2023-01-29,T:mi Fahri Lati,-24.00,EUR,,,Visa Credit,0000,,Eating Out,
2023-01-29,K-citymarket Porvoo,-94.06,EUR,,,Visa Credit,000,,Groceries,
2023-01-29,Subway,-7.10,EUR,,,Visa Credit,0000,,Eating Out,
2023-01-28,K-market Haikko,-9.08,EUR,,,Visa Credit,0000,,Groceries,
2023-01-28,Sadama Turg,-24.26,EUR,,,Visa Credit,0000,,Eating Out,
2023-01-28,Bolt.eu/o/2301281350,-5.20,EUR,,,Visa Credit,0000,,Travel,
2023-01-28,Sports Direct,-9.00,EUR,,,Visa Credit,0000,,Shopping,
2023-01-28,R-kiosk Ulemiste Kesku,-1.55,EUR,,,Mastercard Credit,0000,,Shopping,
2023-01-28,House Ulemiste Keskus,-21.23,EUR,,,Visa Credit,0000,,Shopping,
2023-01-28,Bolt.eu,-5.00,EUR,,,Visa Credit,0000,,Travel,
2023-01-28,"Viking Line, Viking Xp",-57.20,EUR,,,Visa Credit,0000,,Travel,
2023-01-28,K-market Haikko,-6.00,EUR,,,Visa Credit,0000,,Groceries,
2023-01-27,Vikingline.fi,-356.40,EUR,,,Visa Credit,0000,,Travel,
2023-01-27,S-market Nasi,-19.52,EUR,,,Visa Credit,0000,,Groceries,
2023-01-26,Foodora Finland,-15.50,EUR,,,Visa Credit,0000,,Eating Out,
2023-01-25,Aliexpress,-5.86,EUR,,,Visa Credit,0000,,Shopping,
2023-01-25,K-market Haikko,-15.92,EUR,,,Visa Credit,0000,,Groceries,
2023-01-25,Lounasravintola,-11.00,EUR,,,Mastercard Credit,0000,,Eating Out,
2023-01-24,K-rauta.fi,-107.60,EUR,,,Visa Credit,0000,,Groceries,
2023-01-23,Sale Gammelbacka,-16.47,EUR,,,Visa Credit,0000,,Groceries,
2023-01-23,Motonet Porvoo,-16.98,EUR,,,Visa Credit,0000,,Shopping,
2023-01-22,Cmore.fi,-19.95,EUR,,,Visa Credit,0000,,Bills,
2023-01-22,Easypark Oy,-1.09,EUR,,,Mastercard Credit,0000,,Travel,
2023-01-21,Restaurant Roka,-26.00,EUR,,,Mastercard Credit,0000,,Eating Out,
2023-01-21,Sale Gammelbacka,-8.43,EUR,,,Mastercard Credit,0000,,Groceries,
2023-01-21,St1 Porvoo Eestinmaki,-77.08,EUR,,,Visa Credit,0000,,Travel,
1条答案
按热度按时间mefy6pfw1#
M列是Unique函数，用于创建Merachands的唯一列表。N列是Sumifs函数，用于计算。
减号把一切都变成了正值
但是最好的方式可能是一个数据透视表。也很容易改变。因为你的数据必须在一个表中，然后只需进入插入--〉数据透视表
此外，高级过滤器（特殊过滤器）将是可能的，但更多的工作。