Easy Office
LCI Learning

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

Page no : 2

ANSHUMAN KHANDELWAL (JOB) (311 Points)
Replied 21 May 2008

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



(Guest)

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.
 


(Guest)

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.
 


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

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


satya (Executive Excise) (1839 Points)
Replied 21 May 2008

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.




Deepak Jajoo (CA) (82 Points)
Replied 21 May 2008

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


masthk (ca) (23 Points)
Replied 21 May 2008

hi i want to know about use of vlookup and u lookup an how we can use it

Mohit (student) (20 Points)
Replied 21 May 2008

1. how to pics few cell values like every 3rd cell value & use this for some other calculation puposes 2. How to pick only Sub -total cell after sub-totaling

(Guest)

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.


Krishnanand (CA) (98 Points)
Replied 21 May 2008

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

 




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

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


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

Hi Krishnanand,

I appreciate your contribution.!!

Keep up the spirit!!


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

Converting Numbers to text!!!!!

Looks like Ashok has addressed that querry!!!

Please let me know if anyone still have issues.


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

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.




Vardhman Dangi (CA) (91 Points)
Replied 21 May 2008

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



Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  


Related Threads


Loading


Subscribe to the latest topics :

Search Forum: