Can anyone help with this?
I have a column with descriptions and one with amounts like:
FoodstoreA, Oslo, Norway 203,45
Food shopB, Bergen 123,45
Shell Oslo 102,80
I would like to have lists in other columns like
Food Car Expenses
Food shopB Exxon
and then in one adjacent column (C) have all the food amounts and another column (D) with all the car expenses etc.
if value in column Description contains any of the substrings in the column Food, then show amount. Otherwise 0 or blank.
That would leave me with one column for food expenses and one for car expenses and I could go on with other types of expenses in separate columns.
Thanks for any help!
IVer in Oslo