Formula that can automatically classify monthly expenses

Closed
Nath - Feb 15, 2016 at 05:25 AM
TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
- Feb 15, 2016 at 11:31 AM
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

TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
512
Feb 15, 2016 at 11:31 AM
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.
0