Automatically fill Category to expenses tracking
Hi. I'm exporting .csv files from my bank, and I want to create expense tracking on Numbers.
Each transaction comes with a name. I want to add a column for categories. Instead of manually adding a category I want to do it automatically. I've created a 2nd table for keywords and assigned a category for each. I want Numbers to match the "name" column to the "contains" column, and if there's a match, input the value from the "category" column. Is this possible or is there an easier way to do this?
Thanks!
