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

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.

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.

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

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

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

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

thanks

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)

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

Hi Lakhsmi,

My email iD is : khaleelda1 @ gmail.com

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.

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

hi : Khaleel i am hemant i want to know about pivot table and advance filter plz help me i am an articale assistant i know you can help me

thank you

For online training for pivottable from microsoft see below link
https://office.microsoft.com/training/training.aspx?AssetID=RC010136191033

For online training in excel-2003 from microsoft visit below link
https://office.microsoft.com/en-us/training/CR061831141033.aspx
 

Regards,

Shailesh