You are here:
Excel/Questions Answered by Expert Ken Marron
| Subject | Date Asked |
| Excel formula | 2/12/2009 |
| Q: How do I phrase a formula to subtract a range of cells from one other cell? I want to subtract the ... A: No, you have it exactly right the formula =B8-SUM(B11:B22) is correct What may not be correct is ... | |
| Date Formula | 5/22/2008 |
| Q: Can you help? I have followed instructions, but seem to be still getting it wrong. I have a date, ... A: If your date is in cell A1 then the formula would be. =EOMONTH(A1,-6) Now EOMONTH formula is a ... | |
| Excel | 5/5/2008 |
| Q: Judging from your responses, you look like the right person to ask. What I actually am trying to ... A: Sure that's simple. If the text is in cell A1 just place this formula in a different cell. ... | |
| Sheet View | 5/2/2008 |
| Q: This is a simple question, I hope. On one Excel sheet I have an extra border across the top and ... A: It sounds like you have the "freeze panes" option going on, but I am not sure. To check for this go ... | |
| Sequential numbering | 3/9/2008 |
| Q: I am trying to make job cards for my manufacturing business using excell my question is, I want to ... A: That should mean that the worksheet is not named JobNumber can you double check that you renamed ... | |
| Allocations | 3/8/2008 |
| Q: I have to allocate by store for the promotion we run each month..So for item X, I have several ... A: You can use an IF Statement to evaluate whether the value returned will be a negative number. ... | |
| need an "if" formula | 3/8/2008 |
| Q: i need to compare a cell to a range of cells and when it agrees to a cell to return the value of the ... A: What will work for this is the VLOOKUP function. If the following are true Fred is in cell A1 Andy ... | |
| Sequential numbering | 3/7/2008 |
| Q: I am trying to make job cards for my manufacturing business using excell my question is, I want to ... A: It requires the use of VBA programming. I have modified a macro that I found online at the ... | |
| Hidden Password | 3/7/2008 |
| Q: I know a man that worked in the pentagon, and he claims that steve jobs hid the "master" password to ... A: I have never heard that story before. But I am sure it is not true. First why would Steve Jobs hide ... | |
| Excel 2003 New File | 3/6/2008 |
| Q: Whenever I create a new spreadsheet, the file opens on Sheet 2, rather then the normal Sheet 1. Not ... A: I am not aware of an option to open on Sheet2 when opening a workbook. I think you may have a ... | |
| Tabs within tabs | 3/4/2008 |
| Q: I would like to have two layers of tabs, so that clicking on one tab will open up the next layer of ... A: I am not an expert in Visual Basic. But I know you can use a Userform and age multipage tabs to do ... | |
| excel | 2/29/2008 |
| Q: I have 50 sheets of reports in one work sheet.I want one sheet as master their (sl no) (report ... A: This requires Visual Basic Programming. It is difficult to give you this in an email. If you want to ... | |
| Identifying Cell Address | 2/27/2008 |
| Q: I have a 9 x 9 range of numbers. I know I can find the maximum number with the function Max(A1:I9). ... A: You can use a VBA Macro to do this. You would copy the following macro then open your workbook and ... | |
| Clear the Contents. | 2/25/2008 |
| Q: If i return the text {"Free"} content in C2, then i need to clear the contents in D2:G2. If ... A: Select the worksheet that you want the macro to apply to and the press Alt+F11 and then copy and ... | |
| Attendance and excel | 2/24/2008 |
| Q: I'm running an in-school event and plan on selling tickets and taking attendance at the event. I ... A: You can use a filter for this. You need to have a row at the top of the columns with headings for ... | |
| default settings and cell formatting | 2/14/2008 |
| Q: Ken, I'm working in Win. XP with MS Office 2003. I created a spreadsheet, used formulae to add ... A: You can select the worksheet that you would like to have 2 decimal places and then press the "Select ... | |
| Excel Formula | 2/13/2008 |
| Q: Here's the formula I need help with. Let's say I have ColumnA and ColumnB. I need a formula to ... A: If you have a number in cell A1 and a number in cell B1, in cell C1 you could place a formula like ... | |
| Formula | 2/13/2008 |
| Q: I have a database that records credit note details paid into our company. In column 'U' values are ... A: If you values are in column U and your dates are in column X You can place a start date in cell Y1 ... | |
| Calculating Excel | 2/12/2008 |
| Q: In Excel I would like to create a file for my checking account and put in the Deposits and Deduct ... A: It is kind of like that old saying "don't reinvent the wheel" because there are many Excel ... | |
| Spreadsheet Formulas and/or Pivot Tables | 2/11/2008 |
| Q: I work for a construction company and trying to put a spreadsheet together that will show me # of ... A: Sure, you can send the spreadsheet to cloverken@yahoo.com please put Excel in the subject line. and ... | |
| default settings and cell formatting | 2/9/2008 |
| Q: Ken, I'm working in Win. XP with MS Office 2003. I created a spreadsheet, used formulae to add ... A: It sounds like you have selected the "Fixed decimal" option within Excel. To check for this open ... | |
| Time Cards | 1/17/2008 |
| Q: If an employee work the following days and hours, ho do I convert minutes to hours? Mon - 7:00 - ... A: I think it is just a misunderstanding of time in Excel. Your first Line Mon - 7:00 - 4:54=9.53 is ... | |
| Date in Excel | 1/16/2008 |
| Q: i asked you before about a formula for dates in excel, i am still working on a chart for my parents ... A: You can use the following formula. =EDATE(B2,I3-1) You need to remember to format the cell where ... | |
| Excel formatting | 1/15/2008 |
| Q: When entering dates into excel, they appear as a 5 digit number that seems to bare no relation to ... A: You are correct to try to format the cell. A current date is stored in Excel as a 5 digit number. So ... | |
| Help...Formula needed | 1/14/2008 |
| Q: ..I have a spread sheet that I need a formula for. The spread sheet is an expense spread sheet and ... A: Sure you can send a spreadsheet to me at cloverken@yahoo.com It sounds like you could use a ... | |
| excel to caculate a date | 1/13/2008 |
| Q: i am trying to set up a program to keep track & order my parents many medications. is there a way to ... A: Yes you can do this in Excel. If you simply want to add months to an existing date such as today ... | |
| excel formula problems | 1/11/2008 |
| Q: I'm having problems writing a couple of formulas in Excel 2003. Simply put, I need a way of ... A: Sure that would help explain a lot if you can send me the spreadsheet. You can send it to ... | |
| Formula | 1/11/2008 |
| Q: I want to create a formula in column next to cell. If that cell equals 1000, then I want the cell ... A: If the value you are evaluating is in cell A1 then the formula that you can place in cell B1 would ... | |
| Alternate lists for different values | 1/3/2008 |
| Q: Basically I'm creating an archive of newspaper features on the arts. I have a dropdown list giving ... A: Tá fáilte romhat! Yes definitely email it to me and I will fix it up for you. Slán go fóill! Ken | |
| excel formula | 1/2/2008 |
| Q: I am trying to edit an existing schedule sheet for my employees, I need to put in a cell, if "OFF" ... A: It sounds like your worksheet is protected. You can go to the Excel menu and select "Tools" then ... | |
| cell fill colors | 12/31/2007 |
| Q: I need to fill cells with various colors based on the value appearing within the cell. If the pct ... A: Yes, This is perfect for "Conditional Formatting". Select the cells you wish to have formatted this ... | |
| Excel Spreadsheet | 12/29/2007 |
| Q: How do I convert Time (8:30) to decimal (8.5)? A: If 8:30:00 AM is in cell A1 you can place this formula in cell B1. =A1*24 Now select cell B1 and ... | |
| Excel qn...may b easy 4 u.. | 12/28/2007 |
| Q: . I have a database in very complex format.It is pasted in one column.List contains name & addresses ... A: Your question implied that you want to change the all uppercase company name to proper case. Here is ... | |
| IF statement | 12/26/2007 |
| Q: I can't recall how to do this function. I am using Excell for a budgeting system and in one cell ... A: One of the issues with having Excel use an IF statement to check for an error, is that Excel likes ... | |
| Cell Reference | 12/21/2007 |
| Q: I have a column of 2000 values, A1:A2000. In cell C1 I want to create a formula that sums A1:A24 ... A: cell C1 would be the following formula. =SUM(A1:A24) cell C2 would be the following formula. ... | |
| Pulling Information from one Excel worksheet to another | 12/21/2007 |
| Q: I am trying to perform the following with Excel. I am not Excel savvy at all. Here it goes: I ... A: Can you send me an example workbook? You can even send me your exact workbook but just have sample ... | |
| EXCEL 2003 | 12/18/2007 |
| Q: Where can I find a databas or list of Excel formulas and macros? A: I really haven't found one database of information on Excel formulas or macros. But here are several ... | |
| Calculate deadlines, skipping weekends? | 12/17/2007 |
| Q: I'm trying to create a tool that will calculate all the interim deadlines for a project when the ... A: What you need is a couple of IF statements along with the WEEKDAY function to evaluate whether the ... | |
| Sorting in Excell 2002 | 12/16/2007 |
| Q: I have a movie list with title in column 1, a subtitle in column 2, the year in column 3 and genre ... A: You will need to first select the entire selection of data in columns 1-4 and down however many ... | |
| Wildcard in IF function | 12/13/2007 |
| Q: I am creating a spreadsheet to automate NBA scores and averages. The problem I am having is that ... A: If you have a cell that will either start with a @ sign or not then you could use a formula like ... | |
| excel formula | 12/9/2007 |
| Q: I'm working with someone else's spreadsheet and it has a formula I don't understand. Can you tell ... A: This is an IF function. The basic IF Function works this way. ... | |
| Finding and Deleting a character | 12/7/2007 |
| Q: I need to delete all commas in a particular column. Instead of having to manually doing this - I ... A: Click on the Column that has the commas. To select an entire column you would click on the letter of ... | |
| Looping IF logical tests | 12/4/2007 |
| Q: I can write a logical test to say if cell A3 = nothing then use value in cell A2 however I would ... A: When you link multiple IF's Excel calls it "nesting" IF's. With Excel 2003 and previous versions you ... | |
| excel 2003 remove text strings of various lengths between 2 specified characters | 12/2/2007 |
| Q: Novice in Excel functions, I have spent the better part of the day in reference book and on internet ... A: If 2003 Ford F150 w/ engine, 4x4 (2002) was placed in cell A1 and then you place the following ... | |
| Macro Excel 2007 | 11/28/2007 |
| Q: I am doing a conversion manual for 2003->2007. Stuck with inserting a wordart, picture or shape via ... A: I know I also ran into this problem converting from 2003 to 2007. One thing I would check is with ... | |
| Sheets Tabs | 11/22/2007 |
| Q: Ken, how would I go about sorting the "sheet tabs" according to date? All tabs are given a date ... A: There are sort Macros out on the internet such as this one. Sub QuickSortSheets(Optional SortOrder) ... | |
| Identifying conditional formatted background - by VB | 11/21/2007 |
| Q: I saw your kind advices in the AllExpert site and hope you can assist me with the following: A ... A: You can use the following User Defined Function to find the number of the colored text, or colored ... | |
| Excel Formula Question | 11/19/2007 |
| Q: I have tried to come up with a formula for my problem but I still cannot devise anything that works. ... A: If you place List1 in cells A1:A6 and List2 in cells B1:B5 you can place the following formula in ... | |
| If statements | 11/18/2007 |
| Q: im trying to create a protype, and i would like to make a if statement to select the month of the ... A: Just to let you know that with Excel 2007 you can have up to 64 nested Ifs. With previous Excel ... | |
| not sure what to call it... | 11/17/2007 |
| Q: Is there a way to build a formula that says "if the value in A1 is "a" then sum B1 and C1: if the ... A: It is called an IF statement, and when you have multiple IF's Excel calls it a nested IF statement. ... | |
| Set Go to Cell Reference in Button | 9/11/2007 |
| Q: Can Set Go To - Cell Reference (E.g. A10) in a Button? I mean Suppose we have inserted Button. It is ... A: If you have selected a button from the "Forms" toolbar. You will need a Macro like this. When the ... | |
| Excel data validation | 8/26/2007 |
| Q: I wish to modify a spreadsheet I use at work to limit the totals. Taking one column, for example, I ... A: You would select cells B10:B25 and while holding the "Ctrl" key also select B200:B400. Then go to ... | |
| Finding a cell associated to a selection from a drop-down | 8/23/2007 |
| Q: Can you assign a cell address to a variable that can be referenced later? i.e. set "size"=$D$8 to ... A: Yes, Naming a cell or a range of cells is a very powerful tool used by Excel. It is really simple as ... | |
| Extracting values from an array based on a list | 8/20/2007 |
| Q: I'm a novice with excel. Each month I get an excel sheet with a list of companies in column A, ... A: What really works well for this is one of Excel most powerful tools. It is the PivtoTable Report. ... | |
| COMPLICATED EXCEL FORMULA | 8/19/2007 |
| Q: EXCEL: I’ve searched everywhere to figure this out and would greatly appreciate it if this could be ... A: I think I would use and IF OR statement like this. =IF(OR('MONTH TO DATE'!AH4=29,'MONTH TO ... | |
| capturing high/low values in a cell | 8/18/2007 |
| Q: I am feeding a dynamic currency rate into an excel cell using DDE link. In the two adjacent cells, I ... A: I found this on Google Groups and it was written by Stephen Bullen Microsoft MVP - Excel You can ... | |
| Excel formula problem | 8/13/2007 |
| Q: I need to create a formula which enables me to calculate my wages from the time i start work to the ... A: The formula would be. =(B1-A1)*24*C1 Most Time formulas in Excel either need to be multiplied by ... | |
| Conditional formatting in Excel 2000. | 8/11/2007 |
| Q: I am having trouble with conditional formatting in Excel 2000. One column will contain dates. I am ... A: Add another formula condition with the following formula adjust the cell A1 to the actual cell you ... | |
| Excel - Formulas and Colours | 8/10/2007 |
| Q: I am currently using a VERY basic worksheet to keep a track of my small business' accounts payable. ... A: You would need a UDF or User-Defined Function. Here is how to do it. First you need to know the ... | |
| vlookup not working | 8/9/2007 |
| Q: I have a vlookup function that isn't working. I know that the function is correct, it's that the ... A: The most likely answer is the cell that contains the formula is formatted as "Text". To check this. ... | |
| tabs in xl | 8/1/2007 |
| Q: I have a presentation to give and it contains a few XL sheets a couple of word documents and a ... A: You can embed word docs and Powerpoint presentations into Excel. These will be static but working ... | |
| coping formulas through a wookbook | 7/29/2007 |
| Q: I have a 31 sheet workbook that I need to have each sheet reference the sheet before it. Is there a ... A: If it is one formula per sheet you can simply select the cell you want the formula in let us say in ... | |
| What is the problem? | 7/25/2007 |
| Q: this formula did not get the right result What is the problem? A B C ... A: You were very close with your formula. What you need to use is the "AND" function to combine the ... | |
| external formula or add-in, is it possible? | 7/22/2007 |
| Q: My boss uses a table to basically show quantities for certain tasks. Each task cost so much money, ... A: Yes you can hide the formula by following the directions on this website. ... | |
| external formula or add-in, is it possible? | 7/21/2007 |
| Q: My boss uses a table to basically show quantities for certain tasks. Each task cost so much money, ... A: What you can do is hide the formulas. It is much easier to follow along with the following website ... | |
| Cell changes color based on Sum | 7/19/2007 |
| Q: Can I use the "Conditional Formatting" to change the color of a cell based on the total of sum. For ... A: Yes you can use Conditional Formatting to do this. Select cell A13 and then go to the Excel menu ... | |
| Countif Formula | 7/17/2007 |
| Q: Ken, I have to manage around 1200 technical publications.I have them listed in column "a" on a ... A: Yes it looks like the numbers being downloaded are not being recognized as numbers. Sometimes you ... | |
| Excel - less then Zero Sums | 7/16/2007 |
| Q: I want to have a formula that calculates a total (this I have done) but if that total equals a ... A: The formula would be this to return a zero. =IF('Plan Rebates'!B2+Handsets!C3<0,0,'Plan ... | |
| Rules for Purchase Orders | 7/12/2007 |
| Q: I am trying to build a spreadsheet with several difficulties. First, I want the person inputing data ... A: I am know some VBA but not an expert in VBA. But you will need a Select Case statement like the ... | |
| Excel Sheet 1 to Sheet 2 | 7/10/2007 |
| Q: I am trying to get values/names from "Sheet 2" to arrive in to specified cells in "Sheet 1". I have ... A: If you want to return a value from Sheet2 to Sheet1. Select Sheet1 and a specific cell such as cell ... | |
| Excel | 7/4/2007 |
| Q: "I was sent information on an Excel spreadsheet that used Excel 2003, via email. I have Windows XP ... A: I apologize for the delay, I went on vacation and forgot to answer my emails. You can download a ... | |
| column format | 7/2/2007 |
| Q: I keep a coin catalog on excel. Some of the dates includes letters in addition to the numbers. ... A: I apologize for the delay. I went on vacation and forgot to check my email for messages until now. ... | |
| Tiered Formula for Excel | 6/30/2007 |
| Q: I need some help with creating an excel formula for tiered bonuses. My IF statement knowledge is ... A: I apologize for the delay. I went on vacation and forgot to check my email. Here is the Nested If ... | |
| sound in excel | 6/29/2007 |
| Q: I somply want excel to emit an audible "beep" when new data is entered into a cell. I am using ... A: Open Excel, press Alt+F11 to open Visual Basic Editor Paste the following Macro in the right-side ... | |
| search for value and sumif | 6/27/2007 |
| Q: I have two columns, one with names (column A) and the other with hours (column B). I want to add up ... A: If you have names in column A hours in column B cell C1 will be your input cell for the first few ... | |
| Taking filename from a worksheet | 6/26/2007 |
| Q: I generate simple invoices in excel and manually enter an invoice number in one cell. It is always ... A: Open your invoice workbook and press Alt+F11 to open the Visual Basic Editor. Paste the following ... | |
| Combining Values | 6/17/2007 |
| Q: hopefully, answer my question. I do sales analysis and forecasting in the music industry. I have a ... A: Here you go. ... | |
| Combining Values | 6/16/2007 |
| Q: hopefully, answer my question. I do sales analysis and forecasting in the music industry. I have a ... A: If you want the zero in front of the month number such as ARTISTTITLE06162007 then it would require ... | |
| Calculating Dates with Durations | 6/15/2007 |
| Q: I would like to generate an end date by adding together a start date and a duration. The adding is ... A: You can use the following formula. =WORKDAY(A1,B1,C1:C15) If you place the above formula in cell ... | |
| LEFT()*RIGHT() | 6/12/2007 |
| Q: One cell (C10) equals "4x4". This is a system size of 4' x 4'. I want to multiply 4*4 to get an ... A: You can use the following formula to multiply the numbers before and after the "x". ... | |
| Conditional formatting | 6/11/2007 |
| Q: I would like the background (pattern) color change according to the value in one cell. It is for ... A: Sure, I understand what you mean. Let's do an example. Select Cell B1. Then go to the Excel menu ... | |
| Excel: Clearing Validation Boxes on Form | 6/4/2007 |
| Q: I create forms with lines upon which there are Validation Boxes for the user to make selections ... A: If you want to clear the selections from the In-cell Drop-down Validations you can use ClearContents ... | |
| Similar Excel question | 5/15/2007 |
| Q: I have a spreadsheet that I keep a column of dates on. I would like for the cells to change to ... A: Select the first cell in the column that you would like to turn yellow if older than two years. I ... | |
| Number format discipline | 5/14/2007 |
| Q: Our company has long had problems with users setting up part numbers indiscriminately. Marketing and ... A: You can use Data Validation. It would work great if you have an established parts list. What you ... | |
| subaverages | 5/11/2007 |
| Q: I have a problem with finding a simple formula (probably IF function) for calculating subaverages in ... A: Ah yes Leiden the city of rivers. You can use SUMIF for this. If you have the dates in column A ... | |
| Excel dates in cells | 5/10/2007 |
| Q: Hopefully this is an easy question! I am trying to key dates in the cells and it automatically ... A: Select the cell that you are typing the date in. Go to the Excel menu and select "Format" then ... | |
| making a date change color ... | 5/9/2007 |
| Q: . I have a spread sheet with a bunch of dates in several cells. I want the date to change colors ... A: I will assume that the cell1 is located in cell A1 and cell2 is located in cell B1 and cell3 is ... | |
| Shade Cell | 5/8/2007 |
| Q: How do I make a formula that if the sum of a cell < 0 the cell will gray out automatically? A: You can use Conditional Formatting for this. Select the cell that you want to evaluate. Then go to ... | |
| making a date change color ... | 5/8/2007 |
| Q: . I have a spread sheet with a bunch of dates in several cells. I want the date to change colors ... A: Yes you can with Conditional Formatting. To do this select a cell with a date in it that you want ... | |
| Excel 2000 | 4/27/2007 |
| Q: Looking to key into a cell a certain code or filename that automatically inserts a graphic. I ... A: You might try a couple of different ways. First is to use Hyperlinks. If you use cell A1 to type ... | |
| convert horizontal to vertical | 4/24/2007 |
| Q: Is is possible to copy horizontal cells and past them as vertical cells? A: Yes you would select the horizontal cells and then while hovering over the selection right-click ... | |
| Need to reference value of another cell which is determined based on value of a different cell | 4/20/2007 |
| Q: I have a Wrapup worksheet in my excel file and an Inventory worksheet. The inventory worksheet ... A: Certainly! You can use VLOOKUP Function. I will pretend that you have a sheet names "Inventory" ... | |
| Ctrl-Enter (?) to go to next line in a cell | 4/20/2007 |
| Q: Do you know how to force a new line in a single cell in Excel. In a table in Word you can hit ... A: To force a new line in a single cell use Alt+Enter. Excel does not have an automatic bulleted or ... | |
| getting a cell to flash or blink | 4/19/2007 |
| Q: I am working on a spreadsheet and would like to have a cell blink or flash if an error condition ... A: The only way to do this is with VBA. But with VBA as far as I know it will not run in the background ... | |
| copying column without formula | 4/18/2007 |
| Q: i have asked you questions before, just have another simple (i think) question. i have 3 columns, ... A: Yes you can do this. Select the cell or cells you want to copy in column 3, hover your mouse ... | |
| Excel Subtraction Formula | 4/17/2007 |
| Q: Ok... here we go. What I need to know is the formula for subtracting in a whole column. Someone owes ... A: If you have the amount owed in cell A1 and the payments in cells A2:A12 you can put this formula in ... | |
| Convert Rows values in Columns | 4/16/2007 |
| Q: I am Dhaval Shah. I have excel sheet in this format. part Quarters Qty 1 Qarter1 3 1 ... A: You can use a PivotTable Report. Here's how to do that. What you need to do is select the full ... | |
| multiple tabs | 4/13/2007 |
| Q: I have a spread sheet that has 25 tabs. Is there any way that I could list all of the tabs and make ... A: Yes you can. You can use Hyperlinks to navigate between worksheets. Here is the basic way to do ... | |
| carry over data to next sheet | 4/12/2007 |
| Q: i tried your instructions for side by side sheets & it works great ! thanks again. we now have ... A: I wasn't quite clear on what you need. Is there a chance that you can send me an example? What ... | |
| side by side | 4/11/2007 |
| Q: i have an excel spreadsheet with info on 2 sheets. is there a way to view sheet 1 next to sheet 2. ... A: Yes there is. Here is how to do that. The best way is to only have this one workbook open in Excel. ... | |
| formula to sort items | 4/10/2007 |
| Q: I've been working(with little sucess)on sorting & summing items on a bid list based on text.In ... A: Is there a chance you can send me an example workbook? I was a little confused by your question. If ... | |
| Excel | 4/6/2007 |
| Q: I have a formula in consecutive cells that contains the date for each consecutive day of the month. ... A: Normally when you drag a date down the page it will continue the dates day after day. I think I ... | |
| If cell A1 = the string A+, then put a value of 15 in B1. If A1 = A put a value of 14 in B1. | 4/5/2007 |
| Q: In Excel, basically I have 26 Objects, rated in 6 categories from F- to A+. There are 15 ... A: You function works fine, the problem comes in when you try and accomplish more than 7 If statements. ... | |
| Conditional formatting with increment | 4/4/2007 |
| Q: I would like to format cells to have red text if the value in ex. C1 does not = the value in A1. ... A: Here is how to do that. Select cells C1:C300. Go to Excel menu and select "Format" then ... | |
| excel problem | 4/4/2007 |
| Q: one of the user trying to work on exel but automatically the sheet is goes on selecting each and ... A: I have ran into many computer problems at my work. It sounds more like a keyboard problem than an ... | |
| EXCEL SPREADSHEET | 3/30/2007 |
| Q: I know you didn't answer but expert is maxed out. I received this answer but where is LI? I am new ... A: I believe this formula would give you the result you are looking for. I think the expert might have ... | |
| short cut to FIll color | 3/29/2007 |
| Q: i just wish to know is there any shortcut key for fill color operation this will help in completing ... A: I do not know of a specific shortcut key for fill color. But here is what you can do. On the Excel ... | |
| Excel 2000 If/Then formula | 3/28/2007 |
| Q: I am trying to write a formula that involves hours and wages. I need to write a formula that will ... A: Yes you can. Let us assume that cell A1 contains the amount of hours worked. cell B1 contains the ... | |
| Excel day/month/year disable | 3/28/2007 |
| Q: I do construction bids,and a great deal of this is lumber. Lumber is often listed as fractions with ... A: I also do construction bids with lumber everyday and know exactly what you are talking about. If ... | |
| Validation Data and drop down lists | 3/27/2007 |
| Q: Ken, If I use drop down lists to validate my data, is there a way to enter the beginning letter(s) ... A: With Data Validation there is not a way to type the first letter of a part code and list all the ... | |
| Adding text to conditional formatting | 3/26/2007 |
| Q: I have uploaded my Excel spreadsheet for you to peek at ... A: It is possible to sort by color, Unfortunately sorting Conditionally formatted cells gets ... | |
| excel command buttons | 3/22/2007 |
| Q: I have been able to add a command button to an excel worksheet with the simple formula Set myRange ... A: You can try something like this. Private Sub CommandButton1_Click() Set myRange = ... | |
| Static a formula cell | 3/14/2007 |
| Q: Good day and I need your guide, STANDARD COPYS the formula ========================== Original ... A: The formula in cell C1 would be. =A1+$B$1 The dollar sign $ changes the formula from what Excel ... | |
| Excel formula | 3/9/2007 |
| Q: I need help with a problem. I am trying to say If Cell A1 = "A" then Cell C1 = $0.00 or If Cell A1 = ... A: Thanks Ken | |
| IF formula | 3/6/2007 |
| Q: Could you please tell me why my formula does not work? ... A: Sorry it took a while. I finally had to go to www.mrexcel.com to get help myself. The following ... | |
| re: help with excel formula and computation | 3/5/2007 |
| Q: I am a kindergarten teacher inthe Philippines. I have a formula =sum(c7/c4) *d3+e3 to get the ... A: You can simplify the formula to =C7/C4*D3+E3 I would probably need to see the worksheet to find ... | |
| formula question | 2/28/2007 |
| Q: I am trying to average several cells, they are not in consecutive order (ex. F3,J3,N3,R3etc.)I dont ... A: This is not an array formula and it will work for noncontiguous cells when you want to ignore the ... | |
| Merged cell trouble | 2/23/2007 |
| Q: I am having trouble with text in a merged cell not wrapping properly. The text is coming from an ... A: It sounds like you are running into Excels limits. Excel 2003 and lower versions has a cell ... | |
| Excel for Macintosh | 2/11/2007 |
| Q: How do I delete - send to trash - an entire workbook in Excel for Macintosh? A: I am sorry I have never used a Macintosh. On a PC I do not even use Excel to delete a file. I use ... | |
| Excel Question | 2/10/2007 |
| Q: I have 2 columns that contain information and I would like to take the cell to the left, and move ... A: You can use the ampersand & for this. If you have an address number in cell A1 and the street ... | |
| Excel scale | 2/9/2007 |
| Q: I am trying to print a spreadsheet in Excel. I have it set to print landscape and scaling adjust to ... A: It is so difficult to know without seeing it myself. I have one guess though. Under "Page setup" ... | |
| excel 2000 question | 2/9/2007 |
| Q: After entering 178 dates in a column of cells formatted for date (3/14/1998) , I enter ... A: 1/0/1900 is the what you would get if you entered a zero in a cell and formatted it as a date. Excel ... | |
| Summary Field for Last Entry Recorded in a Column Range | 2/7/2007 |
| Q: I have created a worksheet for recording leave time and accruals for individual employees. The ... A: You can use the MAX function. such as =MAX(H2:H27) This will only return the maximum number from ... | |
| Excel 2000 | 2/7/2007 |
| Q: I'm trying to create a Macro that will unprotect all password protected worksheets (without ... A: Open your workbook with password protection that you want to add the Macro to and press Alt+F11 to ... | |
| reduce column width | 2/6/2007 |
| Q: --I'm trying to reduce the column width-but get the message,'can't move objects off the ... A: I am not quite sure what that is but it possibly might have to do with comments. Do you have any ... | |
| formula help | 2/6/2007 |
| Q: what the formula is meant to be doing is if the value is smaller or equal to the offset value (which ... A: Yes the Open Parenthesis ( before the word "offset" and the close Parenthesis ) after the word ... | |
| thisshould be a simple question replace a value when it | 2/3/2007 |
| Q: is not what I want. I wrote this if statement : =IF(A14=" Please remove", Sheet5!A14,A14), it means ... A: There are a few things I am not sure about. For example I believe you are trying to type on Sheet1 ... | |
| auto move amount from one cell to next. | 2/1/2007 |
| Q: Got busy. Just to let you know when you go to www.squish.com/cloverleaf/options.xls it asks for ... A: Yes I don't know why it sometinmes asks for username and password, none is necessary, I have ... | |
| stop excel assuming I have a header row | 2/1/2007 |
| Q: I use the A | or Z | Z V A V sort buttons VERY often, but sometimes Excel decides that it ... A: No I am not quite sure why that sometimes happens. But I would use a Macro to make it select the ... | |
| auto move amount from one cell to next. | 1/31/2007 |
| Q: I have a spreadsheet where column A is a list of options to add when ordering an RV. Column B has ... A: This one was fun for me. I have used Toggle buttons on the Visual Basic toolbar. You would open a ... | |
| excel | 1/30/2007 |
| Q: I would like to change all the existing values in each cell of one column by ten (or by 14 or any ... A: Average is great. If you want to add 10 or multiply 10 to existing numbers you can type in the ... | |
| freezing rows and columns | 1/25/2007 |
| Q: have a quick question with excel. Driving me nuts. I am trying to freeze row 6 and column A. so ... A: Excel cannot do that unfortunately. However when you need something like that you can use multiple ... | |
| starting Excel | 1/25/2007 |
| Q: We need to keep the startup macro.We have upgraded Excel to from 2000 to 2003 and am having ... A: Then I would recommend purchasing a password recovery program and here is one to bypass the Password ... | |
| starting Excel | 1/25/2007 |
| Q: We have upgraded Excel to from 2000 to 2003 and am having difficulty with bypassing the startup ... A: If this macro is not something you need you can delete the workbook in the Xlstart folder. In ... | |
| Excel - Number & Text Formula | 1/23/2007 |
| Q: I used to be able to do this, but I forgot the syntax of the formula. In one cell I have "200 ... A: If "200 suites" is in cell A1 and the number 147 is in cell B1 then I would put this formula in cell ... | |
| Change Cell color from blue to orange | 1/22/2007 |
| Q: On my sheet, i have random cells filled with the color blue, i need to change them all to orange... ... A: You can use a little bit of VBA code to accomplish this. The one item to check is to make sure you ... | |
| Excel Formula | 1/20/2007 |
| Q: I have many columns of figures (dollars). Above each column I have a field that will do the sum of ... A: Yes you can do this with OFFSET. This would be the formula in cell A1. ... | |
| comparing data in two worksheet | 1/18/2007 |
| Q: .i just want to ask you how to compare datas/values in two different worksheets which means data in ... A: Yes you can compare both lists if they are have the same range and cells. You didn't mention how you ... | |
| Excel Date Formula | 1/17/2007 |
| Q: Referring to the formula below, what does "MaxYearNumber" do for me? DATE(MaxYearNumber,1,1) ... A: I Believe the "MaxYearNumber" is a named range on your worksheet. To find out go to the Excel menu ... | |
| excel | 1/16/2007 |
| Q: I want to count(SUM) cells from a group of cells whose numbers are not red A: You can only sum by text color with a user-defined function or a VBA Macro. I have made a ... | |
| update cells in a column | 1/16/2007 |
| Q: I like your idea but the formula's are on different spreadsheets(files). I tried putting the prices ... A: I can never tell from the questions that people give me what level of experience with Excel they ... | |
| Counting in a list | 1/15/2007 |
| Q: I have a list that I'm using to input registration information and some of the columns have either ... A: Yes you can use the Countif Function as long as you have some sort of designation such as you ... | |
| update cells in a column | 1/12/2007 |
| Q: I have about 200 chemical formulations Each raw material has a ID#. One of the columns identifies ... A: sorry it took me a while to get back to you. I took the weekend off. You can use a variable in a ... | |
| Conditional Formatting in Excel | 1/12/2007 |
| Q: I have a spread sheet with Employees names with the dates of the various certifications that they ... A: After you have your first cell formatted. Such as D2. You would select D2 and go to Excel menu and ... | |
| Conditional Formatting in Excel | 1/11/2007 |
| Q: I have a spread sheet with Employees names with the dates of the various certifications that they ... A: Select the certification date of one of the employees. Let me pretend the first certification date ... | |
| Filtering Birthdays | 1/9/2007 |
| Q: I want to display the "Employee of the Day" in Sharepoint based on filtering two data columns: ... A: The formatting in excel would be =Month(Today()) You can use Excel menu>Data>Filter>Advanced ... | |
| 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: Sorry about the headache. It is probably because it is not intuitive to know how to do double array ... | |
| If Statement - Can I use a wildcard? | 1/8/2007 |
| Q: I'm writing a conditional formula using "If". Can I use a wildcard in my statement? ex. ... A: You can use the SEARCH function to search the text in cell A12 for the letters "Med" if it finds it ... | |
| Character limits in cells | 1/7/2007 |
| Q: Is there any efficient way to copy (or duplicate) the entire contents of a sheet that has cells ... A: Yes you need to copy the cells and not the whole worksheet. To do this select the sheet you want to ... | |
| combining pages | 1/7/2007 |
| Q: I'd like to combine page two with page one - except they have different cell structure (ie. column ... A: You can try going to the Excel menu and selecting "Data" then "Consolidate" however with mismatched ... | |
| excel | 1/7/2007 |
| Q: how do you set up a cell so that if you type e.g. R the cell background goes red (also Y -> Yellow ... A: You can use conditional formatting. Select cell A1 and then go to the excel menu and select ... | |
| Summarising data | 1/5/2007 |
| Q: I have a workbook with 31 worksheets(days) and 1 summary sheet. For each day and account number and ... A: Select the summary sheet and the top left cell where you would like the summary data to start. Then ... | |
| cell question | 1/4/2007 |
| Q: i'm looking for a way to click on a cell and have it automatically insert the date, or drop down a ... A: First question. Here are some different tips on dates. 1. To enter todays date press Ctrl+; 2. To ... | |
| Cell in general format evaluates as text | 1/3/2007 |
| Q: Please help me - I have a rogue cell in my spreadsheet ('Group data'!A10) that doesn't behave like ... A: Yes sometimes you have to force Excel to return a cell to a number. Here are a couple things to try. ... | |
| Moving Data | 1/3/2007 |
| Q: The address column in my mailing list has 2 lines of text. For example line 1 - 714 East ... A: First I would want you to try this on a copy of your workbook and not the original just so you can ... | |
| Excel Array Formulas | 1/3/2007 |
| Q: Can you write an array formula in one spreadsheet using data from another sheet within the same ... A: Yes you can write an array formula in one sheet based on data in another sheet. Here is an example ... | |
| Spell check in Protected Excel doc | 1/2/2007 |
| Q: I read a previous post regarding this and while it worked, it only checked the active sheet. I have ... A: Open your workbook with password protection that you want to spell check and press Alt+F11 to open ... | |
| Count columns with multiple criteria | 1/1/2007 |
| Q: Did you receive my question on the performance issue...? Kindest Regars, RamonHi Ken, I am ... A: When you want to calculate a lot of different numbers PivotTable is a good way to do this. You ... | |
| Linking workbooks | 12/30/2006 |
| Q: I have 3 workbooks in one spreadsheet and they all have the account number in common. Whenever I ... A: Can you send me an example of the three workbooks? I am not quite sure what you need? If you have ... | |
| excel(weighted average) | 12/29/2006 |
| Q: How do I find the weighted average of cells grouped in different areas of a large spread sheet A: Excel does not have a weighted average function. But you can easily use SUMPRODUCT to accomplish the ... | |
| creat new tab | 12/29/2006 |
| Q: i have a file workbook in excel and i am trying to create a new tab. i right click on the tab with ... A: I am guessing that your workbook may be protected. You can check by going to the excel menu and ... | |
| blank cells and zero's | 12/28/2006 |
| Q: Ken: Kind of a new problem. I'm using grouping in this chart to hide data that is totaled in the ... A: Sorry I took so long I was busy with the holidays. You can download a workbook here. ... | |
| numbering | 12/28/2006 |
| Q: We are trying to find a way to create serie numbers that can be printed on heat transfer paper We ... A: I am thinking of using the ampersand sign "&" to connect text values such as 0000 with the numbers ... | |
| blank cells and zero's | 12/27/2006 |
| Q: Ken: The answer to my previous question really didn't solve the problem. I'm averaging columns and ... A: Yes I have run into this problem before and I had to understand this myself. But what you need to ... | |
| suming the values in a column which also has #N/A in few rows of that column.. | 12/27/2006 |
| Q: i have a data in xl..i want to add the square feets that are listed in column D..the column has ... A: You can ignore the #N/A error in your summing by the following formula. ... | |
| Text box | 12/26/2006 |
| Q: The help that they you gave me on check boxes was great so I thought you might be able to help me ... A: In the file that I sent to you called "email to ken for help.xls" If you open the file and go to the ... | |
| copy set of 2 sheets | 12/26/2006 |
| Q: 2...10. i want to copy sheets 1 and 2 ,sheets 3 and 4, sheets 5 and 6 is there a way out A: I am not sure what you are asking? But you can select sheet 1 and hold down the Shift button and ... | |
| SpellCheckIt macro for protected sheets | 12/21/2006 |
| Q: Hoe do you set up a macro to run spell check that can be used on more any sheet in the workbook in ... A: Open workbook with password protection that you want to spell check and press Alt+F11 to open the ... | |
| Frequency formula HELP!!!! | 12/21/2006 |
| Q: Ken, Yes, I know, I pressed ctrl+shift+enter....Arrays do not work with Alt... The formula returns ... A: Yeah just send me the file to cloverken@yahoo.com <> means does not equal "" means nothing. ... | |
| Frequency formula HELP!!!! | 12/21/2006 |
| Q: My actual data, of course, in not limited to kathy and 5 rows of dates...I adapted your formula to ... A: I apologize. Your formula is exactly right. But I mistakenly told you to press Ctrl+Alt+Enter to ... | |
| Frequency formula HELP!!!! | 12/20/2006 |
| Q: I need to calculate the number of times a date occurs in a range of values. HOwever, I have multiple ... A: The following formula assumes you have your data of Index User in cells A2:A6 and Date in cells ... | |
| Check Boxes | 12/19/2006 |
| Q: Season Greetings Ken, I will hopefully explain this properly. I am developing a questionnaire for my ... A: Very often I misunderstand the question in the short amount of words expressed. So if I ... | |
| removing blank rows | 12/15/2006 |
| Q: is there an easy way to remove (delete) blank rows in a spread sheet? search a particular column and ... A: Thank You, Ken | |
| formulas in excel | 12/12/2006 |
| Q: It does work, the formula that you gave. Also it is much simplier. Thanks again. You are the best. ... A: You can send me any questions at any time to cloverken@yahoo.com I just like answering questions.The ... | |
| Data | 12/11/2006 |
| Q: that works but is is not completely what I am looking for. I would like to find the differences if ... A: It is not comparing cell to cell but column to column to find those cells that are unique or alike ... | |
| Weighting grades to get an average | 12/10/2006 |
| Q: Let's say in averaging grades, I have several assignments worth different percentages of a total ... A: Excel does not have a weighted function. You can use the following formula to calculate a weighted ... | |
| Data | 12/8/2006 |
| Q: How do I compare data (PC names) like (m7702753edt4) in 2 worksheets and find the non duplicates and ... A: If you have three sheets. Sheet1, Sheet2, Sheet3. On Sheet1 in cells A1:A30 you have a list of PC ... | |
| Sorting | 12/8/2006 |
| Q: I have a spreadsheet that when I sort, I can do so by the column title (e.g. First Name, Last Name, ... A: I believe the reason is that once you go to "Data" then "Sort" sort will ask if you have a header ... | |
| Formula | 12/7/2006 |
| Q: Ken Working with 2 databases in the same workbook,I'm extracting data from the main database into an ... A: Here is a good formula that you can use to count unique entries with. ... | |
| formula with criteria based on text or font color | 12/6/2006 |
| Q: I'm trying to write a formula to sum values with the criteria that the values are in a specific font ... A: You can only sum by text color with a user-defined function. There are two here. One to sum by Green ... | |
| =IF formula | 12/6/2006 |
| Q: i'm working on a project that has two date fields. I do a simple formula to show me the difference ... A: You can do this with a user-defined function. Select and copy the following function. Function ... | |
| Excel Question | 12/5/2006 |
| Q: I am trying to make excel look at a sales value in a cell and if that value is between a certain ... A: It needs to be done with Visual Basic Programming. Select the following Macro and copy. Private ... | |
| Formulas between 2 spreadsheets | 12/4/2006 |
| Q: Ken, Is there an Excel formula that could capture a range of cells and copy them to another ... A: It is possible with a formula but gets more complicated than a macro. You could use something like ... | |
| Spell Checking Cell Range Not Workbook | 12/4/2006 |
| Q: I can appreciate that it would be easiest to have the user select the range of cells, but the ... A: You can make it check specific cells with the following Macro, just adjust the cells to the cells ... | |
| sorting time range in row-- | 12/1/2006 |
| Q: I'm trying to sort data and the only time frame I need is from 18:00-1159. The dates and times are ... A: If it is possible an example workbook would be the easiest if you can email it to ... | |
| Spell Checking Cell Range Not Workbook | 12/1/2006 |
| Q: I have a protected sheet that I want to be able to spell check. I have the following script to ... A: Probably the easiest way is to use the selection you have before you activate the macro that way it ... | |
| BLANK ROM PROBLEM | 11/30/2006 |
| Q: I HAVE A SPREADSHEET THAT IS 9000 ROWS PLUS LONG AFTER EVERY TWO ROWS THERE IS THERE BLANK ROWS ARE ... A: You can do this a couple of ways. First of all save the workbook and name it something like ... | |
| Query | 11/29/2006 |
| Q: Good Morning Mr.Marrron. we are four friend working on a project.hence we work with Excelsheet. Now ... A: The first question is the networking of the computers. Are the four computers connected to a main ... | |
| Summing in Rows and Columns | 11/27/2006 |
| Q: Is it possible to add a column and a row into the same cell for example, I have 6 columns of figures ... A: At first glance I would say that you cannot have a separate calculation for the columns and a ... | |
| Message when opening an excel file | 11/22/2006 |
| Q: I would like to show this message, like an alert: "This information is in constant revision. Please ... A: You can put a simple macro into the worksheet to show up each time the workbook is opened. Open the ... | |
| formula | 11/21/2006 |
| Q: Ill try and explain simply... Excel spreadsheet with multiple locations listed, some are the same ... A: I am not sure what you are trying to count. Locations of where the spreadsheet is saved? or location ... | |
| excel | 11/20/2006 |
| Q: I have a problem I can't solve. I have a spreadsheet and in it I put a number (204,687,500) I ... A: If your percentage 78.8% is a number that is the result of a formula then more than likely the ... | |
| How to restric duplicate entry | 11/15/2006 |
| Q: sir i want to stop duplicate entry in same column. suppose i am enetering in column a1 some invoice ... A: Select Column A by clicking on the "A" in the column, then go to the Excel menu and select "Data" ... | |
| Trying to find minimum values | 11/14/2006 |
| Q: I am comparison shopping for my company and using my pocket pc to input values. I put the program ... A: You may want to use =MIN(A1:L1) if you have any odd text or other characters other than numbers ... | |
| Checkboxes in Excel spreadsheet | 11/12/2006 |
| Q: How do I make a cell (on an Excel spreadsheet) function as a checkbox? I need to compile a ... A: Thanks Ken | |
| RandBetween | 11/10/2006 |
| Q: I need to use the RandBetween funtion and even though I have installed the Analysis ToolPak ... A: Yes you are correct. It is an added function in the regular function list. After you have loaded ... | |
| flickering of command button | 11/9/2006 |
| Q: i have performed a mousemove event over a comand button but the button starts flickering on mouse ... A: This seems to be an elusive problem. I have resolved several issues with computers and it always ... | |
| need to count multiple criteria plus | 11/8/2006 |
| Q: I read your recent answer, but one of my criterion is a sequential subset of several characters in a ... A: Can you give me an example of what you have and what you are trying to accomplish. I kind of ... | |
| color fill cells based on content | 11/7/2006 |
| Q: Simple example: I have a 10 x 10 grid of cells with city names in them. I want to color fill all ... A: For example if the City names are in cells A1:J10 I would select cells A1:J10 then go to the Excel ... | |
| To get data from recordset object to excel sheet | 11/7/2006 |
| Q: i have to fetch some data from data base and put the values in to the cells of the excel sheet and i ... A: I would require Visual Basic Programming. I am not an expert at VBA but I do have some ability to ... | |
| Date recognition in Excel | 11/1/2006 |
| Q: Suggest an IF function to read date in Sheet1, match this date in Sheet 2 and display the cumulative ... A: =SUMIF(Sheet2!A1:A1000,B1,Sheet2!B1:B1000) The first part of the formula SUMIF(Sheet2!A1:A10, is ... | |
| need to count multiple criteria | 10/27/2006 |
| Q: I need to count data in two different columns with different criteria. On one worksheet, I have ... A: To illustrate an example I will pretend that your "Event type" data is cells A2:A10 with the "event ... | |
| Formula | 10/25/2006 |
| Q: I am trying to create a formula. Ex. In Sheet1 I have a table with the names up top (row 3) and ... A: You would type a formula similar to the one below, just adjust for the right range that you need. ... | |
| Chart | 10/25/2006 |
| Q: Please help me with my chart. My sample budget data is as follows: Actuals Budget ... A: 1. I would suggest a column chart. This website is a little old. But it shows the basic way to ... | |
| Linking a drop down box to a chart title | 10/24/2006 |
| Q: I was wondering how I could link a drop down box of different assets to show up as the chart title ... A: Select the Chart title object on your chart, then insert your mouse pointer into the "formula bar" ... | |
| excel autonumber | 10/23/2006 |
| Q: Do you know how could I autonumber a list of groupings. Say a number or name repeats 5 times in the ... A: This site gives some ways to deal with duplicates. ... | |
| formula | 10/20/2006 |
| Q: I have a spread sheet with multiple taps. I am attempting to write a formula to have the cells sum ... A: Start on the worksheet with the employee totals where you would like the formula to reside. Select ... | |
| entering formulas | 10/17/2006 |
| Q: My daughter needs to find out how to enter simple sums in Excel without writing 'sum'using cell ... A: Well to add cells without using the SUM function you can do this. Select cell A1 and type in the ... | |
| i have names entered in excel | 10/17/2006 |
| Q: i have names entered in excel like this marv alpert 1 main street Somewhere, NY 10577 but i want to ... A: Here is one way to do it. I would save your workbook as a testworkbook.xls first so that you keep ... | |
| Pivot Table Data Entry | 10/16/2006 |
| Q: After creating a pivot table, I am attempting to add the revenue field in the "drop data fields ... A: It sounds as if your pivot table is counting revenue accounts and you would like them to sum. I ... | |
| Text Lines | 10/16/2006 |
| Q: In Excel, is there a formula that could count the number of text lines in a single cell? A: In Excel there is not a function that will add text lines in a single cell. This would require ... | |
| Setting up a Data base with names and numbers | 10/12/2006 |
| Q: I work in the casino industry and we have a data base compiled of players who have player numbers. ... A: The VLOOKUP function works well for this. Let's try this. On Sheet1 cell A1 you are going to type ... | |
| excel question | 10/10/2006 |
| Q: this is really bothering me. In the past, I have used this formula to compare two lists of Names: ... A: If you type a number in cell C2 such as 300178541 it should appear in the cell with the formula ... | |
| formula | 10/9/2006 |
| Q: HELP! I,m trying to come up with a formula in one worksheet that gives me a quantity from another ... A: See if this helps you. In cells A1:A5 type in the cooresponding numbers 2,5,2,8,2 repectively. In ... | |
| Entering data | 10/8/2006 |
| Q: We are in the process of setting up spreadsheets to enter our inspection data. Some of the data will ... A: Go to the Excel menu and select "Tools" then "Options" then the "Edit" tab then below the checkbox ... | |
| excel | 10/7/2006 |
| Q: you have recommended scan to office,but not sure if it does everything or i have some complex ... A: Well I would first demo the software. You can try 15 documents for free without even buying it. ... | |
| Curious | 10/5/2006 |
| Q: This question pertains to excel. One one sheet what is the furthest name column and what is the ... A: Sounds like homework. This depends on which version of Excel you have. The latest version 2003 has ... | |
| Formula | 10/5/2006 |
| Q: I am trying to write a formula that will allow me to count how many times a date or phrase show up ... A: =COUNTIF(I2:I845,"10/15/06") =COUNTIF(I2:I846,"Live") Another way to do this is to use a ... | |
| working out percentages with a formula | 10/4/2006 |
| Q: I am studying IT at college and I am still unsure how to work out percentages! I have to work out a ... A: I hear you, I have a difficult time remembering how all the different percentages work also. Here is ... | |
| Command Button font | 10/2/2006 |
| Q: I have a spreadsheet that uses a command button to call a macro. The button (and macro) work fine, ... A: Not sure what is happening with the font spacing issue. But while in design mode double-click the ... | |
| excel and button | 9/29/2006 |
| Q: .. I want to add button on excel sheet... can u tel me how to do that... and also where to write ... A: Although this sounds like a homework question I will help. Go to the Excel menu and select "View" ... | |
| conditional formatting | 9/28/2006 |
| Q: Ken Marron: I would like the following conditional formatting: If the currently selected cell is ... A: This needs Visual Basic Programming. Select the sheet where you want the conditional formatting. ... | |
| Cell Sizing | 9/27/2006 |
| Q: I am using a VLookup Formula and the data it's pulling from varies greatly in size. Some answers ... A: I am not aware of the ability to have a scroll bar within a cell. There is a capability to have a ... | |
| words going past column | 9/26/2006 |
| Q: I did a review and am trying to make some changes to it. I was trying to put each comment into one ... A: I wasn't sure which thing you were talking about so I am going to take a guess at which you were ... | |
| Excel formula for form organization | 4/28/2006 |
| Q: I have a small formula problem I haven't been able to figure out. I do not know if it is possible ... A: You can use a nested IF formula, But nested IF Statements can only handle 7 conditions. You can use ... | |
| Export Excel settings | 4/27/2006 |
| Q: I am wondering if there is any way to export my current excel settings to a new machine? I would ... A: There is no one file to transfer all excel settings to another computer. There is a toolbar ... | |
| Excel used for inventory tracking | 4/26/2006 |
| Q: I'm trying to assist someone who is using Excel for a very basic inventory tracking system. The ... A: Yes it can be done with VBA. If you want you can send the workbook and I will put that programming ... | |
| Deleting rows | 4/18/2006 |
| Q: I have a question concerning the deleting of rows in exel. I would like to know how to delete every ... A: I would download ASAP utilities at. http://www.asap-utilities.com/ once downloaded and installed ... | |
| Excel2000 xp Home | 4/13/2006 |
| Q: "I have downloaded data from internet with IE edited with MS excel. On spreadsheet column of ... A: I am not sure exactly what kind of data you have downloaded but here are a couple of areas that will ... | |
| formula from two cells | 4/9/2006 |
| Q: I thank you very much for your help last time. Now, I am making another file in which the users can ... A: Yes you can. You can use the IF Function for this. I am not sure if you have a calculation for ... | |
| Protection of cell | 4/8/2006 |
| Q: I have made an Excel file in which I created a formula. Let's say that the formula in C3 =C1+C2. My ... A: Yes you can. It is cell protection. What you will be doing is selecting the cells that you want to ... | |
| linking excel intake form to database | 4/7/2006 |
| Q: Good afternooon Ken and thanks for offering your services. I'm using Excel from Office 2003. ... A: This sounds like a job for VBA programming language. You could probably get some complicated ... | |
| adding sheets | 4/6/2006 |
| Q: i have a simple question, i am trying to add sheets to the bottom of my excel file. but every time ... A: You can solve this with a little bit of code. 1. Make sure Security setttings set to low. Go to ... | |
| Figuring Overtime on a Spreadsheet | 4/5/2006 |
| Q: I would appreciate any help you can give me with my question. I am building a timesheet. I have ... A: Not sure exactly what you want. But try this. formula for cell I7 =IF(SUM(B7:H7)>40,40,SUM(B7:H7)) ... | |
| Excel formatting... | 4/4/2006 |
| Q: Ken - I'm a VB/ASP programmer, with very little knowledge of Excel. I have a worksheet embedded in ... A: I am not an expert at VBA. Damon is an expert at VBA. You can ask him a question at. ... | |
| Adding the numbers within "one" cell? | 4/3/2006 |
| Q: I'm using Excel 2003. I have a question, it might be simple but it's really stumping me! :) Example: ... A: Place the following formula in cell C1 and drag the fill handle down as far as you want. This ... | |
| Excel adding question | 4/1/2006 |
| Q: Using Excel 2003 I appreciate your assistance. I'm trying to do the following, basically increasing ... A: If you type in cell B1 8.00 and in cell B2 8.05 and in cell C1 400 and in cell C2 402.5 then select ... | |
| round function | 3/31/2006 |
| Q: I have a spreadsheet i am working on in excel, and have come accross a problem. I have a column ... A: I do not see anything wrong with your formula. ... | |
| Excel text limitation | 3/30/2006 |
| Q: When typing text in a row in Excel, is there a character limitation? The Supervisors I work for are ... A: Yes there is a character limitation. It depends on what version of Excel you are using but an easy ... | |
| excel linking between sheets | 3/28/2006 |
| Q: I want to link between 2 sheets in the same workbook. sheet one is a template, and sheet two has the ... A: Yes you can. VLOOKUP function is a good way to pull information from a small database. You can use a ... | |
| Excel sorting | 3/27/2006 |
| Q: Ken, I am in the process of creating a spreadsheet that will keep track of widgets won.. format: ... A: There should not be any gaps such as blank rows or columns. Then select the entire range of data ... | |
| Setting up a program | 3/27/2006 |
| Q: I am a degree student and I am currently doing a Work Based Learning Project. I am studying a Milk ... A: I would start by entering what information that you have into row1 such as the list areas, ... | |
| Excel | 3/27/2006 |
| Q: Spell checker does not seem to work whilst a worksheet is password protected is there anyway that ... A: You can insert a short Macro to handle this. Sub SpellCheckIt() Sheets("Sheet1").Unprotect ... | |
| count | 3/26/2006 |
| Q: I have this data that i want to change the view: Current data: Name Status Magda In Magda ... A: You can use PivotTable. Select all data including Header rows "Name" and "Status" then go to the ... | |
| formula | 3/25/2006 |
| Q: I wanted to make a formula to use in excel 2003 so that if I put certain numbers or letters in a ... A: You can us an IF statement such as. =IF(A1=60,30,"") the formula would need to be placed in cell ... | |
| I'm using Excel 2003 I'm... | 3/25/2006 |
| Q: I'm using Excel 2003 I'm responsible for typing up assignment sheets for our Emergency Department. ... A: Yes I would like to see an example of what you are trying to do. You can send it to ... | |
| countif | 3/23/2006 |
| Q: I have two questions. I am first wondering how to simplify a simple repetitive formula. Here is a ... A: For your first question I could not find much to simplify there unless we use Visual Basic ... | |
| hidden cursor | 3/23/2006 |
| Q: Q: how i hide cursor by code or other methods of active sheet. A: I do not know of a way to hide the cursor. You can change the cursor to Default, I-Beam, Wait, or ... | |
| Merging 2 columns | 3/22/2006 |
| Q: i have a simple question,i think, i want to merge 2 columns, i have 2 columns one with zip code & ... A: You can use the ampersand sign & to join separate items. If your zip code is in cell A1 and the 4 ... | |
| Auto Filling | 3/21/2006 |
| Q: If in cell C2, I have 4PM, how can I fill in the cell C3 6PM and in the cell C4 8PM (two hours ... A: Here are a few different ways. 1. You can type in cell C2 4 PM and in cell C3 6 PM then select ... | |
| water mark | 3/21/2006 |
| Q: I wish to add a water mark as a background to the page (for example: page one, or draft etc). Hoe ... A: Watermarks are not available in Excel. However many people have tips on creating "watermark like" ... | |
| Getting the last row | 3/20/2006 |
| Q: I'm using excel 2003 and would like to know how to clear all the values in column D but keep the ... A: This macro would work on any workbook by clearing column D except for cell D1 and by formatting ... | |
| extracting data from data base | 3/15/2006 |
| Q: I am working on one database in which i have around 25 companies data for 4 years. The data base is ... A: PivotTables in Excel are perfect for this kind of number crunching. It is difficult to totally ... | |
| Date Formula | 3/14/2006 |
| Q: Excel 2003 If I have a date (ex. 5/10/2006) in a cell. How can I then write a formula that would ... A: This formula assumes that the date that you are checking in a cell is in cell A1. It also assumes ... | |
| Sheet tabs in Excel | 3/14/2006 |
| Q: I noticed in Excel (Mac OS X ) that my sheet tabs are in a color that is very faint, if not white. ... A: In Excel 2002 or later you are able to change the color of sheet tabs by right-clicking while ... | |
| Excel 97 | 3/14/2006 |
| Q: I need to get the cent symbol into cells, but as you know, Excel 97 doesn't have a symbolizer. I ... A: Ah Yes, I see. If you can get a file to your laptop that would be great. In Microsoft Word you can ... | |
| Excel Shared Worksheets | 3/13/2006 |
| Q: When I merge the first worksheet sheet into my master shared worksheet, it works fine. However, ... A: The best help I could find anywhere for this is Excel Help. Obviously the final worksheet will ... | |
| sumif formula | 3/11/2006 |
| Q: ----- Hi Thanks very much, this solution worked very well. Just one more quick question if I may. ... A: Select cell A6 and go to the Excel menu and select "Format" then "Conditional Formatting" click the ... | |
| Excel - Row 1 Missing | 3/9/2006 |
| Q: I have Excel 2000. I have a spreadsheet that on just one tab Row 1 cannot be seen. It shows up in ... A: I know exactly what you are talking about because I have had the same problem and it is a little ... | |
| Excel | 3/8/2006 |
| Q: I have a list of names in columns A, B and C. I'm trying to create a list of names in column D of ... A: Sorry I have been busy and it took some time to get back to you. I have worked out a sheet that will ... | |
| Excel Formats | 3/7/2006 |
| Q: Ken, Format: Microsoft Excel 2003 My question has two parts really and any help you can offer ... A: To show leading zeros you can select the cell with this format that you would like. Then go to the ... | |
| PRINTING THE COLLUM HEADINGS? | 3/5/2006 |
| Q: I HAVE SET UP A FEW EXCEL SPREAD SHEETS, ONE IS FOR MY LEDGER OF MY CHEX BOOK. HOW DO I PRINT THE ... A: Select the Excel sheet you would like to print. Then go to the Excel menu and select "File" then ... | |
| data bases | 3/3/2006 |
| Q: I want to be able to limit the info in a excel cell, i mean, there are a funtion to click in the ... A: Yes Excel uses "data validation" for this. Here's an example you can try. Input in each ... | |
| Format Cell Colour Automatically in Excel | 5/20/2005 |
| Q: I am trying to get Excel to Auto Format a cell based on the value of that cell... For example, if a ... A: You can use Conditional Formatting. Select the first cell for your first example and then go to the ... | |
| Function call from other modul | 5/17/2005 |
| Q: I got in a XLS-File a Function (CheckData), which should be started from another Modul of XLS-File2. ... A: You can copy your custom function to a "personal.xls" workbook. This workbook is available everytime ... | |
| counting # of rows | 4/3/2005 |
| Q: I have a simple question, i have excel 97 windows, i have a very long list in a spread sheet, i ... A: If you put this formula in cell B1 =COUNTA(A1:A1000)+COUNTBLANK(A1:A1000) It would count the rows ... | |
| Not enough memory | 4/1/2005 |
| Q: When starting one particular .xls file in Excel 2000, which contains macros and is linked to other ... A: Wowser!!! 2 Gigabytes of RAM! I remember spending $3000 on a computer with a 60 MB hard drive. Times ... | |
| Average, Min, MAx, and Standard Deviation Graphing | 3/31/2005 |
| Q: Well I have troubles graphing the average, max, min, and standard deviation of a database that I ... A: The easiest way to do this is to create a column for Average, Min, Max, and Standard Deviation and ... | |
| Functions | 3/2/2005 |
| Q: Please tell me about the functions in excel : If else formula and Nested If else formula A: The IF function evaluates a condition and returns a value you specify. For instance. If you have the ... | |
| Merging two spreadsheets into one | 3/1/2005 |
| Q: Is there a way to merge two workbooks into one? Neither of the workbooks were marked as a shared ... A: Open both workbooks. Hover your mouse pointer over the first sheetname in one of the workbooks and ... | |
| Macros / MS Reports | 2/9/2005 |
| Q: I had created a macro and it worked fine. Once I save the file and reopen it I am unable to refresh ... A: I am not sure, I always run my security on Low, just because I do not want to deal with assigning ... | |
| Best way to forecast individual sales territories? | 2/3/2005 |
| Q: I have a spreadsheet with twelve months of sales data per territory (100 territories.) I need to ... A: Excel has the Forcast function that you can try. I have not made a forecast worksheet before. But if ... | |
| copying columns of data into another sheet | 2/2/2005 |
| Q: Is there a way to automatically copy the data of a column on one sheet to a column on another sheet? ... A: Not sure exactly what you need. But obviously you can select Sheet 2 and in column M type in the ... | |
| A graph with empty values. | 2/1/2005 |
| Q: I would like to make a graph (line chart type) where the some of the cells of the column of the ... A: Yes, If you leave B5 blank the chart works, leaving the blank uncharted. However if you input a ... | |
| Excel | 1/30/2005 |
| Q: mr ken, how are you ? mr ken i want to learn macros, how can i start it through internet from ... A: I am doing fine. How are you? I know Visual Basic programming only at a beginner level. All my ... | |
| creating list via an arrow for cells | 1/28/2005 |
| Q: I am trying to put drop down menus of text with 9 different choices in a cell (to be repeated down a ... A: You can use Data Validation for this. First you need to input the 9 different text choices in a ... | |
| Using Lookups | 1/27/2005 |
| Q: I have field "Price" on a Sheet1 that needs to be filled based upon another field "Part" on Sheet1. ... A: For simple Quarter1 through Quarter4 in one year you can use an IF statement with VLOOKUP. For more ... | |
| loop until a key is pressed | 1/24/2005 |
| Q: Could you help me to write a vba code that run a loop until the user press S Thank you. Regards A: Sorry I do not know enough VBA to help. You can download and example workbook at ... | |
| Excel Formula | 1/17/2005 |
| Q: I am using Excel in Office 2000 on XP. I need to lookup a code in a range of data of quantities, ... A: Sure you can use DSUM function. What I would do is insert three new rows at the top of your ... | |
| Excel formula problem | 1/14/2005 |
| Q: I am working on a sheet for work. I cant give actual data so will replace it with dummy data. The ... A: What you have is an array formula. If you only enter this formula you would get a #VALUE error. ... | |
| MS Excel formula | 1/13/2005 |
| Q: I have got a large spreadsheet full of data in different colours. All i want to do is delete data ... A: Actually it's not that simple. But you can download ASAP utility which will make it pretty simple. ... | |
| i am using the following formula | 1/12/2005 |
| Q: i am entering diameter in inches in one cell, in the adjacent cell i am entering length in feet. The ... A: I hope I understood your question. If K is entered in inches how do you change the formula to ... | |
| Rounding off | 1/12/2005 |
| Q: I have created a spreadsheet. One column shows hours worked. Another column shows rate of hourly ... A: I am not clear if you are asking about rounding a number or the number of decimal places displayed. ... | |
| dropdown boxes | 1/12/2005 |
| Q: Using a combobox. When it is first set up the box itself is empty until the first selection is made. ... A: Well if you haven't used Visual Basic Programming, you are going to see how it will make your life ... | |
| Excel | 1/11/2005 |
| Q: Respected Ken, Hi, how r u? mr. ken please any how you give me a kind of formula or macro which can ... A: Excel will not let you have an input in cell B1 and have a formula in cell B1. Because you are ... | |
| COUNTIF formula | 1/10/2005 |
| Q: Is there a formula that can look at two columns, and count the number of times two different results ... A: What will work is an array formula. If you have not used an array formula this is a website that ... | |
| Start a predetermined file when I start Excel daily | 1/8/2005 |
| Q: I use MS Office XP professional with MS Window XP. One Excel file I will use everyday. How to set ... A: You can save your excel file that you use everyday to this directory. C:\Program Files\Microsoft ... | |
| Using lookup table sometimes gives incorrect info. | 1/7/2005 |
| Q: I am working on a "Quote" sheet where I use a lookup table. We put in a part number and then we fill ... A: If you use VLOOKUP function it gives you the choice to match the lookup exactly. within the VLOOKUP ... | |
| Excel - validation list | 1/7/2005 |
| Q: MicroSoft Excel 2003 Validation list - I have created drop down lists for cells, & to do this I must ... A: There are two different ways you can do this. First if it is a short list your are entering for data ... | |
| Grouped radial buttons | 12/8/2004 |
| Q: I am working in Excel on XP professional edition. I am revising a existing spreadsheet, and I am ... A: Probably the easiest way for me to help is to see a copy of this. Because there are so many ... | |
| Excel lookup value in Sheets | 12/7/2004 |
| Q: Need help on how to look up a value from other sheet with the same format. For example in sheet 1 ... A: If you are using a formula to return the value Hello Good Morning Bye such as =Sheet1!A3 Select ... | |
| IF | 12/6/2004 |
| Q: if we have two columns, on a1 we have 87 and on b1 we have B, is it posible to get the a1 number by ... A: If you have 87 in cell A1 and "B" in cell B1 then in cell C1 the formula would be. ... | |
| Opening files | 12/3/2004 |
| Q: Here's a simple one, Ken - or I think it must be! When I click on File - Open (or on the "open ... A: You can change this by opening any excel worksheet and then go to the Excel menu and select "Tools" ... | |
| excel spreadsheet | 12/2/2004 |
| Q: i am trying to convert a cell that has the time in hours and decimals. i want to insert or write a ... A: If 3.5 is in cell A1 then the formula in cell B1 would be =A1/24 then with cell B1 selected you ... | |
| set a valu based on cell fill color or % | 11/21/2004 |
| Q: I have worked in VBA with Access and have a question with excel 2000. I want to set a value in say ... A: I am not a VBA expert. But here is what I came up with. If you copy and paste this into the ... | |
| Filter by Colour | 11/19/2004 |
| Q: Is it possible to filter by colour? If so how? eg i have a column with different colours in it and ... A: Excel does not have a tool for this. But you can use VBA programming language to do it. This is ... | |
| Sum for a date range | 11/4/2004 |
| Q: I found a Q&A in this web site. However i am unable to adapt this to my requirement can you help. ... A: Sorry I am late with an answer. I believe the SUMIF function will help you. If I place Product1, ... | |
| Custom Formating | 11/3/2004 |
| Q: Ken, Importing a text file into Excel 2000. One of the fields is a date "09012004". I would like to ... A: I find myself always learning something new about date and time within Excel. That is because there ... | |
| Investment return | 9/19/2004 |
| Q: ken Marron, i am having some serious problems in tryin to construct a project that will generate the ... A: It is a litte too much for me to handle right now. Here is one part of it. To restrict the number ... | |
| STay online. | 9/18/2004 |
| Q: Ken, this is your laugh for the day. I do not know very much about my computer....It had been ... A: Yes, it does make me laugh. Because I was thinking, if she keeps getting knocked offline how is she ... | |
| Excel is rounding up large numbers | 9/16/2004 |
| Q: but I still wonder about it anyway. I tried to write a rather large figure into excel, and ... A: Excel uses a number storage standard named IEEE (Institute of Electrical and Electronic Engineers) ... | |
| Excel | 9/15/2004 |
| Q: How are you ? hope sailing in the ocean of good health. Sir i have sent an email (follow up ) on ... A: Here is the corrected Macro, It will only work in Column A now. Also like I said if you enter a ... | |
| Buttons/if one cell is x then the next is y | 9/14/2004 |
| Q: Simple questions: I would like to make pull down buttons (I used to use FileMaker as my database) ... A: Do itashimashite. We had Japanese students stay at our house for three weeks at a time. My parents ... | |
| Emailing Sheet that has combo box | 9/10/2004 |
| Q: Using Excel 2002 and Outlook 2002 Currently have a workbook with 3 sheets. First two sheets list ... A: The best way to do this is to not send the first two sheets to anybody. Here is what I would do, ... | |
| pivot tables | 9/10/2004 |
| Q: I am trying to totally protect a pivot table from user change and have used "drag to ... A: I am not sure if this is exactly what you want. But you can password protect the worksheet and would ... | |
| Excel | 9/9/2004 |
| Q: Respected Sir, How are you ? Hope you are sailing in the ocean of good health. Sir I have a ... A: I am sorry I wasn't clear. You can download an example workbook with this macro at. ... | |
| Excel | 9/8/2004 |
| Q: Respected Sir, How are you ? Hope you are sailing in the ocean of good health. Sir I have a ... A: Copy the following Macro then Go to the sheet where you want the total in column A then press ... | |
| conditional formula | 9/7/2004 |
| Q: This may be a bit difficult to explain, so I'm sorry if this is confusing. At my job I have created ... A: This went beyond my knowledge. So I went to www.mrexcel.com and got an answer from Aladin, he is the ... | |
| Excel VBA Forms | 9/7/2004 |
| Q: I have developed a VBA Form that collects information from a user. When the user has input all the ... A: I only know some VBA but... As far as Excel goes there are many different limits on different ... | |
| ############## in Excel | 9/4/2004 |
| Q: Just when I thought I was ok at Excel. Ken I've formatted the cell to text as I'm writing a needs ... A: I don't know what version Excel you are running. But in Excel 2000 and on. The character limit of a ... | |
| Using IF within MAX to locate 'first' row a number appears | 9/3/2004 |
| Q: Hey Ken, Thanks for the link, but I already know to press Ctrl,Shft,Enter for the array ;-). That ... A: Wow! I am messed up. That first reply sounded so funny because I thought I had sent an earlier reply ... | |
| Using IF within MAX to locate 'first' row a number appears | 9/3/2004 |
| Q: Firstly thank you for volunteering your expertise. Using Excel 2002 I want to locate the 'first' ... A: Wow! I am messed up. That first reply sounded so funny because I thought I had sent an earlier reply ... | |
| Totals by Week | 9/3/2004 |
| Q: Using Excel97. In a spreadsheet using a date format of mm/d/yy, how can I get group records to get ... A: You can download an example workbook that I made showing how the formulas work. Perhaps you are not ... | |
| 2 condtion formula to suma range | 9/3/2004 |
| Q: I am using Windows XP and Office XP My question is this. I have a sheet with Column A being the ... A: What will work is an array formula. Copy and paste the following formula within the Assumptions ... | |
| concantenate function | 9/3/2004 |
| Q: is there any way of combining the contents of two columns together? eg. Col. A Col B ... A: If your number 0005456456 is in cell A1 and Column B has 000 all the way then this formula would ... | |
| Can't figure it out | 9/2/2004 |
| Q: one page 1 of an excel workbook i have this info: 1 Culpepper, Daunte 2 Manning, Peyton 3 McNabb, ... A: If the first sheet is named Sheet1 and if in cells A1:A25 on Sheet1 you have the numbers ... | |
| Totals by Week | 9/1/2004 |
| Q: Using Excel97. In a spreadsheet using a date format of mm/d/yy, how can I get group records to get ... A: My example is this. In column A1:A100 I have dates formatted as mm/d/yy In column B my formula ... | |
| cell fill | 8/30/2004 |
| Q: If I fill a cell with a color and then add a number in the cell. Now if I cut the number and paste ... A: To my knowledge you cannot just cut the number from a cell without using Visual Basic programming ... | |
| Excel 2000, linkage problem | 8/30/2004 |
| Q: I've quite a number of workbooks, each with about 10 spreadsheets. Each cell of the spreadsheet is ... A: When you open a linked workbook it should give you the option to update links. You can press "Don't ... | |
| Excel | 8/30/2004 |
| Q: respected sir, how are you ? i am fine here and praying for you, as you helped me out in every ... A: Go to the sheet where you want to type the names and press Alt+F11 Paste the following Macro into ... | |
| SUMIF & IF | 8/29/2004 |
| Q: I am trying to create a work book that checks 2 ranges before doing sumif calculation. I am using ... A: I sort of understand what you need to do. First of all any SUMIF functions need to be based on a ... | |
| Easy way to do this | 8/28/2004 |
| Q: Ken I have a weekly schedule that I would like to print out with dates. Is there an easy way to do ... A: Here's a couple things you can do. Please understand that I will explain from the most basic, not ... | |
| excel | 8/28/2004 |
| Q: Followup To Question - Respected Sir, How r u ? Thanks for helping me in every aspect. Sir i want ... A: 1st Question's answer: This will work for both Text and Numbers. It just looks at the cell to see ... | |
| Counting text in excel. | 8/27/2004 |
| Q: How do I get excel to sum up text as if it were numbers (a long list of employee names for example, ... A: COUNTA function will count cells filled with Text. If you had names in certain cells from A1:A10 and ... | |
| Linking Workbooks | 8/26/2004 |
| Q: I am looking for a way to remove links from another workbook.I have several links in each workbook, ... A: Excel 2002 has a "break link" button. It has this because it was always confusing on how to break ... | |
| excel | 8/26/2004 |
| Q: Respected Sir, How r u ? Thanks for helping me in every aspect. Sir i want a series of number ... A: Oh, yes now I see what you mean. Try this, copy and paste this into cell A1 =IF(ISTEXT(B1),1,"") ... | |
| Pasting | 8/25/2004 |
| Q: I am temping for a company, and would like to know can I copy every sheet (or select a certain ... A: You can copy sheets to another workbook. Open the workbook that you want to copy. Open the other ... | |
| excel | 8/25/2004 |
| Q: Respected Sir, How r u ? Thanks for helping me in every aspect. Sir i want a series of number ... A: Your first question. I believe you want to return a serial number when you enter the description. ... | |
| Lost Excel Worksheet | 8/24/2004 |
| Q: Ken: Last Wednesday I was working on 2 separate excel worksheets (both open and going back and ... A: I was wondering if this was two separate workbooks? You mentioned that it was two separate ... | |
| add years = 200? | 8/24/2004 |
| Q: Ken. Lets say in cell A1 I have my birthday 7/5/79 Then, in cell B1 I have the number 20. How can I ... A: C1 will format itself with this formula. This is actually a simple formula, using DATE function in ... | |
| Time and General Format in a Timesheet | 8/23/2004 |
| Q: Excel 2000 I have a column of 5 cells containing returned Times 08:00 (as a calculation of hours ... A: Frustrating isn't it? Don't worry you are one of many many people asking me the same questions about ... | |
| Excel Spreadsheet | 8/22/2004 |
| Q: Could you tell me if there is a way to multiply every entry in a column (in Excel) by, say 120%, in ... A: I hope I understand your question right. If you have numbers in Column A let's say from cell A1 ... | |
| Excel | 8/18/2004 |
| Q: Respected Sir first of all thanks for what you have taught me and on the other hand i am sorry to ... A: There is another macro at the end of this email. You will need to copy the macro then open Excel and ... | |
| EXAMPLE OF USING (IF) AND (AND) AT A TIME | 8/16/2004 |
| Q: EXAMPLE USING IF & AND . EXAMPLE OF MACRO EXAMPLE OF LOOPING A: I assume you are asking for examples. IF AND Example: Open new workbook then copy and paste this ... | |
| - character | 8/16/2004 |
| Q: In excel 2003, in our project we are storing some information and is not related with any formulas. ... A: Select the cell where you want to type -g and go to the Excel menu and select "Format" then ... | |
| excel | 8/15/2004 |
| Q: respected sir, once again i am here. Sir i receive some cheques from customer and i want to keep ... A: Select cell A1, then go to the Excel menu and select "Format" then "Cells..." select the "Number" ... | |
| IF function | 8/14/2004 |
| Q: My problem is this. I am using Excel XP, and understand that I can only "nest" up to seven IF ... A: Who said you can't do more than 7 if's? Try this. Cell B1 formula ... | |
| Excel Formula | 8/14/2004 |
| Q: Windows XP, Excel 2000 I was hoping I'd get you! I am working on a Performance Appraisal for my ... A: Yes I see, You have 8 cells. I am using cells A1:H1 as my 8 cell range. You might have a number in ... | |
| Product Number and Pricing | 8/13/2004 |
| Q: I have been using Microsoft Excel 2002 (not certain of the version) (Windows XP) to create both ... A: Cool! I would definitely create a template, especially if you are selecting the same product numbers ... | |
| IF formula not working | 8/12/2004 |
| Q: I am using Excel 2000, and have written a formula that for the life of me, I cannot see the error. ... A: correct formula ... | |
| Excel Layout | 8/11/2004 |
| Q: I am using excel from office 2000. I need to devise some sort of inquiry system for a spreadsheet. ... A: To create drop-down menu. Go to the Excel menu select "View" then "Toolbars" then "Forms" toolbar. ... | |
| excel lists matching (?) | 8/11/2004 |
| Q: could U help me in the following issue and give me a solution? I have 2 excel lists. The basis of ... A: I am not understanding. If you can send the spreadsheet or a sample spreadsheet. That would help. If ... | |
| Align Checkboxes | 8/11/2004 |
| Q: Yesterday I asked you how to align checkboxes, I deleted the message from my Email withouth wanting ... A: SHIFT+CTRL+Left Click to select the multiple checkboxes. Go to the Excel menu and select "View" ... | |
| Error upon opening an Excel file | 8/8/2004 |
| Q: When opening an excel file I get the following remark: 'C:\Program Files\Business ... A: BUSFUN.XLA is an "independent" excel Add-in. More than likely what has happened is Excel does not ... | |
| Ken An older spreadsheet... | 8/7/2004 |
| Q: Ken An older spreadsheet program I worked with had built in group function e.g. if cell a1 contained ... A: Yes you are correct. Excel does not have that function. However other people have made an add-in ... | |
| Formatting a cell for latitude/longitude data | 8/6/2004 |
| Q: Ken, I'm creating a form in Excel that will contain latitude/longitude information, and I'd like to ... A: I could not even begin to do better than one of the real excel experts "Chip Pearson". Check out his ... | |
| excel links | 8/6/2004 |
| Q: In a networked environment- why do some link references appear as drive letter\file name etc and ... A: I am not an expert on this area. But I believe you can refer to a hyperlink by either going to the ... | |
| extracting fields out of an Excel Program | 8/5/2004 |
| Q: We are in the process of creating a data base in Excel 2003. Presently we have 45 column fields and ... A: Here is my two-cents. If you are just creating the database. I would strongly suggest using ... | |
| Excel | 8/2/2004 |
| Q: respected sir we met a day back, i was with a question and you answered me and got the solution. I ... A: If you enter the Dinar in cell C1 such as 35 then enter the rate in cell D1 such as 29.5 (I assume ... | |
| Column Widths | 7/31/2004 |
| Q: Is it possible to be able to alter the width of a column, but starting for instance 10 rows down. ... A: Yes, you can merge cells to have that effect. If you select the cell furthest to the left and in row ... | |
| TODAY or NOW function | 7/30/2004 |
| Q: I am trying to do something which seems like it should be really easy, so I am certain I am just ... A: It is simple it is the formatting. To correct it, select the cell with the formula and go to the ... | |
| Excel formulas | 7/29/2004 |
| Q: We are developing a quotation spreadsheet for our business. The sales persons fill out the first ... A: If cell Sheet1 G21 is left blank or a zero you would get the #DIV/0 error. So I would change the ... | |
| adding rows | 7/28/2004 |
| Q: I have a formulaI'm trying to combine columns, or I should say, add rows together. I'm working with ... A: I am not quite understanding your question. If you want you can send a sample spreadsheet to ... | |
| excel graphics | 7/28/2004 |
| Q: I want to graph my price data on the excel bar charts (commodities) Further, when certain criteria ... A: I am sorry I do not know the answer to that. I do know that you can conditional format the source ... | |
| Formula | 7/28/2004 |
| Q: I have a group of sales people. I am running an incentive where whoever sells below a certain % of a ... A: You can use nested IF functions to evaluate the sales % of a product. You want to evaluate the least ... | |
| deleting blank rows from column | 7/27/2004 |
| Q: I have a column of subtotals with different numbers of blank rows separating them. Column A is ... A: Here are three ways to do delete empty rows. 1) Select Column A. Press F5, click "Special" ... | |
| Default margins for printing | 7/27/2004 |
| Q: Is there a way to create new default margins for printing so I don't always have to go in and change ... A: You can make a default workbook with your print settings that you want. To do this open an Excel ... | |
| vlookup | 7/26/2004 |
| Q: I use vlookup to return the day from a given date. I always have to use a separate column for the ... A: The CONCATENATE function will combine both values. Or using the "&" you can combine values such as ... | |
| increment cell value in excel 2000 | 7/25/2004 |
| Q: I am using an Excel 2000 spreadsheet to keep track of customer back order quantities. Column E ... A: I kind of get what you are asking but it would be really helpful to see an example. If you would ... | |
| Cell color | 7/24/2004 |
| Q: Is there a way to know whether the cell is colored or white and to give the result as a number (o or ... A: Yes you can tell exactly what color is in a cell. Here is a user-defined function. Do no worry if ... | |
| vlookup returns text string | 7/23/2004 |
| Q: (using MS-Excel 2002 i am building up a table containing customer code - various columns with ... A: I found a user-defined function on the web while looking for other stuff. This will return cell ... | |
| Timesheets | 7/23/2004 |
| Q: Could you please tell me how to devise a working timesheet on excel? A: You can format cells with the "Time" format If you have cell A2 as the time in. and B2 cell as the ... | |
| multiply time and money | 7/21/2004 |
| Q: Excel 2002 I am setting up a spreadsheet for my daughter to track her babysitting time and money. I ... A: Sorry in my rush last night I made a mistake on the formula for Cell E2. It should be ... | |
| testing cell values | 7/21/2004 |
| Q: MS Excel 2000 I am trying to test a cell for two different, but particular values and if one is ... A: Yes I would use the OR function as such. =IF(OR($D$3=6,$D$3=14),ROUNDUP(($C$3*12)/5.625,0),0) One ... | |
| Excel worksheets | 7/20/2004 |
| Q: Ken, I was interested in asking you a question that I need help with after reading your profile. ... A: I forgot to answer your first question. We are a framing subcontractor for residential housing in ... | |
| excel formula | 7/19/2004 |
| Q: Enter 26 in cell a1 and have it go to d1,then then have a1 empty,then enter 30 in a1 and have it go ... A: This requires a little more than a formula. But you can copy and paste the code at the bottom of the ... | |
| Conditional Formating Problem | 7/15/2004 |
| Q: I have an Excel 2002 (sp 2) work book that I save as an .htm file for use as a web page. I use ... A: Take a look at these Microsoft Knowledge Base articles. This has been a problem for a while with ... | |
| Starting a Macro | 7/15/2004 |
| Q: I have a macro that finds data in a worksheet and stores the data in a summary. I would like to ... A: First, I am not a VBA guru. I am self-taught and know some VBA. My experience has been to run macros ... | |
| Forms (option button, chech box) | 7/12/2004 |
| Q: I have been trying to design something like a questionnaire in excell using the option button or the ... A: For simple checkboxes and Options you would go to the Excel menu and select "View" then "Toolbars" ... | |
| Unhiding Columns | 7/11/2004 |
| Q: Excel 2000. Probably a stupid question, but ..... I hid some columns in a worksheet by using the ... A: There are no stupid questions here. to Unhide columns select the column to either side of the ... | |
| spreadsheets | 7/10/2004 |
| Q: I am trying to find a program to opem my expense reports. I have the viewer but I need to be abel ... A: Why not just buy Excel. You can buy an older version of Excel pretty cheap on www.Ebay.com search ... | |
| clip board | 7/9/2004 |
| Q: I am in Excel 1, using MO Excel 2003 Core Skills book, we are in Chapter 2, and I would like to find ... A: I am sorry I do not know the answer to that one. You would probably have better luck posting on ... | |
| Show less than percent display on a chart | 7/9/2004 |
| Q: Ken, I am displaying percentages on a pie chart. Values less than 1% show up as 0%. I would like to ... A: I am sure a macro can be written for that. But I do not have enough VBA knowledge for it. One thing ... | |
| Working with Macros | 7/8/2004 |
| Q: So I decided to create a Macro for my documents as you suggested in an earlier question. But now I ... A: I have to run to do something tonight. I will respond in the morning. But for right Now I wanted to ... | |
| find a specific cell | 7/8/2004 |
| Q: I am working on a project that has 40 sheets what I would like to do is to have a macro that would ... A: There are several things you can do to be able to see what is on another sheet when you are working ... | |
| Excel template capabilities | 7/6/2004 |
| Q: My name is Kevin Houle and I am an employee for the NS dept of Finance. I have recently been ... A: Also another thing you can do. Is open a copy of a downloaded book that you want to apply your ... | |
| Excel for macintosh | 7/3/2004 |
| Q: I try to use Excel at my I book G4. It comes with Panther and some Window software, like Excel.Do ... A: There is nothing wrong with your formula. =C2*15/100 That formula would return 15% of the value in ... | |
| #value! error | 7/1/2004 |
| Q: Hope you can help. The formula below returns the error #VALUE!. The formula is on a separate ... A: There is nothing wrong with the following formula you sent. =sum('Week 1'!F7+'Week 2'!F7+'Week ... | |
| Add hours to a date | 6/29/2004 |
| Q: I have a date format in Cell E2 (6/21/2004 23:55) I want to be able to add 20 hours to this date and ... A: That's a great question. In Excel time is represented in whole numbers and decimals. The number 1 ... | |
| Excel Macros | 6/25/2004 |
| Q: I'm have a spreadsheet that is already create and has all the printing macros and formulas. But ... A: You can convert Excel spreadsheets to pdf files but I believe they will not have formulas and macros ... | |
| Lookup returns wrong value | 6/21/2004 |
| Q: I am using excel 2000. I have a lookup formula on one tab that references data on another tab. First ... A: Can you send me a sample of what you are trying to do. It is difficult to understand in the email ... | |
| if-then macro | 6/20/2004 |
| Q: I would like to create an if-then macro. I have a column of numbers ranging from 0 to 100. I would ... A: This Macro should work for you. Just adjust the ranges to fit your ranges. Sub CheckValues() Dim n ... | |
| excel | 6/13/2004 |
| Q: Is there any way to make a cell in Excel print out a figure in dollars (like for a check). In other ... A: You cannot do it without programming with VBA. You can download a program called Asap utilities ... | |
| Subtraction | 6/12/2004 |
| Q: This is probably the dumbest question you'll get today. Indeed, it is not even quite a spreadsheet ... A: No dumb questions here Steve. I am not familiar with how Word Tables work. But I tried out in Word ... | |
| Making Text appear | 6/11/2004 |
| Q: I am using MS Excel 2003 and I am attempting to create a cell that appears only if another cell has ... A: If you use the IF Function you can do that. Such as. =IF(A1="Yes","This text will only appear if ... | |
| Using text in formula result | 6/9/2004 |
| Q: G'day, I wanted to insert the text "Paid" in a simple copy formula of a currency value with 2 ... A: Just change your formula to this. ="Paid $"&A1 Also make sure that cell A1 is formatted with two ... | |
| "Include" | 6/2/2004 |
| Q: My current question is: I have a list of phone numbers in Excel (068-919122, 054-356411 etc.) I wish ... A: If you type the number you want to find in Cell A1, such as 9191. And your list of phone numbers is ... | |
| Sorting | 5/31/2004 |
| Q: When I try to sort data on an EXCEL spreadsheet it appears I can only do so for a limited number of ... A: I am not sure why this is happening. I have not been able to find a limit on the number of sorts for ... | |
| Default Column Reference | 5/28/2004 |
| Q: It seems I should be able to figure this simple question out myself, but after about 45 minutes ... A: You are in what is called R1C1 reference style. To change back go to the Excel menu and select ... | |
| Ranges within IF Statements | 5/27/2004 |
| Q: I am trying to write an IF statement but I am needing it to incorporate a range such as: IF cell A1 ... A: You need the AND functin for multiple conditions. Such as =IF(AND(A1>200,A1<300),"Yes","No") If ... | |
| Formula for Averages | 5/20/2004 |
| Q: I am the Administrator of a Nursing Facility. I want to track my census on one unit based on payor ... A: What you need is an array formula. An "Array" formula is a formula, but instead of pressing the ... | |
| Excel 2000 | 5/3/2004 |
| Q: Is it possible to do a VLookup where the Lookup Value is actually combination of 2 cells? Say I ... A: As far as I know VLOOKUP will not lookup two Items. I believe part of the reason is that VLOOKUP is ... | |
| Printing Excel Spreadsheet | 4/26/2004 |
| Q: We have a huge spreadsheet set up in Excel, that has a few formulas in it but otherwise is not ... A: This leads me to believe something else may have happened. Do you share the same printer? Did ... | |
| blink | 4/19/2004 |
| Q: how can i write a function that make the txt blink in a cell A: You can paste a little bit of code and get that to happen. Here's how. This comes from John ... | |
| re: decimal places | 3/29/2004 |
| Q: morning, i am working on a sales spreadheet, and have encountered the follwoing issue. It is a ... A: In column J the formula would be. =IF(OR(I2="", ... | |
| Vlookup | 3/28/2004 |
| Q: I am using a vlookup formula to extract data from a 2 column database. The formula works fine when I ... A: Not exactly sure why that is. But I would try this when you go to paste. Right click and select ... | |
| Excel Header Help | 3/18/2004 |
| Q: I need to change the top column headers (ie: A, B, C, etc.)of a standard Excel spread sheet to other ... A: It is not possible to change the column headings from A,B,C. Excel will not allow you to do it. I ... | |
| Coverting Birthdays | 3/17/2004 |
| Q: I have two questions. First, I was given a spreadsheet with the birthdays of about 15,000 people. I ... A: You can do the formula a couple of ways. This first one will simply give the years such as 54.64 ... | |
| Paste Special automatically | 3/15/2004 |
| Q: I wish to have 12 cells for each month of the year which will contain the value of another cell ... A: Yeah sorry about that, I mentioned sending me a file and didn't give you an address. You can send a ... | |
| Can help you me with this... | 3/15/2004 |
| Q: Can help you me with this problem I use excel 2003 In cell A6 display the value "Desk" but i want ... A: I don't know how to change languages automatically. But you can certainly create a table to switch ... | |
| excel formula | 3/13/2004 |
| Q: the absolute function. ie $ when dragging a formula across many cells the numbers change i want the ... A: That's a great question. Put the $ sign in front of what you want to remain constant. You want the ... | |
| Excel 2000 Workbook Links | 3/12/2004 |
| Q: I have an excel workbook, that when I open it, it asks if I would like to update links. At one ... A: In Excel 2002 they have a break links button to get rid of the links. This has been a problem for ... | |
| anniversary dates | 3/11/2004 |
| Q: I have a list of dates in column A. Is there a formula I could enter in column B and copy down the ... A: Without using Visual Basic programming I made a formula to check the date in cell A1. If your first ... | |
| Excel Question | 3/11/2004 |
| Q: I am in the process of creating monthly time sheets in excel 2002, across 7 worksheets, for a ... A: I am assuming that you would like to know how much an operation would cost at the end of the month. ... | |
| NETWORKDAYS and MEDIAN? | 3/10/2004 |
| Q: I have a spreadsheet that I have made in Excel that calculates our turn around times on patient ... A: I don't quite understand how your spreadsheet works. But I would assume there is a range of cells ... | |
| Impossible to Open Excel | 3/10/2004 |
| Q: Before i start the question, let me notify that I am using Windows 98 and Excel 2000.We all know, ... A: I do not know of a way to have Excel itself password protected. I am not sure how Windows 98 works ... | |
| Excel formula | 3/6/2004 |
| Q: I would like to know how to add together the results of other formulas. What I have is a column ... A: Yeah, I am not sure if I totally understand your problem. You can sum a number of columns by ... | |
| macros | 3/4/2004 |
| Q: What are the 2 ways to create macros in excel? A: Macros can be made by going to the Excel menu and selecting "Tools", "Macro", then "Record New ... | |
| Macros | 3/3/2004 |
| Q: I have a spreadsheet written in Excel 98. It extracts data using a Macro and quesy from Dbase table ... A: This definitely is a little complex problem. The closest I got to any answer was through Microsoft ... | |
| excel formula | 3/1/2004 |
| Q: Job Category Award Level Ring glass CD Med 1 2 x x 2 ... A: As I mentioned I would get back to you. I believe programming be your best solution. Here is a look ... | |
| Data entry from from MSAccess | 2/29/2004 |
| Q: I have a simple XL sheet for tracking weekly attendance that I call from an application made with ... A: This is one of those questions where there are so many different ways to accomplish possibly what ... | |
| Excel web query | 2/27/2004 |
| Q: I am trying to do a web query with Excel, but I keep getting the error message "Cannot open ... A: I certainly cannot say I know more than the Microsoft Knowledge Base. A good place to look for ... | |
| Combo box / Validation box | 2/26/2004 |
| Q: Excel/Office XP 2002 Spreadsheet users must be able to select (from a drop-down list) multiple ... A: Actually you answered it yourself. You need Data Validation. The following will input a dropdown box ... | |
| How to create unique item numbers | 2/23/2004 |
| Q: I'm building a spreadsheet with Mac Excel X (basically identical to Excel in Office XP) to track ... A: I apologize for not answering sooner. First of all I had problems thinking about your problem. I ... | |
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
Ken Marron
Top Expert on this page
Expertise
I enjoy answering even the simplest questions. But I feel I am prepared to answer some advanced questions too. I have written complex formulas needed for my own company. I have some limited knowledge of VBA.
Experience
I have worked with Excel for 18 years. I have developed some of the applications necessary for a construction company. Including a labor estimating program that we use.
©2012 About.com, a part of The New York Times Company. All rights reserved.