Hi Friends,
In the attached file, what I want is to know how much total purchases have been made from each supplier, how can I do so, any formula ?
Vaibhav Jandey (Life iz Hard; I'm Harder) (1175 Points)
16 December 2013Hi Friends,
In the attached file, what I want is to know how much total purchases have been made from each supplier, how can I do so, any formula ?
Anandan
(HOD accounts)
(502 Points)
Replied 16 December 2013
Respected Vaibhav,
you can take the help of Pivot table, to extract the desired details from the datasheet.
Please find attached the same.
Thanks & Regards
Anandan.s
Amrin
(Chartered Accountant)
(215 Points)
Replied 16 December 2013
Apply "FILTERS" in the cell , right click the "Particulars" tab and then select filters.. u can then select any one company from the dropbox and you will get all the individual purchases from that party,
P.S you "AMT" is not correct, in some place the amount is inserted in a way which excel doesnt recognize and hence you sum total will come wron.. so correct that!
Rajesh
(student)
(193 Points)
Replied 16 December 2013
Dear Vaibhav,
Here with i attached your Excel sheet.
I have added Subtotal Formula. ( I have highlighted with Yellow Color).
This subtotal formula will give purchase details of the individual.
Formula of Subtotal =Subtotal(9,select the range)
Vaibhav Jandey
(Life iz Hard; I'm Harder)
(1175 Points)
Replied 16 December 2013
Thank you friends for your replies, Anandan you gave me what I was looking for.
Join our off-topic community "EVERYTHING etc" for ultimate leisure, fun and etc.
CAclubindia
