Excel/Expert Profile


On Vacation
returns 03/31/2017

Can answer basic worksheet related questions like formulae usage, connecting to RDBMS from server to extract rows from tables, basic macro construction, pivot table creation, dynamic updation of worksheet data from Server RDBMS..

Experience in the area

3 years

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
Jonathan11/07/13101010To be fair, it wasn't all 10s .....

Recent Answers from Amal

2014-01-16 Excel help:

Hi Tom,    You can use a combination of the IF and Vlookup functions to achieve this.    File 1    c        d          1 Name     Wages  2 Namea2   2000  3 Namea3   1000  4 Namea4   3000    File 2

2013-11-06 Sorting lines in one document into search-term-entitled smaller documents.:

Hi Jonathan,    Here are two examples. One pulls out the lines that contains the word apple and the other that pulls out the lines that do not contain the word apple    -------------------------------------

2013-11-05 Sorting lines in one document into search-term-entitled smaller documents.:

Hi Jonathan.    I believe that the "find" utility in Windows should help you on this. But I need to do some testing to confirm this.    You can try it out as well by checking out the help for that command

2013-10-03 stock:

Hi Harish,    This would not be a simple task that I can tell over an email. I can provide a sample guideline. You would need to build up further on that.  Suppose the first sheet(sheeta) has the following

2012-10-31 sum of all elements of a matrix:

Hi Vivek,    You could use the Sum() function to add up all the elements of the matrix, just as you would use the sum() function to add up all the elements of a given row or column.    Do let me know if


Ask A Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here


All Answers

Answers by Expert:

Ask Experts


©2017 About.com. All rights reserved.