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.
Ram Avtar Singh
(Expert)
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
- Accounting treatment of AMC alongwith the purchase of Laptop
- Nursery business
- Condonation Request sec 119(2) b -Enhancement Limit of Leave Exemption prior to AY 2023
- Not ordinarily resident having partnership income in India and salary in USA is any form to filed be
- GST Treatment of Purchases with GST Paid where Outward Supplies of Manufactured CattleFeed Exempt
- Issuing of delivery challan by seller of goods
- Tax on Amount transferred in HUF Account
- WRONG GSTR7 ENTRIES ACCEPTED ERRONEOUSLY
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
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
