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

Page no : 5

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

Hi Seema,

Nice to have you on board. Things are pretty simple here , people ask questions and i reply.

Whenever you see any querry being missed out, OR inadequately resolved OR you feel you can add more value to it, PLEASE step in.

I believe SHARING knowledge is the BEST way to INCREASE knowledge.

Welcome again.

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

PLEASE DONT POST REPITATIVE MESSAGES JUST TO INCREASE YOUR REWARD POINTS!!!!

We are all associated with the country's most respected community, so let our actions justify our pride.

LAKSHMINARAYANAN (STUDENT) (60 Points)
Replied 23 May 2008

Dear Khaleel,

I just tried to retrive data in such manner, because the data we are having limited means we can either copy and paste or filter where as we required the data to manipulate for large data So I have tried.

But I have tried the with if condition, but presentation manner it is not clear.

If you give your mail id i wil send the sheet for an example.

Thanks for your updation from your valueable time.

Regards,

Lakshminarayanan

nidhi jain (student) (177 Points)
Replied 23 May 2008

how to use Vlookup & Hlookup command.pl guide me.i never work on it.pl help me with a example.my ID is jain_nidhi22 @ rediffmail.com

(Guest)

if you have date in A1 to A5 and quantity in B1 to B5. Put the following formula on any cell whre u want result =INDEX($A$1:$B$5,MATCH(MAX(B1:B5),$B$1:$B$5),1)

Ravishankar (C.A) (454 Points)
Replied 23 May 2008

please tell me what formula to be used for expressing figures in words, for example Rs.100 as Rupees One Hundred only

Ravishankar (C.A) (454 Points)
Replied 23 May 2008

pl tell me how to convert Rs.100/- into Rs.one hundred only

thanks

Anuj Goyal (Service) (39 Points)
Replied 23 May 2008

can you give me the command by which i write some thing in numeric ( 123) and it changed automatically in words ( One hundred Twenty Three)

Exshail (Software) (1576 Points)
Replied 23 May 2008

Hi Anuj & Ravishankar,

You can download one Addins "Indian Rupees" from below site. https://in.geocities.com/shahshaileshs/

For Non VBA solution you can find 3 workbooks with example from below site.

https://in.geocities.com/shahshaileshs/misc

1. Spellnoformula : Having formula to convert no. to words as per english system.(i.e. million format)

2. IndianSpellnoformula : Having formula to convert no. to words as per Indian Decimal system. (i.e. lakh format)

3. IndianSpellnoformulaHindi : Having formula to convert no. to Hindi Words.

You can also write copy\paste your desired languange fonts (supported by microsoft office) in the List.

Regards,

Shailesh

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

Hi Lakhsmi,

My email iD is : khaleelda1 @ gmail.com

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

Hi Naveen,

Below is a sample code you asked for. The character it searches for is "3", and if it is found it says, "match found" and if not it says "match not found"

Sub khaleel()
Dim asd As Integer

ActiveCell.Select
sample = ActiveCell.Value
If InStr(1, sample, 3) >= 1 Then
MsgBox ("match found")
Else
MsgBox ("match not found")
End If

End Sub

Hope this helps.

Brijesh Poddar (12 Points)
Replied 24 May 2008

Thanks dear, can u please explain me in detail about the use and function of pivot table and v look up functions. My friends keep on telling that things become very easy by these functions, but i have never tried..... Also can u please help me to calculate EMI in excel. Thanks