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
- Is this income indian or foreign income?
- REGARDING GST ON COMMERICIAL PROPERTY
- 15ca /15cb whose income tax login? remitter or nri seller's login?
- GST on export of services and Input Credit
- ITC temporary reversal and reclaim
- Regarding Documentation & Compliances for Opening of Unit of Pvt Ltd.
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- TDS U/S. 194NF
- Applicable TDS rate for sale of property in Nov 2024
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- Payment of bonus act - notice pay recovery
- MIS MATCH OF INVOICE NUMBER
- GST Regis.
- ITC c/f from FY2022-23 to FY2023-24 entered the same in table 8C of GSTR9 of FY 2022-23, in FY23-24
- Late filling fees Demand by gst office
- IGST Credit-Show cause notice issued-confusion
- Short and Excess provision of expenses
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
Trending Online Classes
CAclubindia
