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

hi,

how to use vlookup command.pl guide me.i never work on it.pl help me with a example.my ID is ca2006anshuman @ gmail.com

Dear Khaleel Sir,

I had a problem in Excel 2003 , I am having fields of DATE, AND QUANTIY for doing max(B1:B30)OF QUANTITY it is showing result, but i want the result as Max(result) and where(which date) the maximum result in date field which is in (a1:a30). Pl give solution.

Pl. give proper reply, Thanks in advance, I will be gratefull to you.
 

Dear Khaleel Sir, I had a problem in Excel 2003 , I am having fields of DATE, AND QUANTIY for doing max(B1:B30)OF QUANTITY it is showing result, but i want the result as Max(result) and where(which date) the maximum result in date field which is in (a1:a30). Pl give solution.  Pl. give solution, Thanks in advance, I will be gratefull to you.
 

hi s.d.,

i have asked the same question to khaleel. read his answers and my further questions. it should be of your help.

yayati

Dear Khaleel Sir,

I had a problem in Excel 2003 , I am having fields of DATE, AND QUANTIY for doing max(B1:B30)OF QUANTITY it is showing result, but i want the result as Max(result) and where(which date) the maximum result in date field which is in (a1:a30). Pl give solution.Thanks in advance, I will be gratefull to you.

please tell me that how can i convert text into numbers & vice versa

like 500000 to five lakh &

five lakh to 500000

if there is any formula for this please tell me

please tell me that how can i convert text into numbers ?

There are some addins\workbooks (no VBA code requried)  found on below site.https://in.geocities.com/shahshaileshs/

1. Indian Rupees is an addin that convert number to Indian Rupees in words and also convert number format as per Indian Decimal System. e.g. 102030000.00 to 10,20,30,000.00

Goto Com-addins and MISC page for more addins\workbooks

Enjoy.

Dear All,

If any body wants all excel short cuts, macros ( for converting numbers into text),  & many more etc in one File menu.

 Then please install ASAP Utilities from below Link

Step 1

Down load ASAP utilities

https://www.asap-utilities.com/download-asap-utilities.php

 Step 2 : Install the dowladed tools.

Step 3 : After Installation

Tools --> Add-Ins ---> Select ASAP utilities

Restart the PC, if ASAP tools are not working

Once installed start using it.

Regards,

Krishnanand

Hi Anshika,

"Subtotals" is a quite comprehensive tool.

Please tell me your situation, and how this standard function is not helpful to you.

If you think it is a very specific/detailed querry, then please mail me your excel sheet, i'll look into it.

Mail iD: khaleelda1 @ gmail.com

Hi Krishnanand,

I appreciate your contribution.!!

Keep up the spirit!!

Converting Numbers to text!!!!!

Looks like Ashok has addressed that querry!!!

Please let me know if anyone still have issues.

Hi Mohit,

This can be done using the control buttons (+ and -) towards the left side of the window,

OR

simply copy the data, and use filter to show rows which contain subtotals, or some other criteria, and you can work on them.

If this dosent work for you, please let me know your issue in detail, or mail me your excel sheet.

hope this helps.

Please explain me the use and how to use VLOOKUP and pivot tables in detail.