banner_ad

Abhishek
This Query has 4 replies

This Query has 4 replies

27 May 2010 at 14:43

Configration

Can any one provide the best laptop configration in the range of 40000 to 50000


C A tejal
This Query has 4 replies

This Query has 4 replies

22 May 2010 at 13:08

Excel

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.



Anonymous
This Query has 1 replies

This Query has 1 replies

16 May 2010 at 18:05

using V look up and H look up

Anyone can guide me on how to use V look up and H look up in a detailed manner. Plz give me step by step answers. Its very urgent. Thanks for everyone who replied.


Satyanarayanan
This Query has 2 replies

This Query has 2 replies

15 May 2010 at 22:11

Comparing the balances!!!

In our company we have two softwares
(i) customised ERP - upgraded one
(ii) Customised Software based on VB- the earlier one.
Currently we are working on both the versions. There is differences in balances between the two versions. On both the versions we can transfer the data to Ms-Excel.I want to compare the two ledgers and have to give a report why there is differences. There are many balances to be compared it may take more time...so it will be great if some one can help me in this issue.



Anonymous
This Query has 3 replies

This Query has 3 replies

13 May 2010 at 10:11

flowcharts

what r the main points to bear in mind before preparing a flowchart?



Anonymous
This Query has 2 replies

This Query has 2 replies

30 April 2010 at 14:21

Taxation on Computer software

We are IT company in business of software development.

We make software on demand as well as we have few readymade software under our trade mark.

Please tell me about taxation, wheather both service tax and sale tax chargeable on us or not ?

Please give refrences in support of your answer


Jitendra Rathod
This Query has 3 replies

This Query has 3 replies

29 April 2010 at 18:16

Convert Time to value (Rupees)

Dear All,

PLease help in this regard -

I want to convet time (1:20 AM) to Value ie Rs 1.20

Its Urgent please Help!!!!!!!!!!!!

Do the needful

Regards
RJ


sanjay
This Query has 2 replies

This Query has 2 replies

28 April 2010 at 21:17

SISA

WHAT IS "SISA" HOW I CAN DO THAT COURSE? PLEASE GIVE ME FULL DETSILD SBOUT COURSE SUBJECT,FEES,DURATION AND REGISTRATION DETAILS.
PLEASE OBLIGE ME AND REPLY AS SOON AS POSSIBLE. MY MAIL ID IS "sanjayparmar1412@gmail.com
what is the difference between "SISA" and "DISA"


Dinesh
This Query has 8 replies

This Query has 8 replies

27 April 2010 at 18:34

ITR 2

We are software developer company. and
we want develop website in which
employee or any person fill ITR2 form online then after press submit button his all detail will be submitted to government.


Please help me because my senior give this task for 1 week


Satyanarayanan
This Query has 2 replies

This Query has 2 replies

25 April 2010 at 08:07

Pivot Table

Can anyone plz. explain me
1.what is pivot table( in MS-Excel), what are its uses in a corporate and how to put pivot table.
2.Whats V look up and H look up how to put those and what are its uses.
3. Is there any other function or tools which will be helpful for decision making available in MS-Excel






CCI Pro
Meet our CAclubindia PRO Members

Follow us
add to google news


Answer Query

Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details
Company
07 June 2026
Tax Associate

Rajkumar Jain & Co.

Ahmedabad

Graduate (Any)

View Details
Company
Featured 26 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
23 May 2026
Article Assistant

Geeta Manchanda & CO.

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 28 May 2026
Accounts, Audit & Compliance Executive

Shyam Joshi & Associates

Pune

B.Com

View Details
Company
ARTICLESHIP 04 June 2026
Article

Rakhecha & Co.

New Delhi

CA Inter

View Details
Company
26 May 2026
CA / MBA (Finance) / CMA / M.Com (Finance)

Sri Aurobindo Gnostic Centre of Education

New Delhi

CA

View Details
Company
21 May 2026
Associate

PWC

Kolkata

CA

View Details