Excel/Expert Profile

Amal

India
On Vacation
returns 02/29/2012
Expertise

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
UserDateKCPComments
A.10/07/11101010 
Kevin09/02/10101010Thanks...
Deepika09/04/09101010Problem is solved :) Thank you very .....
zulfiqar02/03/09thanks Amal, and I hope soon we .....
harish10/05/08it was good, but i have still .....

Recent Answers from Amal

2011-12-01 label and formula:

Hi Ryan,    In C3 paste the following contents,      5           WEll Name      9D1-12-3D1-10-8-30 W1M          LICENCE# 11A195    In C8 paste the following contents    =c3+5          <------------this

2011-04-05 Finding text in cell:

Hi Kye,    Hope the example below helps.        F       H    9  a apple  10  f fruit  11  b   box  12  b =VLOOKUP(F12,$L$14:$M$18,2,0) (Formula to use)  13  e emu  14  h horse      Data

2011-03-03 lookup value:

Hi Bill,    Suppose you have the following entries in "Jan" sheet    Name Age City  JanA 11 JanAcity  JanB 12 JanBcity    and the following in "Feb" sheet    Name Age City  JanA 21 FebAcity  JanB 22 FebBcity

2010-11-01 Excel for Mac 2008 - Workbook:

Hi Brian,    I have not worked with MacBookPro and hence not able to answer this question. Not sure if it is possible. Have you checked on this on Google ?.     Refer to this links  http://www.officeformac

2010-07-01 Need help for verifying time:

Hi Abhinav,    Have the following values in the columns c,d,e,f,g, in row 9 as below.  c d e f        g  0 1 0 =TIME(C9,D9,E9) =TIME(C9+5,D9,E9)    You can put some values in column e if you want the

 

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

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


©2012 About.com, a part of The New York Times Company. All rights reserved.