You are here:
Excel/Questions Answered by Expert Joseph Harris
| Subject | Date Asked |
| Copy cells from multiple worksheets To Another Workbook | 4/14/2009 |
| Q: i want to copy a particullar cellvalue from a workboook ( file name-Soure.xls) contains 50 ... A: Sunil... You can simply right click on the cell you want to copy and choose copy and then got to ... | |
| VBA in Excel | 4/11/2009 |
| Q: I do the following manually in an Excel spreadsheet: I copy the last row of a lot of data and ... A: Ashley... If the reason for doing this is to update charts then you should look into "Dynamic ... | |
| Conditional Formatting | 4/2/2009 |
| Q: Joseph: Hello! I am trying to get certain date cells to be highlighted if there are ≤ 30 ... A: Leprakawn: The simplest solution would be to add a "helper" column. In H1, type this formula and ... | |
| How to delete ' | 4/1/2009 |
| Q: I have this symbol " ' " in the entire sheet ie : '0122344 '0123234 '8384392 May i know how to ... A: Mcheal, There are two simple ways to remove the leading apostrophe in Excel. The first way is ... | |
| Conditional Formatting | 3/31/2009 |
| Q: I am working on a tracker that includes an effective date and an end date. I would like to highlight ... A: Matthew, Lets assume your effective date is in A1 and your end date is in B1. In C1, you would ... | |
| excel formula | 3/30/2009 |
| Q: i have a range of values in column A. EXAMPLE: GL2-RR2 STM10 10-2-7-3 CIRCUIT: GL2-RR2 STM10 ... A: Solay, To handle this task, you can use the sumproduct function: =SUMPRODUCT(--(A1:A13="GL2-RR2 ... | |
| Excel Formulas | 3/29/2009 |
| Q: I am in desparate need of help with 2 formulas that I need to complete a project for tomorrow ... A: David, #1. in C10, you would put: =if(C7>0,if(c8>0,c9-(c9*5%),c9),c9) It does not make sense that ... | |
| COUNTIF with data in two columns | 3/27/2009 |
| Q: I have scores listed in two columns, I would like to have the pass rate fill one cell in the ... A: Arthur... You can accomplish this using a nested if statement. If scores from A is in column A, ... | |
| need a help | 3/18/2009 |
| Q: i am prakash, in excel while putting vlookup() it takes first maching value only..but i want to take ... A: Prakash... Unfortunately there is no built in function meant to do exactly what you are trying to ... | |
| Percentages | 3/6/2009 |
| Q: So i'm working on a spread sheet in excel 2007 and i need to calculate the percentage of ... A: Annika... I am not sure how you have your worksheet set up, but I would recommend starting out by ... | |
| Converting the date to number of days | 3/5/2009 |
| Q: I want to convert date into days. For example if i want number of days between jan-3-2007 to ... A: Waheed... You can do this by subtracting the two dates and then converting the cell format to ... | |
| Selecting Multiple Rows on the basis of a Criteria | 3/3/2009 |
| Q: How can I select all the rows fulfilling a criteria? For instance, whenever I edit a cell in any ... A: Azeem... You can do this with conditional formatting. Step 1: Highlight your data table Step 2: ... | |
| Reporting information after a filter has been applied. | 3/2/2009 |
| Q: I am trying to only count data that is seen after a filter has been applied. I am trying to filter ... A: Peter... Somewhere in the header row place the following: =SUBTOTAL(2,B:B) This assumes the ... | |
| FORMULA FOR SUBTRACTING ALPHA NUMBERIC DATA | 2/19/2009 |
| Q: our office maintains inventory data for license plates that are alpha numeric. We want to be able ... A: David... I assume the numbers are separate from the letters on the plate, otherwise there is no ... | |
| Formula's | 2/17/2009 |
| Q: I am trying to see if the is a match in a column that is equal to PM01,PM02,PM03 and if it is, I ... A: Lannie, The formula below will count the total number of PM01, PM02 and PM03 and put the total ... | |
| if formula | 2/16/2009 |
| Q: Hai Joseph, How r you? i am working in an organization where 12 hrs shift working procedure. now i ... A: Vimal, A lot depends on the cell format of your current time formats. Assuming you have a custom ... | |
| invalid time formats excel | 2/14/2009 |
| Q: I am trying to format an invalid time in excel. The time is located with vlookup on the second page ... A: DB, The following formula should convert the time to fractions of hours, the result of the formula ... | |
| Excel vba | 2/13/2009 |
| Q: I need a excel vba function to convert a date format from 1/1/09 to 01-Jan-09 A: The VBA code to do what you want is: Sub custdate() Range("A1").Select ... | |
| excel formula | 2/10/2009 |
| Q: In column A i have to input the whole numbers, now for every given numbers i need to check that ... A: Sahil... I believe you are asking if a number from A2:A500 is in B2:B11 then put an x in C2:C500. ... | |
| Excel formula | 2/8/2009 |
| Q: I tried to combine 2 worksheets that bpth have 3 columns - date (A), description (B) and amount(C) ... A: Melody, I would keep your worksheets separate and try the following that should work in general. I ... | |
| tough excel question | 2/6/2009 |
| Q: I am doing a driver log check spreadsheet where there time in for each day of the month will be in ... A: Phillip, The first important thing to consider is what format the date/times are in. My answer is ... | |
| Fixing column data | 2/5/2009 |
| Q: I have database of about 250 contacts. I somehow messed it up and the column of addresses is off by ... A: Melissa, Select the entire area you want to move and drag it down four spots. you can drag by ... | |
| Conditional formating with 4 conditions | 2/3/2009 |
| Q: . New to this so be patient if the terms are no 100% correct. Have a list of text values that i ... A: As you point out, Excel has a limit of 3 criteria in Conditional Formatting. We can get around ... | |
| Convert Time to Decimal | 1/12/2009 |
| Q: Please help me to convert the time to decimal. For eg, I want to conver time 1:30 to 1.5 A: Hutovi, If the cell you are converting is in time format, then you can follow this process: Lets ... | |
| PRICE PER SQUARE FOOT | 1/11/2009 |
| Q: I RUN MY OWN LANDSCAPING BUSINESS I NEED TO CREATE A FORMULA TO CALCULATE BASED ON X AMT OF SQ FT I ... A: L, You can do this several way. The first is to type =x*.003 . You would replace the X with the ... | |
| Excel Function to totall certain results | 1/9/2009 |
| Q: I have the results from a survey and all the answers are either a 1, 2, or 3. I have entered them ... A: Nick... You can accomplish this by using the countif function. Example: Lets say your survey ... | |
| Add colour to a cell using a formula | 1/8/2009 |
| Q: I am trying to set up my database in such a way that I want the final column to show results if they ... A: Roger, You can accomplish this in Excel by using conditional formatting. Conditional Formatting is ... | |
| excel formula | 1/7/2009 |
| Q: HOW TO CONVERT NUMBER TO WORDS. EG. 225 [TWO HUNDRED TWENTY FIVE ONLY]. PLS SIR REPLY ME ON MY EMAIL ... A: Lingesh, To accomplish this in Excel you will need to use VBA. Below is the code and I will paste a ... | |
| replacing values | 1/6/2009 |
| Q: i'm having a problem replacing values in excel. i input sss numbers in excel but the database to ... A: Enrico, Unfortunately Excel removes the leading zero with find/replace unless you enter ... | |
| Excel sumif | 12/19/2008 |
| Q: I have two worksheets. The first has 4 columns(last name, first name,amount owed, amount paid), the ... A: I believe the formula you are looking for is: =SUMIF(Sheet2!B:B,Sheet1!A1,Sheet2!C:C) this assumes ... | |
| autoformat in Excel 2002 | 12/9/2008 |
| Q: When entering email addresses, excel automatically formats them as a hyperlink. In 2002, is there a ... A: You can remove the automatic hyperlinking feature by going to the tools menu=auto correct options. ... | |
| formula for percentage | 12/8/2008 |
| Q: I need a final total that is 30% of one sume 35% of the next sum and 35% of a third sum. How would ... A: I probably need to know more about how you have the worksheet laid out. But in general, if the three ... | |
| Text functions | 12/6/2008 |
| Q: I need to use a text function to separate names are entered into one cell. For example. A2 contains ... A: Hannah, There are several ways of doing this, below are two simple methods: in cell c2 place: ... | |
| countif with two or more criteria | 12/3/2008 |
| Q: What formula to count data in table array with two or more criteria? A: Setiadi, The easiest way to "countif" with two criteria is to use the following function: ... | |
| EXCEL MOD, DATE, MONTH, function | 11/19/2008 |
| Q: I am building a basic itinerary check-up for a train schedule in excel. Basically, I need to check ... A: I do not understand the schedule of the second train, could you expand upon that? It looks like the ... | |
| excell formula | 11/18/2008 |
| Q: I need a formula that will only total the amounts in a row or column that are not highlighted. ... A: Joe... You can click in the formula bar when you are on the cell and it will update or you can enter ... | |
| Data manipulation | 11/17/2008 |
| Q: I have a mailing list where I have merged two cells (last name and first name) to form a new column. ... A: Select your "merged cells" and copy them, then choose "paste special" and choose "values" from the ... | |
| excel | 11/17/2008 |
| Q: I have a large table with 20 columns and 1500 rows. concentrate on three rows, title, date, name. I ... A: You can accomplish this in several ways, the simplest would be to use sumproduct, the format would ... | |
| excell formula | 11/17/2008 |
| Q: I need a formula that will only total the amounts in a row or column that are not highlighted. A: To do this you need to use a user defined function (UDF). A UDF is a function that does not come ... | |
| AutoFilter | 11/14/2008 |
| Q: In Excel, I have spreadsheet, which I want to arrange so that only a specific data is showing. But ... A: There are several possible things going on here: 1. The Worksheet is protected 2. You have more ... | |
| Counting records within certain dates | 11/13/2008 |
| Q: I have a column of dates (column name "Purchase Dates") and want to count how many instances occur ... A: This will count all months independent of the year, so if you have 01/01/08 and 01/01/09, your Jan ... | |
| Summary Sheet | 11/12/2008 |
| Q: I have a workbook which contains 21 sheets. All cell entries are text. I want to be able to ... A: Sophia, I do not fully understand how your workbook is set up, but I will attempt an answer that ... | |
| Transfering data between sheets | 11/11/2008 |
| Q: I want help with the formula or function needed to take data (text) entered on four or five seperate ... A: Linda, Starting with the worksheet where you want to pull the data to, enter = in a cell and then ... | |
| formulas | 11/10/2008 |
| Q: i know that u put=sum( then the cell when making numerical formula. my ? is how do u format a cell ... A: Chris, if you wanted to directly put a word in a cell with a formula, you would use this format: ... | |
| excel question | 11/8/2008 |
| Q: I have video professor for excel 2000-the three levels for tutorial. I have to take a test for excel ... A: If the test is a beginners level test, I think you will be okay with the 2003 test, 2000 and 2003 ... | |
| Using Excel | 11/7/2008 |
| Q: I was wondering if there's a way to use excel as a follow up function. In my job whenever I'm ... A: There are several ways to do this in Excel. The most slick way to do it would be using VBA and ... | |
| spreadsheet formula | 11/5/2008 |
| Q: I have MS Works and would like to construct a table in which I add systolic blood pressure readings ... A: .. The formulas you will need are as follows: After all your data is entered in column A and c ... | |
| Formula Problem | 11/5/2008 |
| Q: I'm having a problem with one of my formulas. I have a database set up to record deliveries of ... A: John, I have never seen this problem before. I tried your formula as you have it and I change the ... | |
| Time & Date Excel Formula Needed | 11/4/2008 |
| Q: I am working on spreadsheet that needs to have very specific data available. Data is recorded ... A: Tiffany, You can do that. You are already half way there! When you subtract 11/4/08 9:26 AM - ... | |
| count repeat customers | 11/4/2008 |
| Q: In reference to the countif func. I need to isolate repeat customers say those who have returned > ... A: Joe, The most simple way to do this is with the countif function. If your data is in cells ... | |
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
Joseph Harris
Top Expert on this page
Expertise
I can answer all Excel questions related to functions, formulas, "dashboards", cell formatting and pivot tables. I also know some Visual Basic for Applications (VBA). I have several Excel Help websites where I write daily Excel Help articles.
Experience
I have worked in the finance industry for 20 years using Excel on a daily basis. I have taught classes and tutored many people. I have several Excel Help websites where I write daily Excel Help articles.
Publications
ezinearticles.com
Education/Credentials
BS in Finance and a Masters degree in Management information systems.
©2012 About.com, a part of The New York Times Company. All rights reserved.