You are here:
Excel/Questions Answered by Expert Amal
| Subject | Date Asked |
| label and formula | 12/1/2011 |
| Q: Just wondering how to set up a label and step by step to move it in to word to print on an Avery ... A: In C3 paste the following contents, 5 WEll Name 9D1-12-3D1-10-8-30 W1M ... | |
| Finding text in cell | 4/5/2011 |
| Q: PLease see attachment. If i want to find a match for 74929 to show "hello", how do i do that? Also, ... A: Hope the example below helps. F H 9 a apple 10 f fruit 11 b box 12 ... | |
| lookup value | 3/3/2011 |
| Q: How are you, hope you are doing Ok. I have this problem that I wanted to solve but I'm stuck with ... A: Suppose you have the following entries in "Jan" sheet Name Age City JanA 11 JanAcity ... | |
| Excel for Mac 2008 - Workbook | 11/1/2010 |
| Q: I have a MacBookPro and I am trying to change the color of the workbook tab. With a PC you right ... A: I have not worked with MacBookPro and hence not able to answer this question. Not sure if it is ... | |
| Need help for verifying time | 7/1/2010 |
| Q: I need help for two cells , i have two columns with different times one column contains India time ... A: Have the following values in the columns c,d,e,f,g, in row 9 as below. c d e f g ... | |
| Subtraction | 9/3/2009 |
| Q: Am using Microsoft office Excel 2003. And a problem has been occurred with subtraction, like, if i ... A: There should be absolutely no problems with a formula like =5-3. 1. Ensure that you did not type a ... | |
| excel | 2/3/2009 |
| Q: I hope u will quait well. Sir I have a problem in fromulation in excell,that is " I want entry as a ... A: It is not possible to convert the date completely into words. However you can convert a date into ... | |
| How do I learn practical VBA? | 12/3/2008 |
| Q: How do I learn enough VBA to be able to use at my day to day simple calculations? I've bought some ... A: Books are the best bet to learn VBA (or any topic for that matter). If you do not have the patience ... | |
| excel -vba- text file | 10/3/2008 |
| Q: 1) i have table down loaded from sap.in to excel. but i get hypen like this ... A: For people that are familiar with Excel, this would not be a problem. Once you open the file in ... | |
| Extract text from a cell | 8/4/2008 |
| Q: Problem: I have a cell in which the data will be as follows (please copy into a notepad): xxxxxxxx ... A: The formula to get the date would be , ... | |
| Problem in aplying vlookup formula | 4/1/2008 |
| Q: I am having problem while using vlookup command in Excel. I have data base on one year. I am look ... A: Please ensure that the table_array is sorted and the table_array rows are not in the same rows as ... | |
| Counting problem | 1/2/2008 |
| Q: I would be much appreciated if you could help to advise me the formula to solve my problem. I need ... A: You would need to use the formula like =dsum(). It would be a lengthy procedure to explain the usage ... | |
| Sumif Help Request | 12/1/2007 |
| Q: i kindly need your help in the following: i have a sumif formula as ... A: Please try using the absolute addressing ($) to fix the cells that you would want to include in the ... | |
| how to sort rows with formulas | 3/1/2007 |
| Q: I have a difficult issue that I am trying to resolve and since I am new at excel2003 I cannot find ... A: You can first copy the cells that you wish to and then use the following sequence of commands to ... | |
| Textfile saved from Excel | 5/1/2006 |
| Q: Whenever I want to use a textfile created by doing a saveas on an Excel worksheet, I can't access ... A: You can never have two different programs accessing a file that has the same filename. In your ... | |
| Make 1 field into many columns | 11/15/2005 |
| Q: I have a single field with values like - 123,456,789 and would like to have them converted to single ... A: You could use the Data->Text to Columns options. Select the column that you wish to convert into ... | |
| If/or formula | 2/1/2005 |
| Q: I want to set up a formula that looks at 5 or 6 cells (in the same row, although not next to each ... A: You could use this function in the cell, where you did like to put the result ... | |
| Macros | 11/30/2004 |
| Q: How do I "enable" an existing macro? Thanks! P.S. We're using EXCEL 2000. A: If you want to execute an existing macro, you could goto to Tools->Macros->Execute to run an ... | |
| modify a list | 4/30/2004 |
| Q: I have a list of emails in excel and would like to have a comma afer each one. How can I do that to ... A: I assume that each email is contained in a row in a single column. Insert a blank column next to the ... | |
| formulas | 3/1/2004 |
| Q: I am using Excel 2000 and cannot figure out the following formula: I want to type a part number ... A: Suppose you have the data in worksheet2. Name it as Db and sort it on the first column which ... | |
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
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
Answers by Expert:
- Mary A. Lindsey
- Nathan Head
- Raj Narayan Banerjee
- Chad Welch
- Ken Cowen
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bill Hermanson
- Jerry Beaucaire
- Michelle Howell
- Isaac
- Edward H. Mori
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- JP
- Richard Rost
- Victor Lan
- Tushar Sakhalkar
- Philip Buckley
- David W. Cofer
- Amal
- Bob Umlas
- Jessica L.
- Shahid
- Jan Karel Pieterse
- Craig
- Adelaide carvalho
- Sixthsense
- Bill
- Anne Troy
Amal
Top Expert on this page
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
3 years
©2012 About.com, a part of The New York Times Company. All rights reserved.