Formula that can automatically classify monthly expenses [Closed]

Report
-
Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
-
Hello, i need a formula that can automatically classify monthly expenses. I want the amount to be transferred to the similar subhead automatically as I am input the data. Thanks
E.g.

Date Name classification amount travels training logistic
1/1/16 X travels 200 ?
4/1/16 H training 500 ?
6/1/16 G logistic 500 ?
15/1/16 K travels 600 ?
23/1/16 O training 900 ?
30/1/16 S logistic 300 ?




1 reply

Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
446
Hi Nath,

It is unclear to me what you are trying to achieve. Can you show sample data how it is now and how you want it to be, along with steps necessary to get there?

Best regards,
Trowa

Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.