Forum Discussion
HELP!! Stuck on INDEX/MATCH/IF Formula for Days!
Hi there! I've been trying to create a some-what dynamic Excel worksheet for my monthly expenses, so I can analyze data in real time. Just a small intro-- I have data imported from my bank s...
I guess to reclassify categories need a table to map each sub category like the first table below。
it looks more easier if deal with sql。
select * from category_and_keywords;
select * from classify_to_category_according_to_keywords;
select * from classify_to_category_according_to_keywords left join category_and_keywords on instr(payee,keywords)>0select * from category_and_keywords; select * from classify_to_category_according_to_keywords; select * from classify_to_category_according_to_keywords left join category_and_keywords on instr(payee,keywords)>0
- Thank you so much for the consideration!
