LIVE GST Certification Course by CA Arun Chhajer begins 21st April. Register Now!!

Excel at Excel....!!!!!(Ask anything and everything)

Khaleel A G (Senior Manager) (146 Points)

20 May 2008

Hello Friends,

I see a lot of people here helping out our fellowship by every means they can. Even I would like to do my bit.

If you guys have any doubts/problems about anything and ANYTHING at all in EXCEL!!!!!..........I AM HERE TO HELP!!!

Though i am not a subject matter expert, but i would work hard towards resolving your issues.

GOD bless all of us become Chartereds.!!!

Reply
Follow
Share

107 Replies

Khaleel A G (Senior Manager) (146 Points)
Replied 20 May 2008

Freinds please dont mail me your queries, instead just reply on this Forum, so that it there for everyone to see, and we avoid duplication.

CA Naveen Kumar Agrawal (Chartered Accountant / MBA) (939 Points)
Replied 20 May 2008

Dear Khaleel hello, if u have prepared some projects or ur magic tools on excel please send me that at my mail id navee_guru @ yahoo.co.in or tell me about how can we make a macro on excel which should be executed if a conditiond is satisfied.(i mean to say how can we attach a condition with a macro) it shoud be automatically run if a particular condition (already defined) is fulfilled. Thanx in advance. hope u will repy me CA Naveen Kumar Agrawal +91 9216408902

CA. Yayati Tyagi (Service) (1512 Points)
Replied 20 May 2008

hi Khaleel,

when we use vlookup formula, it gives result from leftmost coloum of a range only. is there any way out to get result from other coloums of a range?

thanx,

yayati

Khaleel A G (Senior Manager) (146 Points)
Replied 20 May 2008

Hi Naveen,

I would like to know your understanding level about VBA, before i throw a bunch of programming concepts.

However, i would like to say that , Conditional formatting, is not possible by following "Record the Macro" approach, it requires programming in VBA.

If you can give me a sample case, i can send you a program for that.

Hope this helps.

Khaleel A G (Senior Manager) (146 Points)
Replied 20 May 2008

Hi Yayati,

This is a inherent problem with VLOOKUP, it always references the left most coloumn, so far i have not come accross a way to workaround this.

The alternative for this is to use the index function,

syntax: INDEX(array,row_num,column_num)

I believe this will solve your issue.

Let me know if this dosent work for you.

Hope this helps.

Khaleel A G (Senior Manager) (146 Points)
Replied 21 May 2008

Hello Friends,

I have uploaded a basic book on excel in "Files" section.

File is called - "Excel for beginners - Important Basics".

Nevertheless , this dosent stop you from asking me directly.

nJoy!

Anshika ( CA -Industry- Sr.Accounts Officier) (141 Points)
Replied 21 May 2008

Hi Khaleel

I want to how to do subtotal in a large sheet .I tried subtotals present in data section but it doesn't resolve the purpose. Is there any method in excel that we give some criteria eg location & excels subtotals accordingly the whole row

CA. Yayati Tyagi (Service) (1512 Points)
Replied 21 May 2008

hi Khaleel, thanks for being quick in reply,

my problem is not solved by index function. suppose i have 2 colomn, first of date and second of qty. now pls give me a formula which can give me date of max qty. (by keeping date in first colomn and qty in second only)

thanks,

yayati

sandeep Banerjee (Service) (39 Points)
Replied 21 May 2008

Hi Khaleel,

Can we convert Rupees in words automatically in excel? Say in G22 we have make the page total of an invoice and in B26 the same rupees in words is required.

Sandeep