You are here:
Excel/Questions Answered by Expert Chad Welch
| Subject | Date Asked |
| VBA count help in a range across multiple sheets | 1/8/2012 |
| Q: I am working on a basketball stat sheet as a college project. I have it mostly done. I am just stuck ... A: You are very close. The problem is that you are looking at the range, but you need to look at ... | |
| reply to your email | 1/7/2012 |
| Q: I can't thank you enough for this help. THANK YOU! so much! Okay here goes: 00-11 PATIENTS: ... A: It's good to hear from you again. This can be done by using a few nested IF functions in Excel. So ... | |
| VBA - Goal Seek | 1/3/2012 |
| Q: I was wondering if you could help me on this: I have been using VBA for Goal Seek funcionality in ... A: NCA, That error means that VBA cannot load something that is referenced in the code. Unfortunately, ... | |
| Dealing with Blank Values | 1/2/2012 |
| Q: Hey, I'm using the following formula to figure out the difference between two dates: ... A: The following formula should work for you. It checks column A, if it is blank then it will return a ... | |
| Excel date formula | 6/1/2010 |
| Q: I have a table set up for our products including a ship date and warranty expiration date. Recently ... A: The problem lies in the way Excel handles dates. It converts the date to the number of days since ... | |
| Searching Within Excel | 4/15/2010 |
| Q: in sheet B I want to have some kind of function that enables the user to type in a name in a cell ... A: The VLOOKUP function is the one you are looking for. The syntax has the following arguments ... | |
| Column change | 3/24/2010 |
| Q: I have an excel spread sheet which has the columns changed from A,B, C etc., to 1,2,3 etc. So ... A: You didn't mention what version of Excel you are using. I have Excel 2007 at this computer, so I'll ... | |
| Excel Date Advancer | 3/22/2010 |
| Q: I would like to ask if there's any way to formulate the whole excel work sheet so that whatever date ... A: I'm not sure what happened to my answer the first time you followed up. It is available at ... | |
| compound if statement | 3/19/2010 |
| Q: How do I write a formula that reads like this...if cell x=1, tnen do this, if cell x=2, then do ... A: The easiest way to do this is to use the CHOOSE function. Assuming cell x is A1, the following ... | |
| Excel Date Advancer | 3/18/2010 |
| Q: I would like to ask if there's any way to formulate the whole excel work sheet so that whatever date ... A: Good to hear from you again. That is possible. Just change the line that starts "If IsDate." ... | |
| Copy data problem | 3/11/2010 |
| Q: I am trying to put together a macro to cut and paste rows to Sheet2 based on the values in columns ... A: The syntax is slightly off on that line. VBA is a very literal language, so you have to be very ... | |
| Excel Date Advancer | 2/4/2010 |
| Q: I would like to ask if there's any way to formulate the whole excel work sheet so that whatever date ... A: Jerryl, Yes, this is possible. Right click on the worksheet tab and choose "View Code." Paste the ... | |
| Executing an add-in | 2/3/2010 |
| Q: I have installed an add-in via a msi installation package. This has added a new button to one of the ... A: Daniel, Yes it is possible. All the toolbar button does is execute a macro itself, so that macro can ... | |
| User form command button code | 2/2/2010 |
| Q: I'm having problems with the syntax in the code for an "OK" command button. I've built a form for a ... A: You are correct, the error is on the lines: iRow = ws.Row13 .End(xlUp).Offset(1, 0).Row Replace ... | |
| Sort before using the BeforeSave Event for a workbook | 1/24/2010 |
| Q: I want to sort a range of cells using the BeforeSave Event for a workbook - is this possible? The ... A: Lisa, The code won't work in version 2003, but the following should do what you need. Private Sub ... | |
| Excel color using formula or code | 1/22/2010 |
| Q: How do I change the font of a description in one cell depending on the number in another cell? ... A: Tom, There are a couple of ways to accomplish this. The best way is to use a formula in cell C2 that ... | |
| Sort before using the BeforeSave Event for a workbook | 1/21/2010 |
| Q: I want to sort a range of cells using the BeforeSave Event for a workbook - is this possible? The ... A: Lisa, This is possible but it is done differently depending on what version of Excel you have. The ... | |
| FORMULA | 1/12/2010 |
| Q: YOU POSTED THIS FORMULA AT LINK http://en.allexperts.com/q/Excel-1059/combinations-numbers-1.htm ... A: Scott, There are basically 3 parts of the existing equation. The first part divides the row number ... | |
| Copy paste sheets for fiscal year | 1/6/2010 |
| Q: I have seen VBA here: ... A: Reem, That code will work for you as well. For the normal calendar year, the code would need to be ... | |
| excel VlOOKUP AND IF FUNCTION | 12/9/2009 |
| Q: Student name-Exam 1-Exam 2-Quiz 1-Quiz 2-Quiz 3-Project 1-Project 2-Project 3-Project 4-Total Points ... A: Kyle, When copying data into this forum, the spaces and tabs don't copy well, so the formulas below ... | |
| Simple macro | 12/5/2009 |
| Q: I want to create a macro that will always copy row 3 and insert the copied row above the cell I am ... A: Toby, Open the visual basic editor by pressing Alt+F11 while in Excel. On the left side is the ... | |
| VLOOKUP | 11/30/2009 |
| Q: Is it possible to have a column dependent on the value of a cell rather than a fixed value? eg B3 = ... A: Liz, Yes it is possible to use cell values for any argument in the VLOOKUP function. The VLOOKUP ... | |
| Minutes formula | 11/19/2009 |
| Q: I am trying to divide minute and seconds. I have :00:30 (a value from a report meaning 30 seconds) ... A: Alex, The problem is that Excel doesn't recognize :00:30 as a time. It will however recognize ... | |
| assigning weights to dropdown list selection | 11/10/2009 |
| Q: I've been trying to a setup which will allow a user to chose from a multiple pick lists and assign a ... A: If I understand your request correctly, the VLOOKUP function is the one you need. Just paste the ... | |
| Password protect cell editing | 11/7/2009 |
| Q: Please look at this post before trying to answer my question. ... A: Thorsten, That is a functionality that is built into Excel. You don't mention which version of Excel ... | |
| IF (multiple match tests) THEN | 10/11/2009 |
| Q: I have 'inherited' a spreadsheet at work that includes this line in it : If DAT17 = "" And DAT18 ... A: VBA programming is a very literal language, so it is necessary to be this specific. If you need to ... | |
| Equivalent Networkdays | 10/4/2009 |
| Q: I'm rying to recreate networkdays. I got a code taken from internet but I have trouble including the ... A: Sanch, A couple of your lines have been commented out. As it stands now, your code will return the ... | |
| excell count function | 4/19/2009 |
| Q: I am trying to count how many times a "perm" staff member appears in a column but is either a "WM" ... A: Glyn, Sorry I clicked the wrong button. To do this you need to use an array function. Chip Pearson ... | |
| Cell Value Comparison | 4/6/2009 |
| Q: I need some help from you. I really wish and hope you can help me on this. This is solve a very big ... A: Sirajuddin, Good news. This will be a much easier project than you anticipate. It can be done with ... | |
| Row Hide MAcro | 4/4/2009 |
| Q: I got the following macro from the net. What the macro does is to hide the rows in which column A is ... A: Ann, The following will do what you need. Sub Hide() Dim i As Integer Dim j As Integer For ... | |
| excel and email addresses | 4/1/2009 |
| Q: How do I stop excel from automatically recognizing email addresses and making them into a live link. ... A: Edwin, You didn't mention what version of Excel you are using. The steps will be slightly different ... | |
| Workbook reference | 12/20/2008 |
| Q: I am trying to modify a section in a macro below. Currently "SWS" is set to thisworkbook. I want ... A: Dave, As long as the "Data Update" workbook is open just change the Set SWS line to refer to the ... | |
| Interpolating the data | 12/16/2008 |
| Q: Data to processed: 2 columns(A,B). Number of Rows = 1761 Column A = {0,1,2,....,1760} Column B = ... A: Chetan, There are two ways to do this fairly easily. Both methods use the built in TREND function. ... | |
| Sum a Qty based on date range in another colum | 8/20/2008 |
| Q: I have a worksheet of data I need to sum based on a monthly date range criteria onto a separate ... A: Ilene, This can be done, but you need to use an Array Formula to do it. Chip Pearson has a great ... | |
| XL formula | 8/19/2008 |
| Q: I have an XL spreadsheet for work which has different worksheets within it. One worksheet (worksheet ... A: Deborah, Yes there is a function that will do what you need. It is the VLOOKUP function. Assuming ... | |
| Sheet Protection | 6/2/2008 |
| Q: Chad I have different databases with certain worksheets available to other users. Is it possible ... A: John, Yes it is possible. While the sheet is unprotected, right click on the cell(s) that you would ... | |
| Excel pull down list | 4/11/2008 |
| Q: How can I allow a pull down list to jump to areas of the alphabet. If I have a large pull down list ... A: Sharon, There are two types of pull down lists (or combo boxes) in Excel. If you use the combo box ... | |
| User Input | 2/19/2008 |
| Q: I am really new to VBA. I want to create a program in Excel where a form asks a user for a file ... A: Dave, The GetOpenFilename method will do exactly what you need. It uses the open file dialog box to ... | |
| VBA Web Query - Overwrite Existing Data | 2/4/2008 |
| Q: I'm developing a dynamic web query in Excel 2003. The code is as follows: Private Sub ... A: Joe, Each time the sheet is activated a new query is added. For whatever reason, the default action ... | |
| offset | 1/8/2008 |
| Q: I have a spread sheet on excel 2003. In this spread sheet I have 8 colums. I decided to put a user ... A: Hari, Is there a column that will always be filled? If column B will always be filled then you can ... | |
| Match & Offset Function | 11/20/2007 |
| Q: Trying to us a combination of Match and then Offset. Multiple columns of data, and using column A ... A: Grant, The OFFSET formula requires 3 arguments in this instance. The first is a reference, second ... | |
| need advice on VBA nested IF Function for range senario | 10/4/2007 |
| Q: I'm building my own company payroll. In our country, we provide insurance contribution for the staff ... A: Anson, You need to reverse the order of your if statements. Suppose an employee makes $2210, the ... | |
| Excel Percentage | 10/3/2007 |
| Q: I am creating a table for stock and i need to work out percentage discount: These are the column ... A: Becky, The final price is the same as 100 minus the discount percent, so instead of multiplying by ... | |
| vb code for simple input in Excel | 9/30/2007 |
| Q: I am trying to get a very simple data entry macro to work without a great deal of success. I want ... A: Brendan, Your code is getting very close. I just cleaned it up a little. The following should work ... | |
| forms | 9/25/2007 |
| Q: How are you doing? I just have a quick question to ask you, if I have two or more forms and if I ... A: Ken, It sounds like the first form is being Unloaded when opening the new form. If you can hide the ... | |
| if cell contains numeric data - Formula | 9/24/2007 |
| Q: I have created a simple weekly timesheet for internal use in my office and tried applying some ... A: Sandra, I wish that Microsoft would make working with text easier in Excel. It can be done, but it ... | |
| listbox | 9/21/2007 |
| Q: How are you doing? I got a problem about listbox and hope that you can help me out here. I have two ... A: Ken, VBA doesn't have an event for when a listbox is scrolled. The closest that you can do is use ... | |
| WorkSheets | 9/18/2007 |
| Q: How are you doing? Sorry to bother you but I have a question to ask you. Is there a way that I can ... A: Ken, If you protect the worksheet by Clicking on the Tools menu, selecting Protection and then ... | |
| Please help with time formating and IF function | 9/18/2007 |
| Q: Ok I have use this now. It seems to be fine, but it has created further problems. I have a slight ... A: James, In your first example you use column numbers 1, 2, 3 & 4, but then when you show the formulas ... | |
| How to select new sheet | 8/31/2007 |
| Q: I'm working in doing a macros where I am going to create several new sheets everytime it runs, then ... A: Pedro, Good job on getting this far. It is a lot more than most people are able to do. You mention ... | |
| vb formula | 8/29/2007 |
| Q: Do you know why it gives me an error everything I try to run this code: Cells(28, 5) = ... A: Ken, The type mismatch is because of the SumProduct command. It can't be used with the application ... | |
| Combining Cells in Excel | 8/22/2007 |
| Q: I work in Excel all day long, and even this one has me stumped. It sounds like something ... A: Jessica, There probably isn't a simple formula that will do what you need, but it can be done with a ... | |
| vba problem | 8/20/2007 |
| Q: i want to build connectivity between my excel worksheet and the userform that i have created. the ... A: Nikhil, The code works just fine if the names in your code match the names on you form. You mention ... | |
| Copy text from mutiple cells, randomly to one cell. | 5/1/2007 |
| Q: I have a daily safety tip, "text." in cells A1 thru A100. I want to have the text printed in cell ... A: Mount, That is an interesting question and a clever idea. One that I haven't seen before. The ... | |
| bipassing security settings | 1/30/2007 |
| Q: I have upgraded from Excel 2000 to Excel 2003. We have a startup macro that needs to run everytime ... A: Cheryl, There may be a couple of reasons why your Excel keeps reverting to high security. The most ... | |
| Excel function help | 1/25/2007 |
| Q: I am trying to sort of complete a find and replace function. However, I would like the information ... A: Lena, This can be done using a formula. In a cell in the adjacent column (where you want the ... | |
| Synchronize Controls on UserForms | 1/24/2007 |
| Q: My company is converting to a new financial system. We have change the format of our General Ledger ... A: Frank, ComboBoxes (as well as ListBoxes if you decide to switch) have a property called ListIndex ... | |
| VBA problem | 1/23/2007 |
| Q: Good Afternoon Expert Can you take a look at this. No matter what I try, the name will not go into ... A: Todd, If you remove the following line the procedure should work for you: Case "password", ... | |
| Excel combinations | 1/23/2007 |
| Q: Chad, In a response to a posting in 2004 regarding total 3 digit combinations of letters (A-Z) and ... A: Drew, You are right in noting that 1296 is 36x36. The right character is divided by 36^0 so that it ... | |
| User Form: Autofill text boxes based on Combo Box selection | 1/18/2007 |
| Q: I am having a bit of a problem trying to figure out how to apply the INDEX/MATCH function used in ... A: Jeff, This isn't too hard to do. ComboBoxes provide a list index beginning at 0 for each item. So ... | |
| Userform1 combobox to userform2 textbox | 1/12/2007 |
| Q: We are going through a system conversion for my company (with multiple subsidiaries) and we're ... A: Frank, The following procedures should do what you need. I've called the userform with the combobox ... | |
| Excel autofit question | 1/12/2007 |
| Q: I do have many Excel Worksheets with columns that may contain hundreed of thousands of characters. ... A: Hector, The following lines of code will expand every row and column in each worksheet of your ... | |
| Change font color to red depending on value | 1/11/2007 |
| Q: I would like to know how to change the font color to red in C1 if the values in B1 is < A1 A: Don, Conditional formatting will do what you need. 1. Select cell C1. 2. Click Conditional ... | |
| Transpose in excel | 1/10/2007 |
| Q: Hey. I am trying to transpose a large group of cells from 1 excel file to another. I found this on ... A: Robert, The first two steps in your example look good. However steps 3 and 4 seem to make the ... | |
| Set sheet to display first when opening excel | 1/10/2007 |
| Q: I have created an excel file with about 25 different sheets in it (this file is you for presentation ... A: Emma, This can be done with VBA using the following steps: 1. Select "Tools>Macro>Visual Basic ... | |
| VBA and Userforms | 1/9/2007 |
| Q: Chad - I asked this same question earlier but then read that you are experienced with VBA code, so I ... A: Jeff, This question is too long to try and answer with the limited resources of this site. If you ... | |
| Formula | 1/9/2007 |
| Q: HELP!! I have a spreadsheet whereby the the first tab records a set of data and the second tab draws ... A: Selena, You need to use an array formula. Your example isn't very specific so you will need to ... | |
| IF Functions | 1/8/2007 |
| Q: I am attempting to set up a function for a project I am doing at work. The project is set up to ... A: Mike, The problem is with the MATCH function. It returns an error if the lookup value isn't found ... | |
| Problem with array | 1/8/2007 |
| Q: Can I do three things like =SUM(IF((AF5:AF508<>0)+(AG5:AG508<>0)+(AH:AH508<>0),1,0)) or do I have ... A: Michael, You should be able to add as many conditions as necessary with a few exceptions. You ... | |
| Linking Excel Spreadsheets for Presentation | 1/8/2007 |
| Q: I started a new job that has a supervisor who is crazy about Excel - not so much on its mathematical ... A: Tyler, Homepages or Switchboards as they are often referred to in Excel are actually pretty easy to ... | |
| revised question | 1/7/2007 |
| Q: Chad, is it necessary to use the N function for this formula to work? And if so could you ... A: Daran, In this case it is necessary to use the N() function. By breaking the formula apart it may ... | |
| revised question | 1/6/2007 |
| Q: Date Number *These are used as named ranges 01/01/06 2 01/01/06 4 01/01/06 4 01/01/06 4 ... A: Daran, The following formula should work for you. In your question you have a named range 'date' ... | |
| loop through textboxes in a userform | 1/5/2007 |
| Q: Hey, in a userform i have 24 textboxes. the user has to fill in values. i'd like to retrieve the ... A: What you need is a control array. Visual Basic allows this, unfortunately Microsoft did not ... | |
| Problem with array | 1/5/2007 |
| Q: okay, well it works now. Not sure why. I think maybe it had something to do with it being shared. ... A: Now this formula is getting tricky. In logic math (which is what we are doing with this formula) ... | |
| VBA Insert formula instead of value | 1/4/2007 |
| Q: I am writing a macro to automate some calculations in an Excel spreadsheet. For instance, I would ... A: Greta, I don't know about the most elegant solution, but another option is to add a counter. Before ... | |
| Problem with array | 1/4/2007 |
| Q: This array does not work: =SUM((F5:F508="C")*(AF5:AF508<>0)*(AG5:AG508<>0)) Am I missing something? ... A: Michael, That formula works for me. The format looks exactly right. It will count each row where F ... | |
| VBA Insert formula instead of value | 1/4/2007 |
| Q: I am writing a macro to automate some calculations in an Excel spreadsheet. For instance, I would ... A: Greta, If I understand your question correctly you need to use the .Formula method in your VBA code. ... | |
| data manipulation | 1/3/2007 |
| Q: I know this may be simple, I need to combine column a and b in a data base (A is first names be is ... A: Tony, Left-click on the C at the top of the column then right-click on it and choose insert. You ... | |
| Conditional COUNTIF | 1/3/2007 |
| Q: Okay, one last question. Can you have it be true or 1 in Column D if only there is a number and ... A: Michael, Unfortunately, that isn't as easy. Dates are actually stored as numbers in Excel. Each ... | |
| Conditional COUNTIF | 1/2/2007 |
| Q: Can you have it be true or 1 in Column D if only there is a date? Like ... A: Michael, Yes it is possible. The easiest way is to use the DATE formula. The format is =DATE(Year, ... | |
| Conditional COUNTIF | 1/2/2007 |
| Q: I want to do =COUNTIF(D18:D508, ">1") but have it not count if the cells in the parallel column ... A: Rather than using a COUNTIF, you will need to use an array formula. To do it type (or copy) the ... | |
| Formula | 8/3/2006 |
| Q: Chad that fixed the forumla but returned FALSE - perhaps I am not using the right formula all ... A: Troy, That is odd. Are you sure that you typed the formula correctly. The IF formula should only ... | |
| Next visible row in autofiltered sheet - move down | 8/2/2006 |
| Q: Can you advise some VBA code to move the active cell directly downwards, staying in the same column, ... A: Martin, Excel doesn't have a direct way of going to the next non-hidden row. However, we can go to ... | |
| Print Different Ranges To Same Page | 6/10/2005 |
| Q: I am using Excel 2000. I have a series of ranges that I need to print all on the same page even ... A: There isn't a simple way to accomplish this. Excel can't print from multiple worksheets onto the ... | |
| new line character in an Excel cell | 6/10/2005 |
| Q: In Excel, to insert a new line character, you press the "enter" key + "Alt" key. But the same I ... A: Pressing Alt + Enter inserts what is called a Line Feed character. There are two ways to insert the ... | |
| Get Macro to run when a cell changes | 6/6/2005 |
| Q: Chad, How do I get a macro to run when the value of a cell changes in Excel 2000. Thanks, Mark A: I'll give you a general example and you can change it to fit your situation. To run a macro named ... | |
| Need VBA Help in Copying Range Values | 6/5/2005 |
| Q: I'm using Excel 2000 and am self-taught in using VBA, so I am still learning. I have written some ... A: The brackets [] are just shortcuts for VBA. They aren't 'official' code, but everyone uses them ... | |
| VBA Help to Create List of Excel Filenames | 6/4/2005 |
| Q: I am using Excel 2000. Could you please help me with VBA that would list all the Excel (XLS) file ... A: Ken, I wrote an article a couple of years ago that dealt with a similar situation. You can read it ... | |
| computer shut down, data not saved | 6/3/2005 |
| Q: My computer shut down and i was not able to save the data. when i started the computer again, i ... A: I'm sorry to say that any unsaved data is probably lost. Some versions of Excel do not save backup ... | |
| VBA not working as expected | 6/1/2005 |
| Q: Chad, I have not used VBA very much, but I am trying to use the following code to delete 4 ... A: Mark, For not using VBA very much that is a very nice piece of code. If the only shapes on the ... | |
| Excel Macros | 6/25/2004 |
| Q: Chad. I have made some Macros in Excel XP using the recording function - whereas some of these ... A: Vivek Atodaria, Select the following menu: Tools | Macro | Macros. In the box that opens select the ... | |
| EXCEL - arbitrary fill in | 6/7/2004 |
| Q: I followed your formula, but it works if there is one blank space at a time (i.e. on weekends, there ... A: Adeline, Did you copy the formula and paste it down the column? It should work. For example I type ... | |
| Time Macro | 6/7/2004 |
| Q: Excel 97. Dear Chad, I have a dde in cell on a sheet linked to the financial markets which updates ... A: Grant, I think that you are on the right track, but instead of using a pause inside of a loop, it ... | |
| Find a value and replace with corresponding title | 6/7/2004 |
| Q: Wondering if you help me on this small problem... Trying to find the largest value in a range per ... A: Edward, Assuming that the column headers are in A1, B1, C1 and D1, the formula in D2 (Longest Path) ... | |
| Excel formulas | 6/7/2004 |
| Q: I have developed a huge program using Excel that manages all scoring and handicapping for my ... A: Tracy, If I understand your question correctly you need to use absolute references. To do that add ... | |
| hi sir, i do not know alot... | 6/4/2004 |
| Q: i do not know alot about exel but i know how to use it to a certain extend. i have imported some ... A: sudha, This can be accomplished using a formula. A macro is not necessary. If your dates begin in ... | |
| macros | 5/31/2004 |
| Q: I played with a small macro in a workbook and then deleted the macro; no macros show up in the macro ... A: Tom, To clean up all of the junk that gets left behind after creating a macro do the following: - ... | |
| Concatenate or & function | 5/27/2004 |
| Q: I did try the INDIRECT function prior to my initial post and got the #REF error. There is no way to ... A: Rob, Rather than using a macro to copy and paste the values, use the macro to create a formula in ... | |
| Concatenate or & function | 5/27/2004 |
| Q: I am trying to link many files to one spreadsheet using three cells. For example: Cell A1: ... A: Rob, The Indirect function is what you are looking for: =INDIRECT(CONCATENATE(A1,A2,"!",A3)) This ... | |
| Determine if it's a hyphen | 5/26/2004 |
| Q: I'm using excel 2002 and would like to know how to write an expression to determine if a hyphen is ... A: tc, Slightly modifying your expression will return the desired results: ... | |
| EXCEL - arbitrary fill in | 5/24/2004 |
| Q: Premise: I am using Office XP i have 3 columns of data downloaded from bloomberg - col A contains ... A: adeline, Rather than copying and pasting the data from Column B use a formula. Assuming your data ... | |
| Excel VBA Current Region | 5/19/2004 |
| Q: In Worksheet 1, I have a title "Order Data" in cell L1, which I have spread over L1 thru N1. I have ... A: Bob, 1. To find the next empty row use the following statement: ... | |
| combinations of numbers | 5/18/2004 |
| Q: I am using Excel 2000. Here is my problem. I want to know all of the combinations of letters and ... A: Jill, Yes it can be done. However, the formula is rather ugly. To begin, place the following ... | |
| combinations of numbers | 5/18/2004 |
| Q: I am using Excel 2000. Here is my problem. I want to know all of the combinations of letters and ... A: Jill, This is more of a math problem than an Excel problem, but it's good to have some variety every ... | |
| Hiding formulas in Excel worksheets | 5/12/2004 |
| Q: If I have a worksheet full of formulas and I am going to send this worksheet to others but I don't ... A: Peter, Yes it can be done. Select the cells that you would like to protect. Then choose Cells from ... | |
| excel formula needed | 5/11/2004 |
| Q: i have a spreadsheet with a column containing : example: cod33211 without using 'text to column' ... A: Dutch, I can't think of a way to do it with the built in functions of Excel. However it can be done ... | |
| Excel VB | 5/6/2004 |
| Q: I regret to have to trouble you again but I was wondering if you can help me further. The following ... A: m.lock, Glad to here that it is coming along. To have it run automatically when the workbook is ... | |
| Excel VB | 5/5/2004 |
| Q: Am a beginner in Excel Vb and this this probably a stupid question but can you please tell me where ... A: m.lock, That depends on what you want to do with Application.OnTime. Usually it will go inside of a ... | |
| Macro | 4/30/2004 |
| Q: You've have been a great help. Thanks. I was thinking that if someone who is sharing my worksheet ... A: Royston, You can protect the VB code with a password as well. That way no one can see the code ... | |
| Simple Question on formulas | 4/29/2004 |
| Q: I need to find out the percentage of employees that make between $50K , $75K and $100k. I'm not ... A: TCVB, I'm going to assume that the employee names are in cells A2:A6 and the Compensation is in ... | |
| Macro | 4/29/2004 |
| Q: I have problems running macros with protected sheets or cells. Each time I hit the macro assigned ... A: Royston, You need to add 2 lines to your macro. Select the menu options: Tools>Macro>Macros. Find ... | |
| Excel 2000 | 4/27/2004 |
| Q: I am using a VLookup formula in my spreadsheet. Some of the cells are showing #N/A which is ... A: Adrienne, It can be done by nesting the function in an IF statement. For example: =IF(ISNA(<Your ... | |
| Complex formula | 4/25/2004 |
| Q: Good afternoon, Hoping you can help. Excel 2000 platform. I work as a consultant for a large ... A: Joe, That can be done with a user defined function. To create one do the following: 1. Press ... | |
| lost file | 4/23/2004 |
| Q: I am using Excel 97. I lost a file that is my senior research project... I had it on a floppy disk, ... A: Katie, Sorry to hear that you lost your work. This isn't a problem with Excel, so I'm not really ... | |
| Formatting hours and minutes | 4/19/2004 |
| Q: If the difference between two times (eg 20:00 and 08:00) is a -ve number, is there a way to display ... A: Peter, Unfortunately, Excel (and all Microsoft products) cannot handle negative times. However, I ... | |
| Excel Text Formula | 4/16/2004 |
| Q: I am trying to write a piece of VB or a formula that will enable me to extract a number from a text ... A: Neil, I can't think of a way to do it with the built in functions of Excel. However it can be done ... | |
| Formula question | 4/13/2004 |
| Q: List 2-South Month: ____________ 2004 Date Resident Name Site Stage N-AC AC AC2 III 1 x ... A: Unfortunately, when using this service extra spaces, coloring and column names are cut out, so I'm ... | |
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
Chad Welch
Top Expert on this page
Expertise
I am a heavy user of Excel and VBA. Unfortunately, I do not have the time to help you design a complex project. However, I am very happy to help troubleshoot problems you are encountering or provide direction with formulas or snippets of code.
Experience
I have created several complex spreadsheets for use in data collection/aggregation as well as scientific laboratory studies and procedures.
Organizations
Brainbench MVP for MS Excel.
Education/Credentials
AS - Computer Science (emphasis on programming)
BS - Chemistry
©2012 About.com, a part of The New York Times Company. All rights reserved.