Excel
This query is : Resolved
22 May 2010
I have prepared sheet for the stock of 20 items in the following formate:
Oct. Item 1 Item 2
Day
Ope Pur Sale Cl
1 6.70 13.15 6.70 13.15
2 13.15 0.00 13.15 0.00
3 0.00 13.35 0.00 13.35
4 13.35 6.50 13.35 6.50
5 6.50 19.70 6.50 19.70
6 19.70 19.75 19.70 19.75
7 19.75 6.65 19.75 6.65
8 6.65 13.50 6.65 13.50
9 13.50 13.40 13.50 13.40
10 13.40 13.35 13.40 13.35
11 13.35 33.30 13.35 33.30
12 33.30 136.50 33.30 136.50
13 136.50 96.15 15.15 217.50
14 217.50 159.15 12.20 364.45
15 364.45 19.95 380.40 4.00
16 4.00 13.60 4.20 13.40
17 13.40 0.00 5.00 8.40
18 8.40 0.00 3.00 5.40
19 5.40 0.00 3.00 2.40
20 2.40 0.00 2.00 0.40
21 0.40 6.75 3.00 4.15
22 4.15 0.00 3.00 1.15
23 1.15 25.45 20.00 6.60
24 6.60 13.35 15.00 4.95
25 4.95 6.80 10.00 1.75
26 1.75 13.35 15.00 0.10
27 0.10 13.00 12.50 0.60
28 0.60 13.20 10.00 3.80
29 3.80 13.10 15.00 1.90
30 1.90 6.70 5.00 3.60
31 3.60 13.45 15.00 2.05
I have prepared such 12 excel sheets each saperat sheet for 12 months and each include total 20 Items, above data is a part of a sheet for an example.
Now as per my requirement I want month wise sheet in following format:
Total 31 days and 20 Items
Purchase 1 2 3 4
Itme 1 13.15 0.00 13.35 6.50
Item 2 6.50 20.00 26.20 19.95
Item 3 5.70 0.00 5.85 0.00
Item 4 0.00 0.00 6.00 0.00
And so on
Is there any Excel formula by which I can get result like this?
Please friend help me its very very crucial.
Thanks in advance.
Oct. Item 1 Item 2
Day
Ope Pur Sale Cl
1 6.70 13.15 6.70 13.15
2 13.15 0.00 13.15 0.00
3 0.00 13.35 0.00 13.35
4 13.35 6.50 13.35 6.50
5 6.50 19.70 6.50 19.70
6 19.70 19.75 19.70 19.75
7 19.75 6.65 19.75 6.65
8 6.65 13.50 6.65 13.50
9 13.50 13.40 13.50 13.40
10 13.40 13.35 13.40 13.35
11 13.35 33.30 13.35 33.30
12 33.30 136.50 33.30 136.50
13 136.50 96.15 15.15 217.50
14 217.50 159.15 12.20 364.45
15 364.45 19.95 380.40 4.00
16 4.00 13.60 4.20 13.40
17 13.40 0.00 5.00 8.40
18 8.40 0.00 3.00 5.40
19 5.40 0.00 3.00 2.40
20 2.40 0.00 2.00 0.40
21 0.40 6.75 3.00 4.15
22 4.15 0.00 3.00 1.15
23 1.15 25.45 20.00 6.60
24 6.60 13.35 15.00 4.95
25 4.95 6.80 10.00 1.75
26 1.75 13.35 15.00 0.10
27 0.10 13.00 12.50 0.60
28 0.60 13.20 10.00 3.80
29 3.80 13.10 15.00 1.90
30 1.90 6.70 5.00 3.60
31 3.60 13.45 15.00 2.05
I have prepared such 12 excel sheets each saperat sheet for 12 months and each include total 20 Items, above data is a part of a sheet for an example.
Now as per my requirement I want month wise sheet in following format:
Total 31 days and 20 Items
Purchase 1 2 3 4
Itme 1 13.15 0.00 13.35 6.50
Item 2 6.50 20.00 26.20 19.95
Item 3 5.70 0.00 5.85 0.00
Item 4 0.00 0.00 6.00 0.00
And so on
Is there any Excel formula by which I can get result like this?
Please friend help me its very very crucial.
Thanks in advance.
22 May 2010
submit your quary in forum section to under stand better you requirment.
of attached file so your matter will be short out.
of attached file so your matter will be short out.
Message likes :
1 times
22 May 2010
Thanks for the instant reply..
I have posted in forum section..
I have posted in forum section..
24 May 2010
Solution is Pivot Table, which I have sent to your mailbox
Message likes :
1 times
02 June 2010
Other members can see the solution attached at 2nd reply to page two of :
https://www.caclubindia.com/forum/require-excel-function-which-can-solve-my-query-84321.asp?offset=2
https://www.caclubindia.com/forum/require-excel-function-which-can-solve-my-query-84321.asp?offset=2
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Off Market debit and credit transaction
- Itr 1 processing
- Showing Gift from relative in ITR for this year
- ITR returnFY25-26
- ITR selection for salaries and capital gain less than L
- Form 10E u/s 89(1). Need clarification because experts opinions differ !!!!
- Share accounting-->fifo - capital gain - period as per fifo?
- Short Term Capital gain on shares bought and sold after 2018 onwards
- ITR 2 Short Term gain & Long term gain
- INCOME TAX ON REDEVELOPEMENT OF FLAT
- ITR 1: Details for showing Exempt Income
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
- Tax amount diff in Gstr1 and 3B in tax compare reports
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
