Good Morning master excel semuannya, I am a beginner in using excel application.
Please help to determine the average cost / unit (in marking with yellow) in the data
sales, sales returns and purchase returns with excel formulas. If I analyze the data determine the unit average cost / unit with manual way it will spend time. and also if data consists of several items and also a lot of transactions then it will be difficult for me.
An excel file sample is attached to this message. I'm sorry if I've disturbed the activities of master2 excel in this group. Please solve my problem with urgent.
Thank you
Kana
http://www.mediafire.com/file/3569ayjbn1tjhmr/average_cost-unit..xls
Please help to determine the average cost / unit (in marking with yellow) in the data
sales, sales returns and purchase returns with excel formulas. If I analyze the data determine the unit average cost / unit with manual way it will spend time. and also if data consists of several items and also a lot of transactions then it will be difficult for me.
An excel file sample is attached to this message. I'm sorry if I've disturbed the activities of master2 excel in this group. Please solve my problem with urgent.
Thank you
Kana