You are here:
Excel/Questions Answered by Expert Richard Roberts
| Subject | Date Asked |
| Multiple Y axis | 11/18/2009 |
| Q: i want to know whether is it possible to have more number of Y axis in a single graph with different ... A: Shimjith I am pretty sure you can have more Y axis, but I do not know if you can have different ... | |
| Excel | 11/17/2009 |
| Q: Robert, I have two columns in excel columns are areas,GFA below is my excel sheet Areas ... A: Bhuvana I'm not totally sure of your criteria for putting in T or R, because the 5th row says ... | |
| formula for billing | 11/16/2009 |
| Q: I have a contract start date of 12/1/2009 and a contract end date of 12/1/2010. I have a "billed" ... A: Irene If you have a column for the last billed date then you just need to add 30 days to that last ... | |
| activecelloffset problem | 11/11/2009 |
| Q: I would very much appreciate your advice. I need to paste the content of an autosum cell on one ... A: RON I can't see anything wrong with your code, but I am definitely not an expert in VBA--. I ... | |
| Logical FUnction | 11/10/2009 |
| Q: ! I want to enter a logical formula. Lets say if have multiple values in a single cell and i want ... A: sandeep If your values are fixed as in your example, it will be easiest to write the formula using ... | |
| count if | 11/8/2009 |
| Q: I have two criteria in column C "individual,"organization" I need to switch between the two , using ... A: Bill I am not sure that I am reading the question correctly but-- You can use data validation to ... | |
| Fuctions Running Automatically | 11/7/2009 |
| Q: I am doing this in VBA because when I write if statements in excel itself it causes a circular ... A: Eric I am definately not a VBA expert--while I may be able to figure out an answer for you It won't ... | |
| Question | 11/6/2009 |
| Q: Here i got a question , I have a Different named seperate work books about 56,presently iam ... A: sree You need linking formulas to bring the data over to the master book. A linking formula will ... | |
| Time | 11/4/2009 |
| Q: Here's the expected result: IF F1="" and H1="" then C1=do nothing IF F1=something and H1="" then ... A: Polo Very often the problem with time is the formatting. If I copy your formula to a spreadsheet ... | |
| re-question | 11/3/2009 |
| Q: i questioned this to another expert and i was replied that it was out of their expertise. if it also ... A: Camron Okay I think I understand better now-- I don't have the time to create the calendars for ... | |
| re-question | 11/2/2009 |
| Q: i questioned this to another expert and i was replied that it was out of their expertise. if it also ... A: Camron First let me suggest that you check out the help section, there are many calendar templates ... | |
| Array- performing 2 column lookup | 10/30/2009 |
| Q: I have a multi-worksheet file.. on the first worksheet I am trying to perform a two-column lookup ... A: Kath Based on how the formula is written--I am not understanding what the formula is trying to do. ... | |
| Automatically entering data in Excel | 10/29/2009 |
| Q: I am trying to create one excel workbook that can have data entered on two different sheets and end ... A: John I believe your situation can be handled by links between sheets. Sheet2 can have a link to ... | |
| Finding unmatched data using macro | 10/28/2009 |
| Q: I need to combine two workbooks into one workbooks and than i need to find unmatched data between ... A: Audry Its pretty easy to transfer the data from one spreadsheet to another by using the copy paste ... | |
| Help with IF function | 10/26/2009 |
| Q: Here's what I got. =IF(C2*A2-B2*1.055<=0,0,"") --If the equation is equal or less than 0, I want ... A: Tom The formula should look like this-- =IF(C2*A2-B2*1.055>0,C2*A2-B2*1.055,0) Note that I said ... | |
| if, else statement | 10/25/2009 |
| Q: Richard, I have an equation that references a few cells to get an answer. That's not the problem. ... A: ALAN You may be able to correct your error by changing the references in your formula or the ... | |
| Vlookup doubt | 10/23/2009 |
| Q: I am having 1000 records sample, the records contains the details like Roll no, name, age, sex, ... A: Guhananthan Yes you can use the VLOOKUP() function to solve your problem Assuming in sheet 2 you ... | |
| Excel Question regarding Strikethough | 10/22/2009 |
| Q: I have already tried asking one expert, and he didn't know, so I'm hopeful that you can help me. I ... A: Donna The strikethrough feature only works as a strikethrough of the value in the cell, so you have ... | |
| Formula troubles. | 10/21/2009 |
| Q: I have created a spreadsheet for keeping track of items and equipment that require calibration at ... A: Ian In your COUNTIF formula use the same criteria that you are using to create your conditional ... | |
| Excel time-count | 10/20/2009 |
| Q: Is there a time-count-feature in the 2007 Excel? A possibility to use seconds, minutes and hours, ... A: Torsten I usually use a combination of the NOW() formula and copy/paste special to calculate the ... | |
| Formula copy | 10/18/2009 |
| Q: My issue is the VB code has 51 columns containing formulas in a template and all but three columns ... A: Diane Can't really tell much without the VB code. I may not be able to resolve it even with the ... | |
| Count & sum on different conditions including by weeks | 10/17/2009 |
| Q: I want to have a formula that count & sum the values from a Sheet on different conditions(4 or 5 ... A: Nadeem I can't get yur example to come up, but I think I can answer the question without it, the ... | |
| Data Validation | 10/14/2009 |
| Q: "Hi Sir, first up all thanks for previous help it's rreally helpfull for me. here i want to create a ... A: VAIBHAV Data validation won't work very well for you but you can use an IF formula to achieve what ... | |
| Copy characters from a string | 10/13/2009 |
| Q: I am having 10000 records. Sample A1 B1 C1 Name Code Date Samu ... A: Suresh First I would use the & formula to put the characters together, then I would use the text to ... | |
| Cell automatic color change | 10/12/2009 |
| Q: I'm working on a comparative table which has items on lines and suppliers offers (for each item) on ... A: Blancata I can't tell exactly how your data appears--so it is difficult to answer specifically, but ... | |
| Excel | 10/9/2009 |
| Q: I am working on an excel sheet to help me with making a material list when I build kitchen cabinets. ... A: BRAD I think a VLOOKUP() formula coupled with a list of the types of cabinets will work for you. ... | |
| removing text from a string | 10/8/2009 |
| Q: A051-ALEXANDER., WILLIAM MS51K -OVAL 10X8-A000051 how do I remove the A051- from the above. I have ... A: Elaine Assuming the entries are all n the same column, I believe that the use of the text to ... | |
| date and time | 10/7/2009 |
| Q: i am working on my excel sheet and i wonder if we could use data validation for both log in and log ... A: Jude I have found that the easiest way for me to freeze the time based on an occurance is to use a ... | |
| Formatting using an if statement | 10/4/2009 |
| Q: I want to be able write a formula that changes the color of a range of cells if certain values exist ... A: JON You can use the conditional formatting feature to do your formatting. It is found at ... | |
| Excel Template wizard | 10/2/2009 |
| Q: I am using a excel template to capture on database, unfortunately I have to open both template and ... A: Aji When you copied the folder to the desktop did the links remain linked to the old folder or did ... | |
| Excel Template wizard | 10/1/2009 |
| Q: I am using a excel template to capture on database, unfortunately I have to open both template and ... A: Aji Check the following-- With your template open--Go to toolbar/tools/options Select Edit and make ... | |
| Formatting Time | 9/30/2009 |
| Q: Roberts, I'm trying to figure out how "calculate clock time". For example, the first column is Duty ... A: Josh The problems with calculating time differences usually are the result of formatting and data ... | |
| Excel data sorting | 9/29/2009 |
| Q: I have multiple columns, so for a particular client name, I have the corresponding country, solution ... A: Sathya It is difficult to read into your questions exactly how you are arranging your data. etc. ... | |
| Excel 2007 | 9/27/2009 |
| Q: I downloaded a spreadsheet into escel. My negative signs are to the right of the numbers. How do i ... A: Ruth The minus behind the number indicates that the number is being recognized as text by excel. ... | |
| Linkage issues | 9/25/2009 |
| Q: I build complex financial models in excel and therefore frequently use the formulas Sumif, ... A: Tristan One of the things I use is to turn off the automatic calculation and use the manual calc ... | |
| Macros and pivot tables | 9/24/2009 |
| Q: grateful if you could help. I have created a pivot table and wish to select from the drop-down ... A: James Sorry I don't fully understand the what you need, and if I did I might not be a good one to ... | |
| Linking multiple excel sheets and retaining the values | 9/19/2009 |
| Q: I've a query in which i need the master data to be updated in subsequent sheet on a every day ... A: Rajaram I believe the easiest way for you to handle this is to use a copy/paste special/values in ... | |
| If formulas for reminders. | 9/18/2009 |
| Q: I have to follow-up for some documents.So After one month of my first request, I will send second ... A: Ram I am a bit confused as to whether you have three columns for the reminders or two because in ... | |
| How to direct Excel to select from the intersection in a table | 9/16/2009 |
| Q: I have a table of costs on a spreadsheet. The top row lists the number of units to be created and ... A: Dorell The formula to look up the value at the intersection of the row and column is-- ... | |
| Calendar | 9/15/2009 |
| Q: Sir, I have in One workbook contains three tabs (on 1st tab - Faculty & 2nd tab - Rooms details & ... A: Bhavanh Sorry I am having difficulty wading through the information to determine the ... | |
| Duplicating Cells | 9/14/2009 |
| Q: I am having trouble searching for the solution to simply automatically duplicate cells within a ... A: Alex I am not sure how your data is being input, but assuming it is being input into column A, then ... | |
| formulas/copying sheets | 9/13/2009 |
| Q: I have separate sheet that summarizes certain information from other sheets via formulas in the ... A: Jeff Obvious answer and I am guessing one that you have thought about would be to copy the entire ... | |
| Automatic Highlight | 9/11/2009 |
| Q: I have a basic table which I enter names and dates into, I am trying to get excel to highlight ... A: Leanne You can use the conditional formating feature to do wht you want. It is found on ... | |
| Macro Help | 9/9/2009 |
| Q: Good Morning, I'm trying to write a macro that will identify a particular set text in a cell for all ... A: JOHN I think we can do what you want with an IFTHEN formula, something like this-- = ... | |
| Can excel do this? | 9/8/2009 |
| Q: I am fairly familiar with excel but what I’m trying to do now has me stumped... I’m tracking ... A: Gary The easy part of your question is can excel to it. The answer is yes excel can do almost ... | |
| Formula huge, needs simpler solution. | 8/23/2009 |
| Q: I'd be so grateful for help, suggestions, please. What I have now is this: TAB 1 is: CLIENT INFO & ... A: Nico I am not totally sure that I am following how your data is set up but I believe you can use ... | |
| moving data | 8/22/2009 |
| Q: I have a worksheet of accounts receivable and other worksheet of collections, presently I copy ... A: Edgar You can use an IFTHEN formula to determine that the account is over thirty days and then move ... | |
| Excel TIme help | 8/21/2009 |
| Q: I am using Excel 2003. I am creating a time sheet. I am having a problem . For example if an ... A: Tom Here is the formula that will convert the time formatted as HH:MM AM/PM to a decimal number. ... | |
| cross reference 2 sheets | 8/20/2009 |
| Q: I have 2 excel spreadsheets. One of them is a list of companies that I downloaded from Hoovers that ... A: Steve You can use the VLOOKUP() function to find the matches and isolate those that do match. If I ... | |
| HELP PLEASE!! | 8/18/2009 |
| Q: I hope you can give me the solution! I have a MONTHLY Excel spreadsheet generated from Pastel. It is ... A: Lisa Yes you can do what you want--however how to do it will depend on what your data looks like, ... | |
| IF Then Statement with a total sum | 8/17/2009 |
| Q: I am trying to write a statement based on: if column K has the company name 'Premier' then pull the ... A: Sara You didn't give me your formula so I can't tell exactly how you have written it, but based on ... | |
| How to Arrange Data from one Sheet to Another Using VBA ? (From Columns to Row) | 8/15/2009 |
| Q: i want the following data from INPUT Sheet to be shifted to OUTPUT sheet in following way using VBA, ... A: Nadeem This is the way I would solve it. 1 Sort the data by MOP then by contract then by job. 2 ... | |
| Is Function to change cell format? | 8/14/2009 |
| Q: I am trying to chagne the format of a cell to percent or numeric format based on the text that ... A: Tania I haven't had the need to do this in the past,and since the conditional formatting feature ... | |
| different coloum how to protect | 8/13/2009 |
| Q: How to protect different coloum in excle. I created one file. In this file lot of formula is there. ... A: Suresh Select the entire worksheet by clicking the Select All button (the gray rectangle directly ... | |
| VLOCK in excel | 8/12/2009 |
| Q: I am trying to get a picture to automatically enter into a cell when I select from drop down menu of ... A: Alex I have not done this before and I have not been able to figure it out very quickly. The ... | |
| How to Count the unique cells from a set of Duplicates , using VBA ? | 8/10/2009 |
| Q: The Following data need to <COUNTED> upon Condition using VBA like first Column has Duplication of ... A: Nadeem Unfortunately the COUNTIFAND function doesn't work in excel, so what I usually do is combine ... | |
| Excel Date cond formatting | 8/8/2009 |
| Q: I update data as explained below: A1 column: The date showing the data updated B1 column: Date in ... A: Mari You can use conditional formatting. Go to toolbar/format/conditional formatting In the pop up ... | |
| EXCEL | 8/7/2009 |
| Q: Sir, Suppose in one coloum i am typing for eg 4.5ft (4 denotes feet & .5 for inch). Now what i want ... A: tathagata The "text to column" feature should work very well for you. First paint the cells that ... | |
| Comparing rows | 8/6/2009 |
| Q: How do you compare rows in 2 different sheets(same excel file) to determine the missing row? ... A: Jose I am guessing that you are using the IF() formula that I gave you in the previous answer and ... | |
| Expenses Between Two Dates | 8/5/2009 |
| Q: Good Day! I have a worksheet (2003) containing my daily expenses. Say A-Date, ... A: Anthony Yes it is possible, here is how you do it. ... | |
| Excel - Sum Dollars of Two Met Criteria in an Array | 8/3/2009 |
| Q: Richard I am looking for some excel help. What formula would I use to sum dollars that match with ... A: Jay What you need is the sumifand formula, unfortunatley this formula won't work in excel, So what ... | |
| Random Selection of cells and values averaged. | 8/2/2009 |
| Q: I am trying to randomly select a 7 cell range column wise from an array B1:M30 - (e.g.- B2:B9 ... A: Rahul I have only needed to do this once, and as far as I know there is no function in excel that ... | |
| Fill Blank In Series Cells In Excel | 8/1/2009 |
| Q: I have an excel in which the "D" column contains numerical data in sequence like 1, 2, 3, ... A: Supriyo You can use this formula in column F =IF(F6=1,F6,G5+1) This formula looks at column F ... | |
| Comparing rows | 7/30/2009 |
| Q: How do you compare rows in 2 different sheets(same excel file) to determine the missing row? A: Jose You can compare data in rows in two different sheets using the vlookup formula. Assume you ... | |
| Data Validation in combination | 7/28/2009 |
| Q: I am interested to check the combination of 03 columns entries. This combination must be unique. Any ... A: Faisal I am not sure that I completely understand your question, but I do not believe we can get the ... | |
| split a string | 7/26/2009 |
| Q: .. Say I need only numeric potion of a thousand of alpha numeric string by formula...how cud I get ... A: Arindam One way to get you desired result is --if the numbers are consistently in the same place in ... | |
| to highlight related cells | 7/24/2009 |
| Q: I have a worksheet for managing all documentation at our place. I was trying to come up with a macro ... A: Sumit One simple way to handle it would be to use the conditional formatting feature, and use the ... | |
| Rounding | 7/23/2009 |
| Q: How do I round a number to the nearest 25 ie 2870 to 2875 or 1105 to 1100 in Excel. No decimals ... A: Zan I'm not exactly sure about your question, because you are asking to round to the nearest 25, ... | |
| Room Booking worksheet problem | 7/21/2009 |
| Q: I am working on a Room Reservation system and i am having difficulty with bookings. I can block a ... A: James Without knowing how your worksheet is set up it is a bit difficult for me to be specific. ... | |
| Check insequenced numerical data in excel | 7/20/2009 |
| Q: I have an excel in which the "D" column contains numerical data in sequence like 1, 2, 3, ... A: Supriyo You can use a formula thats tests the cell to determine if it is equal to the prevcious ... | |
| truncate text / numerics | 7/19/2009 |
| Q: Probably a very basic question but... I have a column of data for which each field comprises ... A: David You can use the formula =left() Assume the cell A1 contains d4j3256 The formula Left(A1,3) ... | |
| excel | 7/17/2009 |
| Q: i am working in my journal in sheet 1, trial balance in sheet 2 and working trial balance in sheet ... A: Crisca I am not sure exactly what the question is but maybe this will help--the easiest way to ... | |
| IF SUM VLookup Match | 7/16/2009 |
| Q: Richard: Answer given in the following link: ... A: Edgar Because the SUMIFAND() doesn't really work well, one of the approaches is to create a single ... | |
| cell display based on current date | 7/14/2009 |
| Q: I am wondering if there is a formula or macro that will look at the current date and place my chosen ... A: DAVID Yes I'm sure you can achieve what you want, but I'm not eactly sure how you are going to ... | |
| invoice #s | 7/13/2009 |
| Q: I use excel at work to enter the information on checks written out. I have columns for check #, ... A: Beth Here is a method that might work for you-- You could use the data validation feature (not ... | |
| Time sheet Formulas | 7/12/2009 |
| Q: I have time calculate the total working hours for each employee per day and I want a Formula can ... A: Elham The formula to calculate the actual and needed hours is simply subtracting one form the ... | |
| If statement | 7/10/2009 |
| Q: I need an IF Statement for certain numbers in a cell. Example: Cell B2 has MJ244F001057 in it. I ... A: Debbie You can use the search feature to identify whether the cell contains 1057. the search will ... | |
| qu | 7/9/2009 |
| Q: someone showed me how to call up a dialogue box which showed you what columns were hidden in a ... A: Steve Sorry I couldn't get back to you quicker I had a bad router. I cannot find anywhere that ... | |
| Cell protection | 7/8/2009 |
| Q: I am trying to protect certain cells on one spreadsheet of the workbook, and allow users to enter ... A: Debbie sorry I won't be able toa nswer the question at this time, I have very limited access to the ... | |
| using vlookup | 7/7/2009 |
| Q: i am using two worksheets, i need to search a particular field and get the value in the next row. ... A: William Perhaps I didn't explain my answer properly, but the method I gave you does exactly what ... | |
| using vlookup | 7/6/2009 |
| Q: i am using two worksheets, i need to search a particular field and get the value in the next row. ... A: William You can, most easily, use an if formula to find the data. For example Assume that sheet1 ... | |
| COUNTIF -- multiple conditions | 7/4/2009 |
| Q: This is having to do with one column T4:T105. Counting cells in this column that contain TIMES in ... A: Tim Try this formula =COUNTIF(T4:T105,">:0")-(+COUNTIF(T4:T105,">:11")) This counts all of the ... | |
| Copy certain data from the text file to Excel | 7/3/2009 |
| Q: I have text files which contains lots of numbers and their respective description. Example : 1|213 ... A: Raghav It appears that you have a problem just because of the volume of the data. If I am ... | |
| Excel - inserting decimals | 6/29/2009 |
| Q: I many cells that are populated with whole #'s for example 3371 3550 4450 11150 and I want them to ... A: JUNE By the time you get this answer I bet you will have already thought of this. You can divide ... | |
| Vlook up | 6/28/2009 |
| Q: Can you please tell me how to do a v look up? I'm trying to insert names in a column from a prior ... A: Elaine Assuming that you have read the help section of excel regarding VLOOKUP, I am trying to ... | |
| Adding 10% to a formula | 6/26/2009 |
| Q: 110 220 10 120 230 20 130 240 I have my excel worksheet set up with a formula that looks like this ... A: Char I am not clear on what cells the amounts you have listed are in. But reading the question, it ... | |
| Excel - comparing date fields | 6/25/2009 |
| Q: I'm trying to compare 3 date fields in Excel and determine the earliest of the 3 dates. Can you ... A: Pam You can use the =SMALL() formula which might look like this--- Assume the dates are in the ... | |
| Countif unique and if function | 6/24/2009 |
| Q: I'm desperate for some help with a formula I just cant crack! I have a column (D) which contains ... A: Ed The countif doesnt really work with criteria, I.E. countifand, so what I usually do is combine ... | |
| formula | 6/23/2009 |
| Q: I have this big spreadsheet to do where the there are different answers given to a number of ... A: Roxana I believe you can use the countif formula. The formula looks like this Assume the answers ... | |
| Excel: Counting number of occurnces of a word which is offset to a word (to be searched) | 6/22/2009 |
| Q: I want to know a formula for this. Say I have a table from A1 to C21. A1 is Date B1 is Heading 1 C1 ... A: Kunal The countif formula will not work with more than one critieria, so you can't do a countifand ... | |
| match and look up problem | 6/21/2009 |
| Q: I need your help for followings : I made a table A1 = BCR50 A2 = BCR60 A3 = BCP100 B1 = 50% B2 = ... A: fkwan I do not see a specific question, but I will assime it is how do I write a formula in C3, ... | |
| count the specific data in multiple sheets | 6/20/2009 |
| Q: i have got multiple sheets by date of whole month .Column A contains customer name visited by our ... A: Arsa You can use th countif formula. Your references to range just have to include the sheet name. ... | |
| Excel problem | 6/17/2009 |
| Q: Basic Excel issue. Normally if you autosum a column of figures, and then change one of the figures, ... A: Nesta I haven't seen the second problem and I can't seem to duplicate it. But it seems as though ... | |
| sorting in pivot tables with more than one row section | 6/16/2009 |
| Q: I know how to sort in pivot tables with one row section. However when i increased the number of row ... A: VOLKAN I am not an expert in pivot table manipulation since I seldom use them--I suggest you reask ... | |
| Identify possible source of errors for out-of-balance amount | 6/15/2009 |
| Q: Currently, if a cashier is out of balance, then we perform a manual process of trying to identify ... A: RAMIZ How about this formula =IF(D6/9<>+ROUND(D6/9,0),"","TRANSPOSITION") Where D6 is the cell ... | |
| Excel Chart Properties | 6/14/2009 |
| Q: Is there a way to get the data values for a single point from a chart. I would like to be able to ... A: Jim I am pretty sure that you can do what you want to, but I am not an exepert in charting and ... | |
| Import data from various workbooks | 6/13/2009 |
| Q: How are you? I have two questions relating to excel VBA which I am puzzled and stucked. I have ... A: Justin I am definately not an expert in VBA- I suggest you reask the question of another ... | |
| optimization using integer linear programming | 6/12/2009 |
| Q: is it possible to solve the following optimization problem in excel using integer linear ... A: Harpreet This is not the type of problem that I work with, therefore I don't really have the ... | |
| Excel Date Entry | 6/11/2009 |
| Q: Richard, I was reading an answer that you gave for automatically entering a date in a cell when ... A: Jack The concept is to use either now() or today() to date stamp the entry, but as you know the ... | |
| Excel | 6/10/2009 |
| Q: Richard, This might sound like a really dumb question but everyone I work with could not give the ... A: Amanda Sounds like the issue is definitional, what does markup mean. Generally the term markup ... | |
| Creating Menus for Macros | 6/9/2009 |
| Q: In Quattro (!) creating menu drop-down menus seemed to be easy, now I’m using excel 2007 and it ... A: Joff Drop down menus can most easily be created by using the data validation feature. First create ... | |
| Sorting Data | 6/5/2009 |
| Q: I have a sheet that I created that calculates data for a group of surveys received by a team. I have ... A: Paul I answered this question several days ago but apparently didn't push the right button to get ... | |
| 2 columns using Countif | 6/4/2009 |
| Q: I wanna ask you some trick or how to resolve this problem in Excel using the Countif formula or any ... A: Oying The countif formula won't work with two criteria so you cannot do the countifand. What I ... | |
| How to change a date in a cell reference | 6/1/2009 |
| Q: I have a need to change out the date being referenced on a monthly basis, i.e. “Mar09” to “Apr09”. ... A: PAUL If I understand the question you are wanting to change the date in the link to the workbook so ... | |
| formula to calculate pay off date | 5/30/2009 |
| Q: if i have the principle, payment amount, and interest rate for a creditor, how do i calculate the ... A: Anita I usually create a table to do this that calculates each payment and the amount of interest ... | |
| VLOOKUP Function | 5/28/2009 |
| Q: I've a small query for you. I'm really in need of your help! I want to pull up data with keyword ... A: Mohammed Since it isn't easy to lookup either or,and you want your formula in one cell, and if it ... | |
| VLOOKUP Function | 5/27/2009 |
| Q: I've a small query for you. I'm really in need of your help! I want to pull up data with keyword ... A: Mohammed If I am understanding your question correctly the formulas you need would look like this. ... | |
| Excel 2003 | 5/25/2009 |
| Q: I have a hard time extending the units from one column to another. Examples: A5 Engl 1a, B5 ... A: Vitorino To extend the units to the desired column you can use an if formula For example in cell ... | |
| advanced filter with criteria area | 5/22/2009 |
| Q: I have a list. my headings are salespersons/product/qty/amt.billed. I need to know: 1) how to use ... A: Hannah I usually don't refer people to the help menu but I think in this case it will help you with ... | |
| Term Deposit interest | 5/20/2009 |
| Q: I have put in $10,000 into a TD @7.35% for 3 mnths. How much interest should I get. Can you also pl ... A: Jim The question is how is the stated interest calculated-- Is it compounded daily, compounded ... | |
| Creating a special column | 5/18/2009 |
| Q: I have very little experience with excel and i would appreciate any help. I basically need help ... A: Philip I am confused-- I am not sure if we are picking an average of six or 14 or???? Here are ... | |
| hyperlink problem | 5/15/2009 |
| Q: I have an excel sheet of names and addresses. I have created a hyperlink (the person’s name) to open ... A: Dom I do not use and haven't worked with hyperlinks in excel/word, so I have little expertise in ... | |
| automatically increment numbers every time you open the same template | 5/14/2009 |
| Q: I would like to know what formula to enter so that each time I open my invoice template, the invoice ... A: Lisa The procedure for making the invoice number increment is a bit more that a formula. It is a ... | |
| Excel 2003 | 5/12/2009 |
| Q: Roberts, I'm an instructor and I'm using the Excel 2003 to compute the ratings of my students. A ... A: Victorino I am guessing that the Unit you are speaking of is an assigned value of the course and is ... | |
| Comparison in excel | 5/9/2009 |
| Q: I have been assigned to compare the price of the 6 parties/Bidders and decide who is the L1 (i.e. ... A: RAVI You can use a formula like this ... | |
| VBA code - copy/transpose multiple columns record into individual single row | 5/7/2009 |
| Q: I am trying to do a Macro that will copy/transpose data from columns to row. from: Student ... A: Alex There is a bit of a problem with a transpose and that is that in addition to some ... | |
| copying & pasting a specific range | 5/6/2009 |
| Q: Sir, I have two coloumns A & b,A has set of data(text+numbers+Blanks)it also has range of numbers ... A: ANAND I hope I am understanding your question-- I would handle the problem with two formulas ... | |
| ms-excel 2000 | 5/5/2009 |
| Q: how can i create graphic objects in excel 2000 A: Babu Excel doesn't work easy with graphic objects, so usually what I do is create the object in ... | |
| Check if a cell is highlight in yellow | 5/4/2009 |
| Q: i have a spreadsheet which has some cells highlighted in red and some highlighted in yellow. I want ... A: Sudha What you want is difficult because the condition is within the cell that you want to change. ... | |
| Null Values shown in cEll | 4/30/2009 |
| Q: When I do an operation on a group of cells to show a result in a cell.the result cell shows a null ... A: David The #NULL! is the result of not using the comma when referring to two areas in a formula that ... | |
| Custom Formatting a Column Heading as "Profit/Loss" in a DataTable | 4/29/2009 |
| Q: Excel seems to want to put a negative sign in front of a "Profit/Loss" custom format heading for no ... A: Nicholas I can't tell exactly what the problem is, is it in the "heading" or is it in the numbers ... | |
| EXCEL | 4/27/2009 |
| Q: I am having a database in excel with master data of file no. each raw of data related to file no. ... A: Amit I appears as though you need to use a vlookup formula that will look up the identifier you ... | |
| EXCEL | 4/26/2009 |
| Q: I am having a database in excel with master data of file no. each raw of data related to file no. ... A: Amit try this formula =IF($A$1=1,+Sheet2!A1,"") This formula says If cell A1 is 1 then bring ... | |
| Drawdown formula | 4/25/2009 |
| Q: I hope that you can help me understand this excelI have End of Month Dates in chronological order in ... A: Frank I am pretty sure that I don't fully understand the question, but I am thinking that you can ... | |
| Assigning values to properties in a drop down menu. | 4/24/2009 |
| Q: I have seen that someone else has had this problem, however they did not seem to mind about getting ... A: Fee You can use a formula like this-- ... | |
| Changing excel layout | 4/18/2009 |
| Q: I have a cash flow spreadsheet that I would like to change in order to export to access. My layout ... A: Jack You can change the layout with some simple cut paste special etc. use the copy paste special ... | |
| Highlight Dates within 30 Days of Current Date | 4/16/2009 |
| Q: I have a 2003 Excel Spreadsheet that has a few Columns in it which contain Drivers License ... A: Tom Here is what you can do Use the conditional formatting feature found at ... | |
| Sumproduct Question | 4/14/2009 |
| Q: Richard, Kindly help me to solve this formula because I cannot get the right answer I want. e.g. ... A: Anibtu Sorry-- I can't seem to get a good answer for you very quickly, and I can't give it my full ... | |
| finding a company name | 4/13/2009 |
| Q: 1) I need to find whether a company name exists in a data set. I need to find if a list of ... A: Jie Since the name you are searching for may be in a string of text you can use the search feature ... | |
| Replacing cells with test based on dating | 4/12/2009 |
| Q: like in contracts the begining and end date and the calander monthly invoices, since each contract ... A: Bill I can't get your copy of the page to be large enough for me to read it, but--- If the date you ... | |
| Selecting Date & Time | 4/11/2009 |
| Q: This might be a simple question in relation to what you normally get, but I am quite new to Excel. ... A: Debbie What you probably have is data validation protection which can be found at ... | |
| Variable Data | 4/7/2009 |
| Q: I am trying to create a file for variable data import into Indesign CS3. I need to step and repeat ... A: Derren Here is what I would suggest First type in your names in one column (for example lets use ... | |
| Cell Value Comparison | 4/6/2009 |
| Q: I need some help from you. I really wish and hope you can help me on this. This is solve a very big ... A: Sirajuddin I may be misreading your question or the way your data is set up, but it looks to me ... | |
| macros | 4/5/2009 |
| Q: i need more detailed macros code for printing combinations for huge set of rows...can i get ... A: Cleopoatra I don't believe you need a macro, just some formulas to convert your data. First I ... | |
| Trying to calculate what each technician gets paid per job | 4/3/2009 |
| Q: I recently sent you a message, yesterday actually, and your response worked, but my formula is still ... A: Josh I am thinking that you could apporoach the problem totally different. but I may be wrong not ... | |
| Excel formatting | 4/2/2009 |
| Q: I am basically trying to tell excel to calculate the amount a job will pay out under certain ... A: JOSH You are limited to 7 imbedded IF statements, but you are not limited if you make the ... | |
| Excel 2007 Smart tags | 3/31/2009 |
| Q: I would be grateful for your help on this matter. I am working in a complex Excel 2007 sheet which ... A: Russell I can't seem to reproduce your problem, and of course that makes it difficult to solve. I ... | |
| Formula vlookup | 3/30/2009 |
| Q: I need a formula help: There are two excel worksheets: Worksheet1 shows in column A the dates (e.g. ... A: Jody Sorry to be late in answering, I must have missed your question. I am not sure if your ... | |
| making a word have numeric value | 3/29/2009 |
| Q: I need help with assigning the days of the week with a numeric value. I am testing the attendance of ... A: CAMMIE The formula should look like this: ... | |
| Finding number of characters in a cell and... | 3/26/2009 |
| Q: Please help me!!! It will be very helpful for me in my daily work.... I have an excel sheet and all ... A: Sirajuddin You can use this formula =IF(LEN(A1)=5,"00:"&A1,+IF(LEN(A1)=7,"0"&A1,"")) Where A1 is ... | |
| Transfering data between worksheets | 3/25/2009 |
| Q: I have a book w/ 7 different pages in excell. all the pages are different. I would like to ... A: Brian You need to create links between the sheets to transfer the data. Here is what a link ... | |
| External References in Excel - Reg | 3/24/2009 |
| Q: I have a question regarding using external references in Excel. I am using a formula something like ... A: Krishnamoorthy I don't work with networked drives so I don't have much expertise in that area. I ... | |
| how to lock particular rows and columns in excel sheet | 3/22/2009 |
| Q: I got an idea on how to lock the work sheet. If I need to (LOCK) set different passwords, for ... A: Prasanna I will refer you to the help section of excel..there is a very good explanation of how to ... | |
| Extract values form one sheet and display in another sheet | 3/21/2009 |
| Q: Roberts, I need your advise on a excel formula to automate the below task in excel. i have 2 excel ... A: Geeta If I understand your sheet setup correctly, I believe you can use the VLOOKUP formula to find ... | |
| VBBA / Macro to create last edit date in row | 3/20/2009 |
| Q: I am using this code: Private Sub Worksheet_Change(ByVal Target As Range) Cells(Target.Row, ... A: Mark I am definatly not a VBA expert--I know it can be done, and have done it, but I borrowed ... | |
| Input from the List Box (Form Control) | 3/19/2009 |
| Q: I have created a List Box in excel 2007. I want to write a macro, which will be activated after I ... A: Yevgeny Yes a macro can be activated with your list box selection. Unfortunately I am not a macro ... | |
| Excel VBA write text based on another cell | 3/17/2009 |
| Q: D, F, and H. If the data is > 0 I need to write "Past Due" in the corresponding neighboring cells ... A: Daniel The formulas should look like this In cell A1 the formula would be =IF(B1=5,"past due","") ... | |
| Ranking in Excel | 3/14/2009 |
| Q: I am trying to rank 200 stores from best cash to worst cash. I know how to do a simply sort but ... A: Troy A sort should work for you-- If you have these amounts in this order in column A -.15 -.11 ... | |
| changing font letters from Capital letters to small letters | 3/11/2009 |
| Q: Need to know if it is possible to change font letters from Capital letters to small letters in a ... A: Abdul The formula LOWER(A1)will change the value of A1 from upper case to lower case. You can ... | |
| cross-sheets reference | 3/6/2009 |
| Q: I use references from one sheet to other like =Sheet1!A4. I need rearrange Sheet1 (For example sort ... A: Vladimir The reference is to the cell, not the value in the cell, so when the values change in the ... | |
| missing dates in excel | 3/3/2009 |
| Q: "I will get data from a machine at every one hour. I have some historical data @ hourly basis i.e., ... A: Srikanth Working with dates and time is always tricky. I sugest that you use a formula that will ... | |
| changing the colour of a number based on result | 3/1/2009 |
| Q: I have put a formula in a spreadsheet that based on a the result the number counts down from -3 to a ... A: Marcus I'm guessing that you want to know how to make the cell format when the number is positive. ... | |
| Excel Query | 2/24/2009 |
| Q: The situation i have is i have several books published over different periods and i am just trying ... A: Matthew Sorry I cant tell from your question how your data is formulated , I.E. all in one column, ... | |
| highlighting on multiple tabs | 2/23/2009 |
| Q: I am wondering if there is a way to have Excel automatically highlight similar text through multiple ... A: John I'm not sure if this is exactly what you want to do, but You can apply conditional formatting ... | |
| Hi | 2/20/2009 |
| Q: Daily i will be recieving a exel file. Some information will remain same in the latest file. I want ... A: You can use the VLOOKUP() formula to find the data that is duplicated, place an identifier by them, ... | |
| Excel Protection | 2/19/2009 |
| Q: When i protect a worksheet, is there a way to stop someone selecting the whole spreadsheet by ... A: Robert You can't completely protect the worksheet, the copy paste virtually eliminates all ... | |
| Average date/multiple years | 2/17/2009 |
| Q: I have a list of events that occur once each year, on varying months and days. Column A = event ... A: Steve Sorry to be so slow I must have missed seeing your question-- The problem with averaging your ... | |
| issue | 2/16/2009 |
| Q: i have a spread sheet of various data, there are about 30 tabs with various data. i have just ... A: Adrian It sounds as though you have selected all sheets before input. To do this, if you are in ... | |
| Reg Sum Function | 2/15/2009 |
| Q: I want to add the following decimal values For example ------------ 1.12 2.23 2.34 Assume that ... A: GIRISH Here is the problem When you enter 1.12 excel thinks you are entering 1 plus 12/100 of 1. ... | |
| Importing excel data to update inventory pricing | 2/14/2009 |
| Q: I have created excel worksheet(s) for physically counting food inventory each month. Original data ... A: Dick I believe that you can use the vlookup function to recreate the new worksheet. For example. ... | |
| Excel IF statements query re dates | 2/11/2009 |
| Q: In Cell D6, I have a date entry in the format dd/mm/yy I require to report on this in E6. The report ... A: Scott Your formula should look like this. =IF(D4="","needs ... | |
| Collapsing Multiple Columns with Sum Count | 2/10/2009 |
| Q: Is there a way to collapse several columns of data and produce a "count" of all the duplicate data? ... A: Pieter Based on your question I am trying to envision the rows and columns that you are using, and ... | |
| Rate of increase | 2/9/2009 |
| Q: let's say, I have these numbers 5, 10, 20, 40. It's obvious that the increase rate is 100% per ... A: Rex I would approach it simply First in a separate formula calculate the percentage rate of ... | |
| Excel help | 2/7/2009 |
| Q: i have two ms-excel spreadsheet- spreadsheet 1 and spreadsheet 2. in the ms-excel spreadsheet 1 i ... A: Gaurav You can us the VLOOKUP function with a formula that might look something like this ... | |
| Pause And Continue If No Change | 2/6/2009 |
| Q: I wanted to Simiulate a day of stock trading where you could stop the progression of a line chart ... A: Steve Sorry I won't be able to get to the question for a while, I am in the middle of a major ... | |
| first zero disappears after "replace" | 2/4/2009 |
| Q: In excel XP/2007, I have a phone number column. Each phone number appears in the following format: ... A: MOSHE Excel thinks your entry is a number and doesn't show the 0 because it is not relevant in ... | |
| Excel bug - cell comments become uneditable | 1/31/2009 |
| Q: First of all thanks for offering your time to help with our Excel questions! Here is mine. ... A: Tudor Sorry I haven't experienced the problem and therfore haven't worked out any solution. Sounds ... | |
| Excel | 1/30/2009 |
| Q: since i met u u have replied me with all my queries with solution. Thanks. now i need is that when i ... A: Aman Aman I is not an easy conversion to make, excel thinks that you are entering a number not a ... | |
| formula | 1/29/2009 |
| Q: What I need is a formula to tell me the following; if title in cell range a1:a300 = sales than count ... A: Val Unfortunately what you need is a COUNTIF(AND) formula. but that won't work in excel. So what ... | |
| EXCEL FORMULA | 1/28/2009 |
| Q: Can you please advise me on the formula for finding the value of last cell in a row/ column. i ... A: Vineet I don't know of a formula that finds the last cell. If you are summarizing form data on ... | |
| Excel and Publisher | 1/26/2009 |
| Q: I am trying to mail merge about 300 accounts from Excel into a form letter in Publisher and cannot ... A: Megan I am not expert in mail merge/publisher, etc. But I would suggest you check the formatting ... | |
| Copy paste transpose in excel | 1/23/2009 |
| Q: Hai Richard, How are you, i want a formula or macro which will enable me to do the under mentioned ... A: VIMAL If you want to link the sheets this can't be done with the copy paste it should be done with ... | |
| how to create a master file | 1/22/2009 |
| Q: I created a workbook containing information about our employees. This workbook will be used by many ... A: Anna You can protect the worksheet that the users are using simply by going to ... | |
| Excel counting Months in a date column | 1/21/2009 |
| Q: I have a colum (A) with date format 01/12/09 I need to count the instances of each MONTH. For ... A: Rick In the B column try the formula =IF(A1=0,0,MONTH(A1)) If the cell is blank the formula will ... | |
| Data resorting in excel | 1/20/2009 |
| Q: I have a data in excel about derivatives downloaded from the internet. The data is in following ... A: Vishal If I am understanding correctly it should be relatively easy to drag the data to the column ... | |
| Hiding complitely sheets to other users | 1/19/2009 |
| Q: I need to hide sheets or columns to other users of an excel file. I know that exists the sheet very ... A: You can use a separate input area that will be used to transfer the data to the hidden columns. For ... | |
| Passing a formula down an excel column 2007 | 1/17/2009 |
| Q: I'm sure this is very simple - I need to copy a formula =G3-(G3/11) down a column to get the correct ... A: Fiona Sorry for not beign quicker-- I must have missed seeing your question in my e-mail. Ck your ... | |
| Hiding complitely sheets to other users | 1/16/2009 |
| Q: I need to hide sheets or columns to other users of an excel file. I know that exists the sheet very ... A: Eva You can use a combination of hiding information on a sheet and the security features ox excel. ... | |
| Sorting results with vlookup | 1/15/2009 |
| Q: I have a sales report that comes from our restaurant and bar. From this report, I need to generate a ... A: Ivan There are a couple of ways to handle the problem. One I often use is to sort the data by ... | |
| Excel Formula | 1/12/2009 |
| Q: I need to add together the highest 3 numbers out of 5. I thought I might be able to use the MAX ... A: KAREN I don't know if this will fit in for you but--the simplest way would be to sort the numbers ... | |
| Specifying any number | 1/11/2009 |
| Q: I have an excel spreadsheet where the numbers finish in either .1 or .2 or .3. I need a formula or ... A: DAN We need to first separate the digits after the decimal point so that we might test each of them ... | |
| Converting a number to seconds | 1/10/2009 |
| Q: Sir, I have a excel sheet where time is in the format of "10.34" (Number with 2 decimals) and need ... A: I cant tell from your question whether the 10.34 is 10 hours and 34 minutes, 10 minutes and 34/100 ... | |
| Merge the text of three columns into one | 1/9/2009 |
| Q: I have a spreadsheet that has a customers name divided into three columns: A:Last B:First I would ... A: JUAN You can use the & formula It looks like this. +B1&""&A1 The formula says first name(B1), ... | |
| excel | 1/8/2009 |
| Q: prior to my next question i will thank you fro replying my previous question which worked. i m in ... A: Aman Two different formulas can be used to effect the same cell. What you want is C1 to contain ... | |
| Calculating dates in Excel | 1/7/2009 |
| Q: I need to calculate a date in excel. eg I have a known start date on the spreadsheet and I want to ... A: Viki Sorry for the slow answer--I think I missed seeing your question in my e-mails. If you use ... | |
| DISPLAY HEADER FOOTER | 1/6/2009 |
| Q: I HAVE A EXCEL HERE WITH SAY 30 PAGES OR MORE, WHILE LOOKING/EDITING IT ON THE SCREEN I WANT TO SEE ... A: Ganesh I don't know of a way to view both the header and footer in a sheet and have the sheet be ... | |
| excel | 1/5/2009 |
| Q: pls send me ur personal email id so that i can send u attachment of my excel file where i find ... A: Aman I am not sure from your question what the base amount in cell B1 is --on the one hand if it ... | |
| Create a reset button | 1/3/2009 |
| Q: I have two columns with data: Column A Column B name 1 S1 name 2 S2 name 3 ... A: Dennis This may sound to simple, but probably the easiest way to handle it is to create a template ... | |
| Exporting a task to Outlook | 12/31/2008 |
| Q: I meet customers often and their discussions are minuted in Word or Excel. Often, if not reviewed ... A: Brian I am not understanding your question--I think I would if I knew what the word "minuted" ... | |
| sorting and filtering | 12/30/2008 |
| Q: This is one of number column in Access: Some with 4 digits, some with 5 and some with 6. How to put ... A: Bruce You can use a formula like this to add the zeros ... | |
| remove info from excel cell | 12/29/2008 |
| Q: I have a columm with "Indianapolis, IN 46220" and would like to be able to move the "46220" over ... A: BOB Yes there is a simple way to handle it Assuming the data is the same on each row of the column ... | |
| Excel formula use to list data with same info | 12/26/2008 |
| Q: I have two columns with data: Column A Column B name 1 S1 name 2 S2 name 3 ... A: Dennis I think this is what you want From excel help answer Jay Go to the cell right click and ... | |
| Excel formula use to list data with same info | 12/24/2008 |
| Q: I have two columns with data: Column A Column B name 1 S1 name 2 S2 name 3 ... A: Dennis How about using an IFTHEN formula to segregate the names into the two columns, for example ... | |
| Custom Cell format in excel | 12/22/2008 |
| Q: I have two columns and I am trying to merge these columns. First one has just letters (F, H) Second ... A: Behzad If your numbers all have the same number of digits and they all need to be separated at the ... | |
| Time Formula | 12/19/2008 |
| Q: Richard How are you? Below are the details of the formula which I searched on allexperts website ... A: Zafar I can't get your formula to work at all, but perhaps the problem you are experiencing is ... | |
| Countif() | 12/18/2008 |
| Q: Background: I am in the construction industry and do Job Estimating for about 30 different branches. ... A: Tom Since the countif and sumif formulas don't work very well with more than one criteria (I.E. ... | |
| Need help in condtional sum | 12/17/2008 |
| Q: writing 10+20, for example, instead of =10+20 A1, and 40+100 in A2. What formula should we use to ... A: Marzia I believe I am missing something in the question. I don't see the "condition" in the ... | |
| If with time | 12/16/2008 |
| Q: I’m developing a simple stocks worksheet assume the following: Cell A1 is changeable cell ( its read ... A: Faisel You need to write a macro that will run based on what time it is. the following is a website ... | |
| Entering time with ONE key only in one area of the worksheet | 12/14/2008 |
| Q: I'm want to enter the current time in a specific sheet by only pressing the ADD key {107} on the num ... A: ANITA Sorry I am not a VBA expert, It sounds like you are on the right track, but I can't give you ... | |
| Excel paste special quit working | 12/13/2008 |
| Q: For some reason, only on my HP laptops (I have a small business and have HP desktops, Dell desktops ... A: Linda I have experienced the same issue with an underpowered (ram) desktop. I haven't been able to ... | |
| I saved unwanted changes!!! | 12/12/2008 |
| Q: I need to recover a file I saved with unwanted changes...Please help!!! A: LUPE I don't believe there is a way thru excel to recover the pre change file, but I believe that ... | |
| if statement | 12/11/2008 |
| Q: I am fairly new to excel and I have being trying to work on this statement for four hours any I ... A: Joe I am not sure about your quesiton, but it looks like you want to test the 10 cells. I wrote ... | |
| Connecting two option buttons | 12/9/2008 |
| Q: Is it possible to connect an option button on Sheet1 to another on Sheet2? In other words when an ... A: Sean I'm not exactly sure what the question is--- but if you are talking about an option button ... | |
| Excel 2003 | 12/5/2008 |
| Q: Can you help me please. I run a ladies darts league and I would like to show under the position ... A: Jane Send me your e-mail address and I will send yout he Fantasy golf spreadsheet that I created ... | |
| Excel Help | 12/2/2008 |
| Q: "I have a worksheet (Tube Specs) listing various tube sizes that I have in stock, the sheet lists ... A: Steve Unfortunately VLOOKUP is the best function to use to find your client needs. And as you know ... | |
| IF AND VLOOKUP Statement | 12/1/2008 |
| Q: I am trying to create a formula that will pull a value from a list if the primary cell value is ... A: Steven I am not exactly sure of the question, but here is the answer anyway. The formula would ... | |
| Reg Date Minus Time | 11/28/2008 |
| Q: I have a excel sheet and want to deduct date miuns time ex. dated 11.11.2008 minus 56.00 hours .. ... A: Akhil The trick to working with time and dates is to use the same formatting and the same numerical ... | |
| Scoring a network | 11/26/2008 |
| Q: i am trying to figure out if i can create something in excel that scores a network. I will have ... A: Anson If I am reading your question correctly, you should be able to use the countif function to ... | |
| MAX and Conditional | 11/23/2008 |
| Q: I hope you are able to help me with this because I am about at to pull my hair out. I have am using ... A: Tisa I'm not sure I fully understand the question, but---- What I think is the question is ... | |
| Counting records within certain dates | 11/18/2008 |
| Q: I have a list of dates and want to count how many instances occur in each calendar month, e.g., how ... A: Vicky I don't know what is going on with your formula. I copied it from the answer, pasted it to ... | |
| Counting records within certain dates | 11/13/2008 |
| Q: I have a list of dates and want to count how many instances occur in each calendar month, e.g., how ... A: Vicky The date range countif function should work okay with a formula as follows: ... | |
| Preventing cells from changing | 11/10/2008 |
| Q: I have one sheet in a workbook that is linked to another, the first sheet contains raw data and the ... A: Dan If you add a column to all of the sheets at the same time the formula reference will stay the ... | |
| different values | 11/8/2008 |
| Q: i am creating a pricing formula. I want a formula that will know that if i put a number from 1 to 10 ... A: HARRIS Try this out ... | |
| date calc | 11/6/2008 |
| Q: I want to calculate date on excel. Example Box rcvd 5/11/2008 Box open 6/11/2008 System install ... A: parvinder You can subtract one date from from the other and get the difference between the two ... | |
| excel trouble | 11/5/2008 |
| Q: I have a list of names of transactions in column B with the amounts beside it in column D. I want ... A: PAUL I would do it by isolating (with formulas) the cells that meet your criteria and then ... | |
| date format | 11/4/2008 |
| Q: i have fed dates in dd/mm/yyyy format so when i want the dates to appear as 01 Mar 1980 it instead ... A: Vani I can't give you a good answer, but I believe the answer is in the help menu. I can't get my ... | |
| highlight based on condition in range | 11/3/2008 |
| Q: i have some data related to sales, stock and shipments in a range of 52 weeks. i have set a formula ... A: IFTIKHAR I'm not sure what "in the bottom" means, but a formula to show High Stock or Normal stock ... | |
| Excel Question | 11/2/2008 |
| Q: I am looking for a way to have a formula look at a list of numbers, and then return a LIST of ONLY ... A: This is the way I would handle it. First I would use text to columns and separate the alpha and ... | |
| Daily compound interest | 10/31/2008 |
| Q: I am trying to calulate the ammont I will save in an ammount of time by saving x number of dollars ... A: Josh You are correct, the formula is wrong. I did it again and used the FVSCHEDULE()formula. using ... | |
| Daily compound interest | 10/30/2008 |
| Q: I am trying to calulate the ammont I will save in an ammount of time by saving x number of dollars ... A: Josh Try this formula =-FV(0.06/365,52,100,1000,1) The first part of the formula ask for the ... | |
| Macro | 10/29/2008 |
| Q: I have an excel sheet which has different colums, colum "P" is "CNC Code" and colmn "F" is ... A: RAAZ I am not sure about your question specifically "which brings only if---" I'm not sure what ... | |
| Production report | 10/28/2008 |
| Q: I need to create a production report for my team of 12 that has 15 different production metrics ... A: BABAR If you have all of the data needed in an excel sheet, you can do almost anything with the ... | |
| IF Statement | 10/27/2008 |
| Q: I am attempting to create a multiple value If statement as follws. If cell b11 is,>5000, then cell ... A: David I'm not sure if you have written your question correctly, but The first condition is true in ... | |
| Macro | 10/23/2008 |
| Q: I want to set up a macro where I want it to go in the folder of each month to pull out a text file ... A: Truong I am not a macro expert, but I believe if you record the macro and save it in your personal ... | |
| Count with Multple Conditions | 10/22/2008 |
| Q: I have a spread sheet that is based on events that occur over a month's time period. I need to do ... A: Karen What you really need is a countif(and() formul. In my version of excel it isn't ... | |
| Largest value from huge list | 10/21/2008 |
| Q: Roberts I came across this website and I would like your help on finding a macro that would pick up ... A: Giles I would handle your situation with a simple double sort (after copying the data to another ... | |
| multiplying text cells | 10/17/2008 |
| Q: I need to multiply a single text cell to 5 or more cells Please Help! (this needs to be done on a ... A: JEDIDIAH I am not sure if I fully understand the question. If by multiply you mean copy to other ... | |
| xlfn error with =SUMIFS() in Excel 2003 | 10/15/2008 |
| Q: How do I get a work around to view the =SUMIFS() in Excel 2003. I have a 2007 file which has sumifs ... A: vipul The sumif formula was part of 2003, so that should be working--check to see if there isn't ... | |
| excel time range | 10/14/2008 |
| Q: Roberts, I have the following problem: i have a list of times reported in excel: column A ... A: Stephano If I understand your question correctly, I believe you can use a SUMIF() formula to get to ... | |
| Excel summing up cell in different worksheets | 10/13/2008 |
| Q: Hope you can help. I have created a spread sheet with code from my data base and created a invoice ... A: John You should be able to use a SUMIF formula to get what you need, the formula needs to reference ... | |
| Input dollar amount into a cell that updates another cell and more | 10/12/2008 |
| Q: I am racking my brain trying to figure out how to input a dollar figure into a cell (A1)that ... A: Bill I usually do this by using the copy/paste special/values feature, so when you create the new ... | |
| Excel/Access Merge to print | 10/9/2008 |
| Q: My office just switched to 2007 and i need to know how to merge to printer on the new software... i ... A: Mark I'm afraid I am not much help on this question--I have not used the Merge to print feature and ... | |
| How To move to diffrent sheets | 10/8/2008 |
| Q: I have 20 sheets in a workbook. I want to move to sheets one after another and repeat the same work ... A: Prava There are a couple of ways to do what you want. One way that is little known is to make your ... | |
| Table look ups and return values/sum | 10/7/2008 |
| Q: I am trying to achieve something similar but just cannot get it to work. Basically, I want 2 cells ... A: Richard You can use the SUMIF formula to get what you want. An example is as follows: ... | |
| excel | 10/6/2008 |
| Q: ..I'm working with a workbook that contains employee information. I have two sheets, one is ... A: Ironman The following formula counts the number of employees between two dates. Assuming each row ... | |
| RE: Cleaning Case of Text | 10/4/2008 |
| Q: I am trying to change a column of text that is in Caps to the Proper(A) Text case. I understand ... A: CHERYL The formula is =PROPER(A1) Where A1 is the cell with the upper case in it. If you want to ... | |
| Excel Date | 10/3/2008 |
| Q: I have a column which has a Date of Admission. I need to be able to count the total number of ... A: Ophelia You can use a couple of COUNTIF formulas to get your answers. You might use a formula like ... | |
| Multiple Condition Sumif | 10/1/2008 |
| Q: I need a formula to calculate the value of F1:F158 only if E1:158 is equal to 1, D1:D158 is equal to ... A: Stuart I can't seem to get the single formula to work, so try this Use this formula on any part of ... | |
| More than 7 conditions - range | 9/30/2008 |
| Q: I'm trying to create a formula which will look up a cell with a quantity (A9) and put price in B9. ... A: Aggie If you write the formula like this it should work for you. ... | |
| Conditional limit check | 9/28/2008 |
| Q: I have a spreadsheet that is calculating a mortgage paydown by month. It has the principal balance, ... A: You can use the conditional formatting feature. it will not give you the conditional format before ... | |
| copy/paste 'til end of sheet | 9/27/2008 |
| Q: I have a set of data 21 rows long & 5 columns wide. I would like to have this set of data to be ... A: Tina Don't know if you want to fill all of the rows inbetween row 21 and the last 21 rows in the ... | |
| question on sorting table | 9/26/2008 |
| Q: My name is Kevin and I have a problem on writing a VB code in sorting table. Here is my question. I ... A: Kevin The easiest way to "write the code" is to use the toolbar/tools/macro/record a new macro ... | |
| complex excel data entry | 9/23/2008 |
| Q: i am working on a data entry project where i am finding e-mail addresses from an online database ... A: lISA Short of downloading the online data base (which is probably to large) and then using a ... | |
| Mass Find and Replace by Formula | 9/20/2008 |
| Q: I have some data in cell a1. Old words those are supposed to be appear in a1 are there in column ... A: Parantap I am not following exactly where we want the words to end up, but here is a suggestion ... | |
| Formatting a Cell dependant upon date | 9/19/2008 |
| Q: I'm creating a staff details spreadsheet that contains dates of when their licences are due to be ... A: Sarah I think the simplest way to do your conditional formatting would be to calculate the ... | |
| Excel - Add then delete prior row data | 9/18/2008 |
| Q: I utilize large spread sheets which have the same product number but different quantities purchased. ... A: DALE The really good macro guys can write a macro that will take care of this I however am not a ... | |
| Excel Help | 9/17/2008 |
| Q: I am currently working on a consulting timesheet which basically gets created from our billing ... A: ALLYA You have a lot of issues within your question. The main question is how to set up the sheets ... | |
| Freezing a range on a tab & Automatic printing | 9/16/2008 |
| Q: I have two EXCEL questions in which I need assistance. I have an EXCEL spreadsheet with many tabs. ... A: Matthew The answer is much easier if your print range remains the same on each tab each time you ... | |
| linking a picture to a cell | 9/15/2008 |
| Q: Could you please help me link a picture to a cell.is it possible to type the item code in one cell ... A: Sam You can insert a picture in excel by using the simple copy and paste technique. Find the ... | |
| autopopulate | 9/12/2008 |
| Q: I want to create number formula for estimate. In a row of cells(example 10 cells)i will put a ... A: You can do this with the conditional formatting feature and using the "formula is" option. ... | |
| link to single column | 9/10/2008 |
| Q: I have original data in an excel sheet datewise Ex: Date 1 2 3 4 5 ..... 31 Data ... A: Avaneesh I am struggling with understanding the question, but it sounds as though you need to use a ... | |
| MATCH COLUMNS | 9/9/2008 |
| Q: Sir, I have two sheets in a workbook and would like to Match the first four columns of the ... A: Abdul There are a couple of ways to do this but there are some things that aren't clear in your ... | |
| Excel automatically converting invoice number to date | 9/8/2008 |
| Q: When I copy and paste from our accounting system to Excel, Excel assumes this to be a date and adds ... A: Erica I can think of a couple of things that might work. first How is the column your are pasting ... | |
| EXCEL shared workbook views | 9/5/2008 |
| Q: I create a workbook that contain several worksheets. I would like to hide certain columns and rows ... A: vivian I don't know whats going on with your workbook, I haven't seen the problem before. Perhaps ... | |
| using IF to determine which list to use | 9/4/2008 |
| Q: I have a drop down list that I have created in one cell (B7) using the DATA - VALIDATION - ... A: Simon I apologize for being late in answering---I didn't see your question in my e-mail-- I don't ... | |
| How to Create a Firm Fixed Price Forecast | 9/2/2008 |
| Q: Good evening! I will appreciate so much your help. There is a formula that I need to create. I ... A: Yolanda I am not sure exactly what you need, but some suggestions. Create formulas based on the ... | |
| =SUM(OffSET... | 8/19/2008 |
| Q: I am using the following formula to capture the sum of the last 10 values of column "A" which is a ... A: ve Sorry to be slow in answering--I just noticed I had a question I usually handle the problem ... | |
| Omit cells containing text from forumla | 8/17/2008 |
| Q: I have tried several times but to no avail to try and sum or average four cells (thanks the easy ... A: Simon I can think of a couple of ways-- 1 The formula +sum(A1:A5) should yield a sum even if the ... | |
| links between excel files | 8/7/2008 |
| Q: I have a task to create several files after one file that I receive monthly. The several files have ... A: Ana I believe an IFTHEN formula may work for you. Such as In the worksheet for China the ... | |
| Invoice question | 8/6/2008 |
| Q: I am a small business owner and I currently use Excel for my invoices. I use column D for initials ... A: Carrie You can use a sumif formula that might look something like this ... | |
| SumIf/Colorfunction Problem | 8/5/2008 |
| Q: Richard, I am currently working on a spreadsheet that tracks our company's financials (by month, by ... A: Don I am sorry, but I am in the middle of a major project and can't give your question the time ... | |
| comparing 2 columns | 8/2/2008 |
| Q: i am vicky. My question is I have 3000 rows in A column 3000 rows in B column I want to ... A: VICKY You can use the conditional formatting feature. Go to toolbar/formatting/conditional ... | |
| CAGR | 8/1/2008 |
| Q: given the following rent growth % year 1 = 3.2%, year 2 = 2.9%, yr3 = 3.8% how'd you find the ... A: Miles Use the XIRR function to do the calc. Create on the spreadsheet a table of dates and ... | |
| Excel Problem | 7/31/2008 |
| Q: I have 3 excel sheets from various sources. 2 of the sheets need to be compared with 2 pieces of ... A: ANDY You need an IF formula to resolve your #N/A problem such as this ... | |
| how to copy all the numbers to a perticular place from excell to word? | 7/30/2008 |
| Q: I have a format in Microsoft word as you see in a calling card which has a calling code in the ... A: Vasim I may not be understanding the question, but-- You can copy all of the numbers in excel at ... | |
| finding equals amount in a column in excell | 7/28/2008 |
| Q: I do have a set of data in a spreadsheet, contening: first column=date.Second column=Description. ... A: Andy Couple of ways to do the reconciliation-- One would be to sort the data then manually compare ... | |
| ms works spreadsheet | 7/26/2008 |
| Q: it was excellent. =B4+TIME(8,0,0) worked perfectly. I was wondering is there a better formula for ... A: Caz Sorry I didn't see your question-- You can use an if then formula to calc the time for you ... | |
| ms works spreadsheet | 7/25/2008 |
| Q: im trying to make some kind of formula in ms works speadsheet regarding time. for example i have ... A: Caz The formula you need in C4 is =B4+TIME(8,0,0) The formula says take the time in cell B4 and ... | |
| Excel Help Please! | 7/22/2008 |
| Q: My boss and I are trying to figure out if there is an equation to take out the gst(13%). We write ... A: ALYSSA I'm not sure exactly what the GST is. I am from USA, Florida, so it is not a familiar term ... | |
| Microsoft Excel | 7/19/2008 |
| Q: How to insert a row above the header. A: Al If you are inserting a "header" by going to toolbar/view/headers and footers, etc, I don't know ... | |
| Date sorting on excel | 7/18/2008 |
| Q: i am trying to sort date to weekdays and am really stuck please help.i.e the dates are in column A1 ... A: Irene First you can apply the formula =WEEKDAY(A1,1) to all the cells with dates in them. The ... | |
| vlookup to retrieve multiple data | 7/16/2008 |
| Q: Appreciated if you can suggest any formula for my question. I am working in a Car Rental Company we ... A: Abdul A couple of ways might be 1. Use the filter function Toolbar/data/filter/autofilter ... | |
| Problem with drop-down filtering | 7/15/2008 |
| Q: We use a shared spreadsheet at work where we filter our rows using a drop down menus in the first ... A: Isaac I believe your list is being filtered using advanced filtering. You should be able to change ... | |
| compare and count | 7/14/2008 |
| Q: I have an excel calendar on a worksheet called A&P's and on worksheet called DAYs the #'s 1 thru 31 ... A: Leon I have a feeling that there may be more to the question, but I have tried to answer ... | |
| Excel Formula | 7/12/2008 |
| Q: I need a formula to calculate a 16% yield on a balloon. Term is 118 payments, yield 16%, ... A: Allen Assuming the 118 payments is actually 118 compounding periods with 1 payment due at the end, ... | |
| Invoice Auto Populate cell based on dropdown item | 7/10/2008 |
| Q: I am working on a service invoice and am stuck on how to auto populate a Rate cell based on the ... A: Brian Yes you can use the VLOOKUP function to autopopulate. I can't write the exact formula for ... | |
| Formulated Frustration | 7/8/2008 |
| Q: Let me first start by saying, "ARGGGH!". Please help! I'm creating a spreadsheet and I'm really ... A: Keri If I understand what you want the formula results to be then an If formula should work for ... | |
| Locking cells automatically | 7/7/2008 |
| Q: I have prepared a time sheet in excel and put in share folder. I have instructed my colleague to ... A: kirupairajah I am not sure if you want the cells to also be locked from your input colleague, but ... | |
| excel formulae | 7/6/2008 |
| Q: i cant get a formulae to work, basically i need it to work tax out for example B2 is incoming C2 + ... A: Scott You can make your formula dependent on whether or not anything is entered in B2 for example ... | |
| List of numbers that add up to a certain amount | 7/3/2008 |
| Q: I was hoping you could help. I am an accountant and have been given the task of reconciling a ... A: Brian I just recently had the same question, which is a bit strange since I haven't had the ... | |
| File is very heavy. | 6/28/2008 |
| Q: My excell file is 10.0 MB and my work is without formulas but when i add 1 blank sheet in same file ... A: Babar Sorry I don't know what would make the file increase so much unless of course your data is ... | |
| word into excel | 6/26/2008 |
| Q: I need to make an excel spreadsheet from a word document but I need to also change the format. The ... A: Alice There may be an easier way, but this is the way I would handle it. First copy and paste all ... | |
| this file is locked. try the command again later | 6/24/2008 |
| Q: i have a shared an excel file which cannot be access anymore. the message box appear the file is ... A: Patrick I don't have an easy answer for you, but it appears that someone has protected the workbook ... | |
| Quick formula | 6/23/2008 |
| Q: How can I pick cells from a range of data at a set interval and retrieve the data from that range? ... A: Matt I would isolate every tenth row as follows. First number every row used, by putting a one in ... | |
| sending data from excel to text docs.. | 6/21/2008 |
| Q: .. i am a regular reader of ur site since few weeks though :) i am a engineer vry comfiortable in ... A: MALIKA You can use the sort function Paint the data ayou want to sort, then go to ... | |
| relative reference | 6/16/2008 |
| Q: I am looking for the relative reference button. Can you help? ANSWER: Derek Is this what you are ... A: Derek Try this website http://office.microsoft.com/en-us/marketplace/EM102785921033.aspx Only ... | |
| relative reference | 6/14/2008 |
| Q: I am looking for the relative reference button. Can you help? A: Derek Is this what you are refering to From Excel help Switch between relative, absolute, and ... | |
| Excel formula | 6/13/2008 |
| Q: I will state this with an example: suppose i assign values to alphabets Eg: A=2, B=3, c=4, D=2...., ... A: There may be other ways to do this but one way might be to use the text columns feature and separate ... | |
| formula | 6/12/2008 |
| Q: Good evening, I have been trying to set up a spread sheet for my ebay sales. I am looking for a ... A: Blake Usually it is difficult for me to know exactly waht a questioner is wanting or needing to do, ... | |
| Need a formula | 6/10/2008 |
| Q: I want to know what formula should I use to make a discount to an amount. Example. I want to ... A: Marie To calculate what the 2% of 21000 is the formula would be =.02*21000 If you want the ... | |
| If then | 6/4/2008 |
| Q: I am looking for a way to have one cell be blank if another cell = 0, otherwise it allows input ... A: JASON The formula would look like this. =IF(A1=0,"","????") The ???? part of the formula is ... | |
| Formulas | 6/3/2008 |
| Q: Can you please give me the list of all Ms-excell formulas. A: Anita I do not have a list of excel formulas or functions. The list would be very long, there are ... | |
| Keyboard Shortcut for | 6/1/2008 |
| Q: I frequently need to insert a blank line in a table of data. When I select a line of data and try to ... A: Roger If you select the entire row (where you would like to insert a new row) by clicking on the ... | |
| Keyboard Shortcut for "Insert" | 5/31/2008 |
| Q: I frequently need to insert a blank line in a table of data. When I select a line of data and try to ... A: Roger If you make the row selection where you want to insert a new row and you use Alt+I on the ... | |
| excel - update column automatically | 5/29/2008 |
| Q: Help with this will be very appreciated. As it will save lot of my time as compared to doing it ... A: SAM I may be misunderstanding the question, but it sounds like you need a total of all of the ... | |
| excel question | 5/28/2008 |
| Q: I have a spreadsheet that contains 2 lists of employee names. I am trying to reconsile the 2 lists ... A: Tim Here is how I would handle it. First I would combine the first and last names into one unique ... | |
| Excel Macro | 5/27/2008 |
| Q: I am trying to compare 2 columns, one has strike through data and would like to know how can I write ... A: Kiran Sorry I don't know of a way to test for the font (strikethrough) in a function or a macro. I ... | |
| To keep iteration always on | 5/26/2008 |
| Q: Actually I want to display the static time and date in excel sheet through the following formula.. ... A: champak I am not sure if you mean iteration or calculation The calculation will remain on if the ... | |
| Daily data to weekly and then monthly | 5/24/2008 |
| Q: I have an excell sheet that calculates Average of how many faxes and letter mail we get. How can I ... A: Babar I don't know how your data is set up but the WEEKNUM() function should help you. You can use ... | |
| Help and support | 5/22/2008 |
| Q: I have posted my posts so many sites but could not find any specific result. My friends told me ... A: HARDEEP First --I do not know what you mean by "zone Wise" so my answer may not be appropriate. I ... | |
| excel - open office | 5/20/2008 |
| Q: I Want to give border to excel sheet, which will also appear on screen . (i can see Border on Print ... A: Yogesh Did you get the error to go away? If you are talking about borders as the term is used in ... | |
| excel | 5/19/2008 |
| Q: i have two columns containing numbers.i want to multiply those numbers. i.e. A1*B1 But 1)i need a ... A: Yogesh I suggest you go to the excel help and search for errors and go to the Correcting #NAME? ... | |
| excel | 5/18/2008 |
| Q: i have two columns containing numbers.i want to multiply those numbers. i.e. A1*B1 But 1)i need a ... A: Yogesh Copy and paste my formula directly from the answer to the excel spreadsheet. To make sure ... | |
| excel | 5/17/2008 |
| Q: i have two columns containing numbers.i want to multiply those numbers. i.e. A1*B1 But 1)i need a ... A: Yogesh I am not sure if I understand what the result you want is but--- Obviously you want a ... | |
| labels | 5/15/2008 |
| Q: I work as a shipper and from time to time we have to make box labels. The label consists of a ... A: Andrew I don't do much with multiple labels, so my answer may not be as good as you can get from ... | |
| How to set a Checkbox value or copy one's value from page to page | 5/13/2008 |
| Q: I have a workbook with multiple sheets, all related to collecting / calculating / displaying ... A: MARK I do very little with checkboxes and thus the answer is not one that I know off the top of my ... | |
| Formula to populate dates | 5/12/2008 |
| Q: Rich, I'm trying set up a forecasting template in excel. Based on a reference cell (mm/dd/yy), is ... A: CHRISTINA I am not sure exactly what you are looking for, but you can populate dates by increasing ... | |
| copying formula | 5/8/2008 |
| Q: Why when I copy (add-sum) formula it brings over the sum of the cell I copy from, but corrects when ... A: Eli Check your calcualtion option. I believe you may have the manual calc option turned on. To ... | |
| Creating expanding ranges for a summary sheet | 5/7/2008 |
| Q: Hope you can help. I am busy compiling reports run from a database, with the different sheets ... A: John I usually handle these types of database situations simply, so here is the simple way to do ... | |
| IF function in accounting worksheet | 5/6/2008 |
| Q: I'm hoping you can help me. I am creating a 10-column accounting worksheet for financial statements. ... A: Crystal Here are the formulas that I use to put the debit and credit balances in the proper ... | |
| Using Excel as Database | 5/5/2008 |
| Q: , I have try the Formula in the attached sheet and its not working correct Let me Explain this ... A: Osama The following is an article from the microsoft website--I think it will help you. Richard ... | |
| excel formula | 5/2/2008 |
| Q: cuold you please tell me how to add or multiply a number to an existing cell and then have the ... A: Raj You cannot make a reference, in a formula, to the same cell that you are putting the formula ... | |
| Excel dates??? | 5/1/2008 |
| Q: Do you know of a way in excel for a cell to automatically return the end of the month date when ... A: MICHAEL The formula =EOMONTH(A1,0) will convert the date in cell A1 to the end of the month date. ... | |
| Excel | 4/30/2008 |
| Q: I am trying to create a table that allows my produts to appear as drop down boxes and I can search ... A: Jennifer You should b able to do what you want with a list of products and their related prices and ... | |
| Excel Newbee - simple accounting function | 4/28/2008 |
| Q: I am very new to Excel. i need to figure out the rate at which a customer will be current based on ... A: Nikki So if I am understanding you correctly you just need to divide the total due by amount of ... | |
| Excel | 4/25/2008 |
| Q: I am new to excel, i am designing an excel report where i will input the date into excel sheet ... A: Karthik I don't have enough detail to give you a specific answer, but here are some suggestions' ... | |
| inserting a pdf file in a excel spreadsheet | 4/24/2008 |
| Q: I want to insert a pdf file in a excel spreadsheet and then sent the sheet as a body in MS Outlook. ... A: Chi Sorry, its not something I have ever done, and I am not expert in outlook or manipulation of ... | |
| Excel Project | 4/19/2008 |
| Q: 1. We are working on a new Hewlett Packard xw4400 Workstation with 4 Gigs of RAM, 300 Gigs of hard ... A: Jack The size of the data should not be a problem, I have worked with much larger spreadsheets ... | |
| Pasteing numbers into excel | 4/18/2008 |
| Q: How can I copy a balance sheet from a website into excel and use functions with the numbers. Excel ... A: Darrell You might try this Put the number 1 in a cell. Then do a copy paste special multiply by ... | |
| Cumulative Calc | 4/5/2008 |
| Q: Excel Function to calculate cumulative balance of monthly investment of 149.05 at 4% per annum ... A: Willee I would do yur cal like this +D24+149.05+(D24*0.04/12) Where D24 is your first payment ... | |
| Fetch data | 3/29/2008 |
| Q: I'm having an xcel workbook, where I have made some calculations & set some formulas. When I paste ... A: AVINASH ther eare tow ways I can think of that might work for you. One is to create a simple link ... | |
| automating increasing numbers in excel | 3/28/2008 |
| Q: I have the formula =$E$256+1*$F$256, under this I have =$E$256+2*$F$256. I would like to drag the ... A: Martin Here is one solution. I am assuming you want the +1 part of the formula to increase each ... | |
| Excel linking individual sheets | 3/27/2008 |
| Q: how do I get the data I enter on the first sheet to automatically enter itself on the appropriate ... A: Karen This is what the formula looks like =+Sheet1!A1 This will bring the value in sheet 1, cell ... | |
| Links | 3/26/2008 |
| Q: I have a peculiar scenario here. Lets say I am using 4 workbooks which are linked to each other ... A: Sajeendran Try using the formula view option in the tools-- Go to toolbar/tools/options/view ... | |
| Links | 3/25/2008 |
| Q: I have a peculiar scenario here. Lets say I am using 4 workbooks which are linked to each other ... A: Sajeendran One thing that might work for you is to use the calculation option that lets you ... | |
| excel macro for copy paste from one sheet to another | 3/24/2008 |
| Q: on sheet 1 i have column of numbers in column A going from 1 to 100, in column B i have letters A to ... A: Rick Since you only have a hundred, I suggest you don't bother with a macro, just create the list ... | |
| Look up and post information matching 3 critiera | 3/20/2008 |
| Q: I have a spreadsheet that lists out parts, the plant that those parts get shipped to and two weeks ... A: Dawn I can't really tell from what information I have how to solve what you need. I will make a ... | |
| About freeze and scrolling | 3/19/2008 |
| Q: I have a question about how can we make a column to scroll vertically either up or down - i need to ... A: DURAI I am not totally sure that I am understanding your question correctly, but---- You can ... | |
| Display caption of checkbox in excel | 3/18/2008 |
| Q: I have two check boxes in grid view in my asp.net application. The text associated with first check ... A: Madhavi Sorry, I do very little with Import work, Asp.net and check boxes so I am not a very good ... | |
| vlookup | 3/17/2008 |
| Q: I have been using the VLOOKUP function to search a table of data for a specific value in order to ... A: J You did a very good job of explaining the problem (or perhaps its because I am familiar with it ... | |
| Eliminating #N/A from Index/Match | 3/13/2008 |
| Q: I have the following formula: =IF(INDEX('Actual 2008'!$E$1:$P$75,MATCH('Act vs Plan By ... A: Regina You need to use the ISERROR function as part of the formula, which tells excel --if the ... | |
| Excel Function | 3/11/2008 |
| Q: Hey, I was wondering how to use the sum function so that I could do the following. I have a lot of ... A: Dan Its pretty difficult to do what you want and have it appear in the same cells. My solution ... | |
| Copy cells to another worksheet | 3/9/2008 |
| Q: I am a beginner in excel and am trying to automate a tedious everyday task in my work duties. I have ... A: Sherrie I see a couple of ways to do what you want. One would be to copy the entire worksheet from ... | |
| Check Boxes | 3/8/2008 |
| Q: I'm part of a group of people who play a game online together. Basically I'm creating a excel ... A: Lisa If I understand correctly, you want to be able to put the cursor on a cell and clic it and ... | |
| formula | 3/6/2008 |
| Q: I have 31 sheets; sheet1, sheet2, sheet3 etc..... i'd like to add all worksheet in cell U15. what ... A: Ekekela Your formula should look like this-- =SUM(Sheet2:Sheet31!U15) The following is from the ... | |
| Deriving 'hidden' coordinates from xy scatter plots | 3/5/2008 |
| Q: Can you tell me whether Excel can calculate the xy coordinates of the point at which two lines ... A: Dominic I am definately not a chart expert, so I won't be good at answering your question. However ... | |
| COUNTIF (or COUNTIFS)?? in Excel 2007 | 3/2/2008 |
| Q: I am trying to count values against criteria in three ranges of non-contiguous cells. As you will ... A: David I didn't work out a formula, but usually what I do in cases like this is use the countif ... | |
| Selecting cells in Excel! | 2/29/2008 |
| Q: I have to draw a graph curve using values obtained from a test equipment. There are tens of ... A: Mehrdad How about this as a solution-- Use the randbetween() function to generate a random number ... | |
| absolute addresses and macros | 2/26/2008 |
| Q: I have a macro in an spreadsheet to save order details once entered to another sheet - giving a list ... A: Susan I believe, if you want to count the total number of orders, you can use a range in your ... | |
| query "yes" in subsheets | 2/22/2008 |
| Q: I am working on a sales project where we are calling on customers and gathering information. Each ... A: Dan I'm not exactly sure what is gong on with your worksheets--is the autfill data going only on ... | |
| Move Data w/o changing code. | 2/21/2008 |
| Q: I don’t know if it is possible to do this or not but if so do you have any ideas? This is a little ... A: Chris This may be to simple, but how about this--- Create a column which would sum or concantenate ... | |
| linking in excel | 2/19/2008 |
| Q: I've recently learned how to link from one worksheet to another in the same document, however, what ... A: Angela You can't link the same cells back and forth on two different worksheets. It sounds to me ... | |
| Comparing dates in Excel VB | 2/18/2008 |
| Q: I have 2 cells of which one contains a start date and the other an end date. I want to compare the ... A: Mark I'm not sure how to do what you want with VB code, but a simple formula will do it-- If cell ... | |
| Averages! | 2/13/2008 |
| Q: I have 2 questions... Q1 I am trying to work out and average score in a line of 5 cells and want to ... A: Jan Q1 Try this formula =SUM(A1:A5)/+COUNTIF(A1:A5,">0") This adds the array and then divides the ... | |
| VLOOKUP | 2/12/2008 |
| Q: How do I get a blank to show up when the answer is '0' (zero) in my VLOOKUP to another sheet? Here ... A: TAM You can use this formula =IF(VLOOKUP($B7,MISC,11,FALSE)=0,"",VLOOKUP($B7,MISC,11,FALSE)) This ... | |
| V-Lookup | 2/11/2008 |
| Q: I have an issue with v-lookup. On spreadsheet A, I have multiple delivery numbers. On spreadsheet ... A: Tanaz The simplest way to handle this is to create a "unique" number out of the delivery number. ... | |
| automatic "invoice" numbers for excel | 2/8/2008 |
| Q: I have created an invoice for a business and really need an automatic invoice numbering system for ... A: freefall Automtic numbering of invoices is a bit difficult because as far as I know it requires a ... | |
| copying dates across a row | 2/4/2008 |
| Q: I am trying to get the month of january across a row, it seems as if there is a better way of ... A: Gabriel You are in luck--It seems the excel gurus have given us a way to fill a series. Here is how ... | |
| Compare Data | 2/2/2008 |
| Q: I hope you can help me. How can I simply compare figures from 2 identically laid out tables which ... A: Vicky How about this--- First create a column next to the column of new data, then create a formula ... | |
| Identifying particular month in a date | 1/31/2008 |
| Q: Using Excel 2003, I'm trying to count the number of new joins in the organization in a particular ... A: prad I had a feeling that your question was to count all of the people who met BOTH criteria, not ... | |
| DSUM Problem in Excel 2007 | 1/29/2008 |
| Q: I have a DSUM formula =DSUM(FCDATA,WS!$F$10,A92:A93)in excel 2003 workbook.But when if open the ... A: Cynthia I don't know of any reason that the formula would not work in 2007 version, it should. ... | |
| formela | 1/28/2008 |
| Q: i need formula to change part no format from 11638 to 00000011638 A: Wael The formula is +A1&B1 Where A1 contains the zeros as follows '000000 and B1 contains your ... | |
| Paste to filtered column | 1/23/2008 |
| Q: I have two columns with many rows in sheet1. The header for column A is group and column B is name. ... A: Le The filter does not show the rows that don't contain what you have filtered for, but they are ... | |
| Exclude cells from a range | 1/22/2008 |
| Q: How do I exclude specific cells from a range? For instance my range can be A1:A10, but I don't want ... A: Sandra I'm not exactly sure what you are trying to do with your formula, but You could use a minus ... | |
| linking certain words to a certain value in another cell. | 1/20/2008 |
| Q: I'm really struggeling with a part of excel i think should be straight forward. I am trying to link ... A: Sarah Its not to difficult, but--- You can do it a couple of ways-- With an IFTHEN formula such ... | |
| Formula | 1/19/2008 |
| Q: Here is what I'm trying to accomplish. In a single cell I have numbers increasing from 0-250,000+. ... A: Shea Try this ... | |
| date approaching / date in the past functions | 1/17/2008 |
| Q: I would like a two simple functions to change the formatting of a date cell for 1. when the date ... A: Volatile Yes you can using conditional formatting with two formats and using the formula selection. ... | |
| Tab Key | 1/16/2008 |
| Q: I have a spreadsheet made with Excel that has 6 columns. After I finish entering data for each row, ... A: Roger The standard movement of the cursor to a new active cell is right,left,up,down, and that ... | |
| Query on Excel Functions | 1/14/2008 |
| Q: I need a help on the below Example A person works on different projects and his productivity is ... A: Kamal Asssuming that you have calculated the per project productivity per day, what you need is a ... | |
| Rolling calender in Excel | 1/12/2008 |
| Q: I just Googled rolling calendar in Excel and was brought to a page you posted in 04 to somebody that ... A: Patrick I remember the question, but I haven't had occasion to do it since, and I don't remember ... | |
| Project Request | 1/11/2008 |
| Q: Do you think you could create something like this? Attention development team: I am looking to ... A: MARK Yes an excel form can be created to do the calculations that are described in your question. ... | |
| Conditional formatting | 1/9/2008 |
| Q: I have a long table and for neatness want borders to print across the bottom of each page. Is there ... A: Rae As I understand it you want to add a border to the bottom of each printed page, So you might ... | |
| Sorting Data according to the 2nd word in a cell | 1/8/2008 |
| Q: Thanx for your previous replies. As expected, I have another task for you. Hope that you know the ... A: Azeem Believe the simplest approach would be to separate text from 342 red pencils 100 all in the ... | |
| excel | 1/7/2008 |
| Q: i want to sort a specific name next to the amount column and select that numbers all in one to see ... A: Shalom I am not totally sure of your question, but let me make suggestions. If you need to total a ... | |
| saudi stock market | 1/3/2008 |
| Q: Good day, I want to make excel update Saudi stock like what happen to US stock (like STC, FDC). Is ... A: Abdullah I seldom use smart tags in my programs, but most tags that are used are created by others ... | |
| autofill hyperlinks | 12/31/2007 |
| Q: I have a column of incremented text with numbers (e.g. uss301, uss302 etc) i would like to ... A: Greg I do not know of a way to incrementally change the hyperlinks, either by formula in excel or ... | |
| MERGING CELLS AND FORMATTING IMPORTED DATA | 12/29/2007 |
| Q: I'm a CPA also, Cut Paste and Attach....LOL I want to import a list of new DBA's registered in ... A: Kathleen I am still having problems accessing the website, so hopefully you will be able to use my ... | |
| EXCEL MACRO | 12/28/2007 |
| Q: I am working on excel where there is Collum for Amout receivables for which i am following up with ... A: You can set up a reminder as to course of action, but I can't give you much help since I don't know ... | |
| Linking Worksheets | 12/27/2007 |
| Q: Is there a way to link a column from one worksheet to a column in a next so that if data is changed ... A: keonne Yes you can link the worksheets or cells in a worksheet by using a formula such as this: ... | |
| excel | 12/26/2007 |
| Q: I was wondering if you have a formula on excel for me. I need to figure out compound interest with a ... A: Sandy Yes there are formulas in excel that will calculate your loan payments, etc. Go to this ... | |
| Excel 97 | 12/25/2007 |
| Q: I have a worksheet written in excel 93 copy it to my new computer that has 97. It worked fine for ... A: Joe Iam afraid I don't have a good answer for you. I have not had that happen and don't know what ... | |
| Invoicing Question | 12/24/2007 |
| Q: I am new to macro but have been attempting to create a few macros. I am using a worksheet to create ... A: Mike I am not sure of your knowledge of excel macros, but assuming that you can do all of the above ... | |
| question | 12/23/2007 |
| Q: This is my e-mail address davandeh_ms@yahoo.com 1- I have a question about vlookup. I read ... A: The vlookup formula isn't an array formula but what you may have read is that you can lookup a value ... | |
| Calculating hours worked with lunch time if appropriate | 12/22/2007 |
| Q: My question is seemingly simple. I am fairly skilled at excel but am having difficulty with this ... A: Nita There is nothing wrong with your formula as typed in your question. I copied it directly to ... | |
| separating first name and surname according to capital letter | 12/20/2007 |
| Q: I was wondering if there's built-in function or macro in Excel that allows me to separate a full ... A: Amril I just noticed that your question is pending--sorry I answered it yesterday, but I was having ... | |
| Data Validation | 12/19/2007 |
| Q: I have a worksheet with many columns/cells that I've set up with data validation/drop down lists. ... A: Gary I don't have another answer as to why it is not appearing, but a solution may be to copy the ... | |
| Data Validation | 12/18/2007 |
| Q: I have a worksheet with many columns/cells that I've set up with data validation/drop down lists. ... A: Gary It sounds like in the validation settings the in cell drop down box got unchecked. If it is ... | |
| Dropdown Event in Excel | 12/17/2007 |
| Q: This is my question I have two cells in my sheet, consecutively viz., E6,F6 In the first cell ... A: Vikram First--create your drop doen list by inputting the dates in date format not typing in the ... | |
| Adding question | 12/13/2007 |
| Q: For instance I want to know our goal for sales in a month and as a day passes I want to eliminate ... A: Tony First I would use a formula in each column, on the same row going across, that if the date of ... | |
| Using the Upper function | 12/9/2007 |
| Q: I've been trying to use the UPPER function on a spreadsheet I've created. I know I have to enter ... A: Linda That is the way the upper function works it transfers the data form one cell to another and ... | |
| Converting figures to words in excel:- | 12/8/2007 |
| Q: I have been trying to find out how to convert numeric figures into words in excel. Please help A: Mohamed Below is an article on converting numbers to text. If you are wanting to convert the ... | |
| Extracting data from a master worksheet to various work sheets | 12/3/2007 |
| Q: I am working on an excel worksheet that has around 40 columns. The rows contain data for different ... A: sheeba Here is a way to handle what you want. In each of the worksheets write a formula that will ... | |
| Cell protection in excel | 11/29/2007 |
| Q: I have a number of large spreadsheets with cell protection set in various places. I would like to be ... A: Bob I can't find a way to simply solve your problem. I am sure that it can be solved with a ... | |
| changing the value of my input cell upon changing another cell | 11/28/2007 |
| Q: So my set up is: A B C 23 15 2 What I need is to be able to manually enter in any numbers ... A: Andy I don't know of a way to make the cell both dependent and independent of another cell value. ... | |
| Sheets Tabs | 11/22/2007 |
| Q: Richard, how would I go about sorting the "sheet tabs" according to date? All tabs are given a date ... A: Keith I do not know of a way to sort the sheet tabs automatically. You can move them manually and ... | |
| Excel Time Calculation | 11/21/2007 |
| Q: I need to calculate the time (hh:mm) betweeen two dates with the following conditions in place: - ... A: Laeeq Excel has a built in function, NETWORKDAYS, that calculates workdays. You can use that ... | |
| excel | 11/19/2007 |
| Q: I was wondering if there is a way to make a pull down menu, which can be allow to pastes information ... A: Cari I do not know of a way to create the pull down menu that you can write in. It may be ... | |
| PLEASE PLEASE HELP !!! | 11/18/2007 |
| Q: I hope you can help me before monday. I need to open an excel spreadsheet from windows explorer but ... A: Brian In the interest of time I am gonna suggest that you reask the question of another allexperts ... | |
| Excel | 11/17/2007 |
| Q: I have to do a report on the average repair thime on the Windows and Sun server I use the letter w ... A: Leo You can use the SUMIF and COUNTIF formulas to get you averages as follows. assuming the data ... | |
| word to excel via vba | 11/15/2007 |
| Q: i have a simple word text document. i want to put 10 words in the document onto 10 columns in the ... A: KAVITA you can copy and paste the word document to the excel spreadsheet. It will not copy to 10 ... | |
| to check if the formula is same or not | 11/14/2007 |
| Q: How can I check the formula entered in a particular column but in the different rows are same or not A: Kiran I am not sure exactly what you are trying to get at, but--if the formula is the same the ... | |
| formula for counting numbers repeated in a range of cells | 11/13/2007 |
| Q: I have random numbers in a column A, I HAVE selected cells A1 TO A16 and now i want to display the ... A: Sahil I believe what you need is the COUNTIF function, with aformula such as ... | |
| Excel percentage | 11/12/2007 |
| Q: I'm wanting to add a percentage to a column of numbers and display the result in the adjoining ... A: Oliver The type of formula you need will be as folows: Assume column A is the cost column and ... | |
| Running Macro upon cell change and running macro for different rows? | 11/11/2007 |
| Q: Hope you had a great day! I'm facing some trouble with excel and it'd be great if you could take ... A: Sabrina I'm not gonna give you the answer you want, but some hope. I am not a macro expert so I ... | |
| Number to count | 11/8/2007 |
| Q: I need help, I create fill form in excel 2003, how I can write formula to count each time I open a ... A: Dan Check the templates that are available in excel some of them have the counting/renumbering ... | |
| Opening excel files | 11/7/2007 |
| Q: When I attempt to open an excel file excel does come up but at the stage before the file is usually ... A: Dennis I haven't run into this problem before, so I can't give you any specific help. I checked ... | |
| Ecel | 11/6/2007 |
| Q: I have created an Quote Template in excel and each invoice has a unique number. I would like to be ... A: Tania You can do exactly what you want with a macro that will both sequentially number the quotes ... | |
| Excel - Cell formatting not working for one tab of a excel file | 11/1/2007 |
| Q: I have prepared a Excel file which has 4-5 tabs.. now I have set one tabs reference to another tab ... A: SACHIN Sachin Apparently your cells are formatted as left indent. To change this paint the cells ... | |
| VLOOKUP | 10/31/2007 |
| Q: I am currently reformatting a spreadsheet with all our information regarding product on it. I am ... A: Oliver The VLOOKUP function should do the job for you. It should be set up as follows. You will ... | |
| how to do audit check. | 10/30/2007 |
| Q: I have a data set which is being updated and increases everydate. inshort we have a work group that ... A: Manni To give you a formula, I need to have an idea of what the worksheet looks like, but without ... | |
| adding up totals based on text in a column | 10/25/2007 |
| Q: I've got a basic spreadsheet with a column with several different text values. To the right of this ... A: Sam You need to use the SUMIF formula, I.E. =SUMIF(C5:D16,"warehouse",D5:D16) Where C is your text ... | |
| macro for copying and pasting in Excel | 10/24/2007 |
| Q: I am not really good in writing a macro and I need help. I want to paste 3 rows in every 3 rows ... A: Rick I am definately not a macro expert. I have written a macro that will insert a row whenever ... | |
| TIME SUBSTRACTION IIN EXCEL | 10/23/2007 |
| Q: I HAVE START TIME IN $C$2 22:52:52 AND END TIME IN $D$2 00:05:43. I WANT TO SUBSTRACT THE TIME. WHEN ... A: Sam Working with time is always a problem for me because the numbers are being stated in hour and ... | |
| Conditional List | 10/22/2007 |
| Q: i was trying to create two drop down menu in excel spread sheet. but data in second spread sheet ... A: Ruchika I have had this question before and I cannot come upwith a way to make the second dropdown ... | |
| Excel 2003 | 10/21/2007 |
| Q: I am trying to built a database in excel which may allow me to avoid spending time in entering too ... A: Fernando I just looked up Castro Verde on my world map--isn't the internet amazin we can talk all ... | |
| Excel 2003 | 10/20/2007 |
| Q: I am trying to built a database in excel which may allow me to avoid spending time in entering too ... A: Fernando Good morning (at least it is morning here in sunny Florida). I understand the first part ... | |
| Macro for excel indexlettre making | 10/19/2007 |
| Q: the problem I have is as follow. I have a list of 400 numbers all underneath each other in column A ... A: Emiel Rather than writing a macro, I suggest you create a template that has the formulas in it to ... | |
| Macro for excel indexlettre making | 10/18/2007 |
| Q: the problem I have is as follow. I have a list of 400 numbers all underneath each other in column A ... A: Emiel I believe I understand your question. I am not sure if you are familiar with Macros or how to ... | |
| Column Category Change | 10/17/2007 |
| Q: My question is that I have a table exported from a software and it has its first column type as ... A: Ernesto The Vlookup formula will work with either text or numbers, and should be working with your ... | |
| Offset Formula in a Financial Report | 10/16/2007 |
| Q: I found a report wich contains the next formula: =+OFFSET(Q185,0,$AX$1-1,1,1), the value of "Q185" ... A: Francisco the best advice I can give is for you to ck out the help in excel and look up the offset ... | |
| Excel date formula | 10/15/2007 |
| Q: I need to create a cheat-sheet for benefit eligibility dates. I need to know what 30 days plus the ... A: Kim If you put the hire date in cell A1 and in cell B1 you put the formula +A1+30, the result in ... | |
| VLOOKUP - CONTAINS | 10/12/2007 |
| Q: Vlookup formulas are only able to check a perfect MATCH between a cell and a list, right? Is there a ... A: Rita I don't know of a way to do your lookup exactly as you are describing it, But the search ... | |
| all possible combinations | 10/11/2007 |
| Q: i would like to know how to calculate all possible combinations of 4 numbers from 1 to 13. Is this ... A: Jason Sorry to get back to you so late, i was away from computer yesterday. I don't know of a way ... | |
| Excel Is Picking Up Data From Other Files! | 10/9/2007 |
| Q: I work in a Financial Reporting department, responsible for building and refreshing management ... A: JESSICA I haven't seen this specific thing happen but I have seen some inexplicable things go on ... | |
| Comments in Excel not working | 10/8/2007 |
| Q: I have been using the Comments feature in MS Excel 2000 extensively. I have inserted the Comments ... A: John Sounds like some strange things are going on regarding you comments. I don't know why some of ... | |
| copying | 10/6/2007 |
| Q: I have two excel documents, one has only one sheet with columns from A-G and rows start from 2 the ... A: Sounds like a perfect use of the VLOOKUP formula. With this formula you will be able to look up ... | |
| Paste Special | 10/4/2007 |
| Q: I was importing data into columns using VLOOKUP. As I wanted to get rid of the #N/A I copied and ... A: Clare Check the new file you are copying to and see if you are useing the same date system. Go to ... | |
| Dividing with Negative numbers | 10/2/2007 |
| Q: I have two columbs. One columb has margin dollars for 2007 and the other for 2006. I'm dividing ... A: Tim If you change your formula slightly you will get a positive percentage. Assuming cell A1 is ... | |
| Time calculations in Excel | 9/28/2007 |
| Q: Relating to atheletes performance times: I have exported data from the system we use to import into ... A: MARTYN Your times over one minute are stated in a combination of time and decimal format (i.e. ... | |
| Excel Macros | 9/27/2007 |
| Q: I have to write a Excel Macro to do different checks and do changes accordingly . Here are the ... A: sree Sorry I haven't gotten back to you I have been out of town without computer. I am not a macro ... | |
| Find combinations in Excel | 9/26/2007 |
| Q: I dont know if excel can even do this. If i have a column containing many values, is there a way ... A: MICHAEL You are right, the number of possibilities is so great that writing the formula to do the ... | |
| excel spreadsheet help? | 9/21/2007 |
| Q: I have a consignment boutique and i pay the people who consign with me once a month. I need a way ... A: CARA Certainly excel can handle what you need. But the allexperts generally do not create entire ... | |
| problem while opening *.xls file | 9/19/2007 |
| Q: I m unable to open files by double clicking on a *. xls file and that file can be opened by file ... A: Rajesh I do not know what wuld be causing this within the excel or office pograms. This should be ... | |
| excel spreadsheets/time keeping | 9/18/2007 |
| Q: i have created a spreadsheet to keep track of my employees hours, tips, etc. i am wondering if there ... A: Steve Time keepng is usually a problem because we tend to not state things properly. For example ... | |
| data sets and v-lookup | 9/16/2007 |
| Q: I have two sets of data that contain check numbers. I want to cross reference those two data sets ... A: CHRIS First I will suggest you check the help for VLOOKUP because they do a better explanation than ... | |
| zero figures | 9/14/2007 |
| Q: I have the following 5 numbers below, 38232633 38222731 310252631 35262734 37223233 but I was ... A: Wal Yes you can display the numbers the way you want using the following formula. +A1&B1 This is ... | |
| Excel | 9/13/2007 |
| Q: Could you help me please? I have 2 sheets of information. On the 1st sheet I have 100 lines of data ... A: IVAN You can use the Copy/paste special/transpose feature to do what you need. First paint tne ... | |
| vLOOK UP | 9/11/2007 |
| Q: if i record a macro to do vlookup for example 1000 trades and the next day the volume goes up to ... A: VENKAT I will attempt to answer although I do not totally understand your question. you can create ... | |
| Finishing time | 9/10/2007 |
| Q: I need a formula for a finishing time, from the computers time entering up to 10 time lengths. ... A: Greg I am not sure what else it could be. I've duplicated what you want to do (using the now ... | |
| Finishing time | 9/9/2007 |
| Q: I need a formula for a finishing time, from the computers time entering up to 10 time lengths. ... A: Greg The real key to getting your answer is the formatting of the cells. One of the selections in ... | |
| Loan Account | 9/8/2007 |
| Q: I want to create a macro for a ongoing loan account in excel. The loans are received and part ... A: Jatin You don't really need a macro, what you need is a series of formulas to calculate each step ... | |
| Excel macro to e-mail attachment | 9/7/2007 |
| Q: I have a simple macro attached to a "Send" button in an Excel Form. The code is: ... A: CARLOS I am definately not a macro expert and can't answer your question very quickly. I suggest ... | |
| row to column | 9/5/2007 |
| Q: How can I copy a row to a column? Thanks A: Moshe I assume you want to copy the cells in a row (going across)to cells in a column (going down). ... | |
| Comparison | 8/21/2007 |
| Q: Hey, So here's the situation, I have a calendar control on sheet1, and a bunch of data on sheet2 ... A: Ken I can kinda help you-- I believe the ability to clic on a cell and have the formula look it up ... | |
| Excel sums | 8/20/2007 |
| Q: I am trying to do a pay role and need one sell to add up 5 cells, then if the number is over 22, the ... A: Shayne If I am understanding the question correctly, this formula should work for you. ... | |
| 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: CHARLES Those pesky error messages can be a bit of a problem. You can use these to eliminate or ... | |
| OLE Action error | 8/14/2007 |
| Q: I'm working on the new work paper for my firm. We aim for a paperless procedure where we will insert ... A: Phi I havena't experienced the error message you are getting. I tried to create the message in ... | |
| Referencing and acting upon a drop-down list answer. | 8/13/2007 |
| Q: Apologies if there is a simple way of doing this that I've managed to overlook in my previous ... A: JULIAN I do not know of a way to create a dependent drop down list. There may very well be a way ... | |
| excel -tracker to calender | 8/12/2007 |
| Q: Afternoon RICH/ I USE A TRACKE RAT WORK TO KEEP ME IN CHECK WITH ALL MY PROJECTS. IN A COLUMN 'F' I ... A: NOEL If I am understanding correctly what you need, you can do this by linking to a cell on sheet1 ... | |
| how to make labels from a list | 8/11/2007 |
| Q: I made a list on Excel using several columns; the first column indicates, Mr/Mrs/Ms, the second is ... A: Perry The answers go through allexperts, and we don't even see your e-mail address unless you ... | |
| Checking row id if filled saving the document | 8/10/2007 |
| Q: I have a small question here. Well i have like row number given to my excel sheet which are ... A: Jawad If I understand the question correctly you want to create the inability to put numbers in a ... | |
| SUMIF | 8/8/2007 |
| Q: I have two main colums in my spreadsheet. 1st (column A)being a list of numbers i.e 240014, 260020, ... A: Louise I am not certain that I am reading your question correctly, but if I am, the reason your ... | |
| xls data | 7/24/2007 |
| Q: This is a very unusual one. I really do not think you will be able to help me, however at this point ... A: Brad You are correct, I don't have a clue. I don't believe it is an excel problem, but it could ... | |
| macro for data transfer | 7/22/2007 |
| Q: I have downloaded a huge data ( more than 300000 rows and 5 column) and saved as .txt file as Excel ... A: Joseph I suggest you transfer the data manually to the excel file, as it sounds as though you only ... | |
| If condition | 7/20/2007 |
| Q: How can I create a if condition with this information: I Have 3 possible values ("a number"; "<LQ" ... A: Amachado It is a little difficult to do what you want with one formula so I typically use several ... | |
| 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: Tan Yes you can. Go to toolbar/format/conditional formatting In the conditional formattin window ... | |
| Data in Columns | 7/18/2007 |
| Q: I have a list of column values that I am trying to organize via macro. Basically I have: A 1 A 5 A ... A: RON I am not sure that I totaly understand the question, but i believe you can do what you want ... | |
| If/Then Over A Range of Data | 7/17/2007 |
| Q: I was wondering how I can write an if/then statement over a range of data? For example, let's say ... A: Andy If you want to determine if there are any cells that are greater than 8% you could ask excel ... | |
| isolating values | 7/15/2007 |
| Q: I am trying to find a formula for Excel that will isolate the final 20 values entered in a ... A: TJ I don't know of a formula that will do what you need, but I believe you can do it with a series ... | |
| Pivot table? | 7/11/2007 |
| Q: Richard Roberts: In column A I have a series of dates. In column B I have one of three items, say ... A: Wayne I am not an expert in pivot tables, because I never use them, even though they are certainly ... | |
| Excel: Question generator | 7/10/2007 |
| Q: Roberts, I have a word document with nearly 500 questions. I would like an excel spreadsheet to ... A: Thomas I a working on your question. Can you send me a copy of your word document that has the ... | |
| Colour change of cell | 7/9/2007 |
| Q: how to change the colour of cell using IF condition A: Vishnu It is easier to change the color of the cell using condtonal formatting. Go to ... | |
| Question on creating one Stack Bar chart from two data tables | 7/8/2007 |
| Q: Richard. I used to do spreadsheet modelling, many moons ago, but have obviously forgotten even the ... A: PAUL My worst area in excel is charting--I usually fumble around and come up with something that ... | |
| Combining SEARCH with an array | 7/5/2007 |
| Q: I'm currently trying to have Excel scan through one column looking for any matches to words listed ... A: John I have been looking and cannot find a way to do all that you want with your search/lookup/find ... | |
| cutting/pasting | 7/4/2007 |
| Q: I'm trying to cut a part of one cell (the furthest right 9 characters) to another cell for multiple ... A: Mark Sounds like a perfect use of the "text to columns" feature of excel. This feature will ... | |
| Compound returns | 7/3/2007 |
| Q: Richard, Is there a formula that you're aware of that does a compound annual rate of return over a ... A: I am gonna guess that the 36 percentages that you have included actually represent increases or ... | |
| Linking sheets problem | 7/2/2007 |
| Q: I have a problem with linking two sheets in Excel. I will try to explain what I need. I have a sheet ... A: Kseniya Normally I would suggest that you use data validation in accessing your lists for the drop ... | |
| Plotting Stock Charts | 7/1/2007 |
| Q: I am not sure if you can help me with this, but I know that stock charts are often used for ... A: Marcy I am definitely not a chart expert, but it sounds as though you are trying to add each set of ... | |
| re: Creating a conditional pull down-menu | 6/30/2007 |
| Q: I am making a list of companies who supply products. If I select the company name from a pull-down ... A: Alex You can greatly simplify what you are trying to do by using the data validation feature ... | |
| timeclock conversion for payroll | 6/29/2007 |
| Q: Richard, I am needing an Excel formula that takes a clock in time and a clock out time that equals ... A: Joe Here is an answer I gave someone a coupleo of days ago that is on point with your question, ... | |
| Hyperlinks to images in Excel | 6/28/2007 |
| Q: I'm trying to create a simple database of sorts - I just want to organize my images for work, but ... A: Jodi I'm not sure what is causing the problem. I haven't experienced it nor have I had others ask ... | |
| Hi! | 6/27/2007 |
| Q: I want to update data by every day I need to copy one row of one sheet in workbook to another sheet ... A: Bui It appears that you can write a macro, so I'm not gonna suggest how you do that. What I will ... | |
| data type = hyperlink ? | 6/26/2007 |
| Q: I have an xls sheet that is regularly updated and which will be used as a source for an acces ... A: Roy I am definitely not an access expert, and it sounds like the problem comes with access side of ... | |
| Auto update of cell data with date | 6/25/2007 |
| Q: I am trying to do an automated update of the cell in comparison with last year record with the same ... A: Tan I'm not totally sure that I understand what you are trying to do but I will give it a try. I ... | |
| Hourly wage type | 6/23/2007 |
| Q: ok so im trying to make a formula that calculates how much time in hours has passed between to ... A: Josh The formula is really as simple as plus ending time minus start time. The key is the ... | |
| Sum data according to sample type and color | 6/21/2007 |
| Q: DATA SAMPLE COLOR R1 BLUE R2 RED R3 RED R4 GREEN R5 GREEN R6 BLUE C1 GREEN C2 GREEN C3 BLUE C4 RED ... A: nizam To create your table you have to go thru several steps. First you have to separate the data ... | |
| Compare dates and drop color if dates are same | 6/20/2007 |
| Q: I'm a beginner in writing macro. I have a spreadsheet where in each row shows the production date ... A: VANGIE You won't need to write a macro to do what you want, you will be able to do it with ... | |
| Excel, how to hide coluns? | 6/19/2007 |
| Q: Im trying to do a worksheet with something that can hide a column, maybe a button somewhere. What ... A: Rodrigo You can hide the columns with sensitive information in them by painting the column (clic on ... | |
| computers | 6/15/2007 |
| Q: how to lock a floder and how to hide the formula in excel shet ANSWER: Keshave Go to ... A: Keshave It would not be practical for me list all of the formulas in excel because there are ... | |
| Link Image | 6/14/2007 |
| Q: I need to insert an image (picture) into Excel so that it is linked to the original saved image. ... A: Debora Sorry i thought I answered this question several days ago. Actually I thought I didn't ... | |
| computers | 6/13/2007 |
| Q: how to lock a floder and how to hide the formula in excel shet ANSWER: Keshave Go to ... A: Keshave If by "folder" you mean a workbook them the protection is as mentioned in my original ... | |
| computers | 6/12/2007 |
| Q: how to lock a floder and how to hide the formula in excel shet A: Keshave Go to toolbar/tools/protection there you will see a choice of workbook or worksheet. You ... | |
| Conditionning formatting | 6/11/2007 |
| Q: I would like the background (pattern) color change according to the value in one cell. It is for ... A: Alan You should be able to do this with the conditional formatting feature in excel. Go to ... | |
| excel | 6/7/2007 |
| Q: i have a question regarding excel I have a spreadsheet that displays the project names is it ... A: Sue Yes it is possible to create a drop down menu that contains a list of projects from which to ... | |
| Vlookup | 6/6/2007 |
| Q: I want to use vlookup to return the the ADDRESS of a cell, not the VALUE. Is this possible? Thanks ... A: Thomas VLOOKUP is designed to return the value, it will not return the address. Sorry I'm not ... | |
| trend report | 6/5/2007 |
| Q: I have some data which consists of various projects and dates. and i would like to create a trending ... A: Bob I believe the best way for me to help you is to direct you to the help section of excel ... | |
| Excel consolidation of 26 worksheets | 6/1/2007 |
| Q: here goes...difficult without attaching files. I'm trying to consolidate a Year-to-date summary ... A: Lisa Tha answwer is easier than you might think. Yes when you copy the template formula over to ... | |
| look up question | 5/31/2007 |
| Q: I have 2 worksheets in a workbook. On sheet1, column A has the title "Fees" and lists about 200 ... A: Tim Sorry I think I answered your question yesterday but didn't hit he send button and lost the ... | |
| auto populate cell based on multiple selection criteria | 5/30/2007 |
| Q: I have a list of data, which include job titles, salary figures, and a numerical number representing ... A: Toby I am not sure that I understand completely the data validation issue, so forgive me if I don't ... | |
| average based on multiple columns | 5/29/2007 |
| Q: I have this problem to solve: I have a spread-sheet with 2 columns, one represents number of units ... A: Kris Don't know of a way to include (easily) it in one formula, but it would be relatively simple ... | |
| Is is possible to subtract 1 from every value on a worksheet? | 5/22/2007 |
| Q: Is it possible to subtract 1 from every value on a worksheet, the reason being, we are exporting ... A: Jonothan You can use the paste/special/value and accomplish exactly what you want. Here is what ... | |
| conditional formatting | 5/13/2007 |
| Q: i need to write a formula for conditional formatting. If the condition if A1+A2 = 2 it works fine ... A: SHAKEEL The conditional formatting depends on the result that is present in the cell. I.E. if you ... | |
| Excel Filtering | 5/11/2007 |
| Q: We have a spreadsheet at work where we use filters. It has days of the week as columns, names on the ... A: Mike I'm not sure what is going on with your filtering process--I've not ever experienced the ... | |
| Date Formula | 5/8/2007 |
| Q: I need to calculate the number of days from one date to another. I use this to calculate YTD pay ... A: Lisa You can use an IFTHEN formula to determine which date you calculate from, such as the ... | |
| formula | 4/27/2007 |
| Q: Could you please help me, I've tried, but haven't been able to figure it out. How can I get excel ... A: Claudia You can use the combination of conditional formatting and the NOW formula. First--in the ... | |
| charts | 4/10/2007 |
| Q: I want to create a chart to use in a Word document. I want the chart to display a high score, low ... A: Phil Sorry for some reason I did not get your question. I am a CPA and am super busy right now and ... | |
| Security with worksheets | 4/5/2007 |
| Q: I am building a budget, with confidential information, for our companies new fiscal year and wanted ... A: Amy You can restict access to a worksheet in 2003 and later versions, ... | |
| sum on specific data | 4/3/2007 |
| Q: Richard, I have per lines client names. In columns, I have billing amount, date to be billed etc. ... A: Emmanuel It looks as though the question is how do you get the sum of all amounts to be billed that ... | |
| capturing directory entries in Excel | 4/2/2007 |
| Q: I hope you can help me with a problem I am having. I need to be able to enter the directory entries ... A: Bill Sorry I don't know of a way to export your listing of folders and files to excel-----I would ... | |
| Auto Date Entry Removal | 4/1/2007 |
| Q: PLEASE HELP!! I am in the middle of entering data in a research spreadsheet and each time that I ... A: I'm not sure if they have changed something in the 07 version, I am not working with that yet. If ... | |
| EXCEL | 3/31/2007 |
| Q: Is there a way of copying the contents of an old spreadsheet to a new one or consolidating two ... A: Joseph Yes you can copy the contents of one worksheet to a new one, a couple of ways. Use the copy ... | |
| EXCEL SPREADSHEET | 3/30/2007 |
| Q: I am new to Excel and I would like a spreadsheet for compound interest witha monthly withdrawal, ... A: Joseph Sorry I'm super busy right now and won't be able to answer your question for a couple of ... | |
| EXCEL - Auto insert date | 3/28/2007 |
| Q: EXCEL - How do I place automatically today's date in a cell when on the same row I've added an ... A: Geoff Okay you want the answer to the hard question--how do we keep the date the same once it has ... | |
| excel question | 3/23/2007 |
| Q: We are in a rush to finish the budget, and we have one file that we share, now 2 people needs to ... A: Maria I don't know of a way to access the same file simultaneously, however I have accomplished the ... | |
| EXCEL - Auto insert date | 3/22/2007 |
| Q: EXCEL - How do I place automatically today's date in a cell when on the same row I've added an ... A: Geoff I can't tell from your question if you want your date to be absolute, I.E. to remain the same ... | |
| Conditional Formatting Duplication | 3/19/2007 |
| Q: I have 2 columns of date, both numbers. What I would like to do is set the conditional format with ... A: Mark You can paint all of the cells that you want formattd and then do the formatting. Or you ... | |
| word = value in a fromula | 3/18/2007 |
| Q: I am trying to setup a spread sheet to calculate local travel (mileage reimbursement) . The ... A: Reginald It sounds as though the easiest way to accomplish what you want is to set up a table or ... | |
| excel mail merge | 3/15/2007 |
| Q: I am trying to do a mail merge from excel. When the zip code shows up on the mail merge, the zip ... A: Onalie This should work for you-- Use the text to columns feature to separate the .000000 from The ... | |
| Linking workbooks | 3/14/2007 |
| Q: I need to link two workbooks for a report Workbook 1 contains payroll information by month for past ... A: Adele Without knowing exactly what your data looks like its kinda hard to be very specific, but a ... | |
| IF Condition | 3/13/2007 |
| Q: Please i want calculate a percentage value on a certain value if the value in that cell is >= 51000. ... A: Frederick Your formula tells excel to to the same thing whether the value is >=51000 or not, thats ... | |
| Date Formula | 3/12/2007 |
| Q: in one box I have a start date, in the next a finish date, how do I get the next box to work out the ... A: Claudia You can subtract the start date from the end date and divide by 7. for example Assume ... | |
| commandbutton to excel worksheet | 3/6/2007 |
| Q: how will i link my command button from a userform in microsoft visual basic to a worksheet in excel? ... A: John Right clic on the command button and pick assign macro, and then pick the macro that calls ... | |
| Find the left value of a sign | 3/1/2007 |
| Q: I have several cells with price plans. Some words and somewhere, at the end, or at the middle of the ... A: Lucian Sorry, I don't know of another way other than the text to columns. There may well be ... | |
| Reducing Balance | 2/28/2007 |
| Q: Say I want to find out how much I have spent and how much I have left to spend from my budget on a ... A: Jean I may not use the exact cell references because I'm not sure exactly where you want ... | |
| Excel Hyperlinks | 2/27/2007 |
| Q: Would you please tell me how to set up an excel hyperlink to a web URL that will open up explorer IN ... A: JAY I've not had the need to use the hyperlinks feature, so I have very little experience with it, ... | |
| need a formula | 2/25/2007 |
| Q: I need a formula that checks if any of the following columns L M & P has a value of 1, if the value ... A: Shalk Try the following formula =IF(VLOOKUP(1,L1:L9,1)=1,COUNT(L1:L9)," ") The formula says if ... | |
| Excel help | 2/21/2007 |
| Q: i have been trying to form a graph/chart for the variables i have. These variables are in different ... A: Rachit I'm definately not a chart expert. I spent two hours last night doing a chart for my ... | |
| Ebay Fees formula | 2/20/2007 |
| Q: from : http://en.allexperts.com/q/Excel-1059/Excel-ebay-1.htm How do you calculate Insertion fee ... A: Jason I don't have a clue about how the e-bay fees work, so I can't really give you a formula for ... | |
| Duplicate return with vlookup | 2/19/2007 |
| Q: I have two table 0ne is a table of players names and their batting averages.these are in no ... A: Mike Just noticed your question, I thought i answered it a week ago, sorry if you didn't get the ... | |
| nesting? | 2/17/2007 |
| Q: I have a spreadsheet that I am pretty sure I need to do some nesting but I cannot seem for the life ... A: Keeshia As with a lot of the questions I get, it is very difficult to state them clearly, so that ... | |
| Values in a cell | 2/16/2007 |
| Q: I enter a value X in a cell A1. In the cell A2, I want to display the content of the cell HX where ... A: Dan I definately am not sure exactly what you want but I'll try to give you an answer. My problem ... | |
| Excel spreadsheet | 2/13/2007 |
| Q: I have imported information into excel for a report. It is clients names and addresses. They run ... A: lenore The text to columns feature may work for you. Go to toolbar/data/text to columns. This ... | |
| adding cells | 2/8/2007 |
| Q: I want to be able to add a cell to itself and then keep the answer in the next cell down. Such as 25 ... A: Kris Sorry I don't know of a way to add the existing cell data to the new entry in the same cell. ... | |
| Is there a formula for this? | 2/6/2007 |
| Q: Please read my previous Q and A with Jan and read my follow up question.I was wondering if there is ... A: Matt If your numbers that may add up to 123.45 are randomly interspersed within your data then it ... | |
| Enquiry for Excel Help | 2/2/2007 |
| Q: Regarding a "IF" function, it will need a reference or condition to determine whether it is True or ... A: Chan The IF function can reference the EB only but it needs to ask the question of where the EB is ... | |
| formula values | 2/1/2007 |
| Q: I have a table as follows: A 1 25 2 32 3 45 4 73 5 6 175 I know how to calc the % of each value ... A: Butch One of the nice things about excel is its ability to change the cell references as a formula ... | |
| Adavnce Filters | 1/30/2007 |
| Q: I have the two columns data. In this i want use the Advance Filter, For ex. Colum F2 having List ... A: NP I'm not exactly sure what the data looks like, but the advance filter is available using the same ... | |
| rounding | 1/26/2007 |
| Q: I have to round up a total of 184,434 which is in cell b23 and I cannot figure the formula out. Any ... A: Rachel I'm not sure whether you are rounding to 1's, thousands, etc., but the formula looks ... | |
| open a file in network | 1/25/2007 |
| Q: Hallo Roberts, I copy a path of a folder and paste the address in cell C2. For instance ... A: Zulfatta Sorry, I'm not a macro expert-- It looks to me as though your path should work, but ... | |
| multiplying | 1/17/2007 |
| Q: I need to multiply a group of cells by a certain percentage. Can you please tell me how to do it? ... A: Doug I'm not sure from the qestion whether you are multiplying each cell in a group or the sum of ... | |
| index and match | 1/12/2007 |
| Q: I need to calculate a $ payout to be paid to an employee based on a Quality score that they achieve, ... A: Grant Sounds like a perfect application for the VLOOKUP function. With this function you can tell ... | |
| Excel - Formula | 1/11/2007 |
| Q: I have 2 columns of data which contain 26,000 rows of data. The first column of data contains Names ... A: MICHELLE This sounds like it might be a perfect application for the subtotals feature in excel. ... | |
| Excel Error | 1/10/2007 |
| Q: Your entry cannot be used. An integer or decimal number may be required A: Feroz I don't recognize this as an excel error message. Perhaps you are using a worksheet created ... | |
| Sorting Daily Dail Data Once a Week | 1/8/2007 |
| Q: I have three columns. I need to get the value in column C but only for the dates in column A .... ... A: Randy You can use a VLOOKUP formula to find the column C data on the appropriate date. The formula ... | |
| adding value to names list | 1/7/2007 |
| Q: I asked this question previously and gave the wrong email address. How do I total a names list? A: Pat I'm not sure that I'm understanding the questions, but I'm guessing that you want to know what ... | |
| if function: finding cells that contain part of the text in another cell | 1/6/2007 |
| Q: I have two sheets of data. In sheet 1, column A is a list of id numbers with the rest of the ... A: Kristy I think I understand-- Wht I believe will work for you is a formula that looks something ... | |
| if statement | 1/5/2007 |
| Q: I am trying to find a formula for: If qty order > bulk order qty then total=bulk order price * qty ... A: Carey You can create this formula similar to the way you have written it, by just referencing cells ... | |
| conditions with "IF" | 1/3/2007 |
| Q: Happy New Year! I'm using a Spanish version of MS Excel 2003. I need to be able to do the following ... A: John Try the following ... | |
| quote system using combobox | 12/29/2006 |
| Q: I'm working on an excel quote system that uses combo boxes. There are 11 worksheets in my document. ... A: BILL I may not be completely understanding the way you have it set up, but how bout this. List ... | |
| excel; averaging blank columns | 12/27/2006 |
| Q: I have a spread sheet that when the cells are blank, the average at the bottom is ########. I've ... A: Randall Ck a couple of things 1--usually the ###### signs indicate an amount that is to large for ... | |
| Formulas | 12/25/2006 |
| Q: lately when I've been using Excel and I input formulas, it works the 1st time around, but when I ... A: Joon When you say the formula doesn't work anymore I'm not sure if you mean it isn't calculating at ... | |
| Work sheet question | 12/21/2006 |
| Q: I have a macro that fires up an input box. From there I create a new worksheet, based on the ... A: Christopher I don't know of a name ck that will let you test for existing worksheet names prior to ... | |
| Writing macros in excel | 12/20/2006 |
| Q: I'm having trouble with the Find Function. A have an excel speadsheet that contains the name , ... A: cigdem Try using the VLOOKUP function You can use it to look up what you type in a cell and bring ... | |
| EXcell logical test | 12/19/2006 |
| Q: I am trying to test for a condition and add appropriate text into 2 cell in excell, but having ... A: Talat Your first formula works fine for me. It should not matter if the cell K44 coantains a ... | |
| Compare dates in Excel | 12/13/2006 |
| Q: I'm trying to build a spreadsheet that lets you make an itemized list of purchases in one worksheet, ... A: I think I understsnd the question--try a formula that looks like this. ... | |
| Filtering email | 12/12/2006 |
| Q: I have rows with columns consist of Ship Details, such as Ship Name, Operator, Owner, Operator ... A: Shah You can filter the list with a simple sort, by e-mail address, then pick out only one e-mail ... | |
| computing grades | 12/11/2006 |
| Q: I just would like to ask, how to compute grades with 75 % as the passing. Thank you. Cris A: Cris Not sure exactly what you are needing, but to compute a percentage in excel you use a formula ... | |
| EXCEL | 12/5/2006 |
| Q: HAVE A SPREADSHEET THAT SUDDENLY HAS 6 PAGES ONLY 3 HAVE DATA THE LAST THREE ARE BLANK HAVE TRIED ... A: Susan Haven't heard of that one, but I assume that by "tried deleting" you mean that you have ... | |
| Visual Basic / Macro Problems | 12/4/2006 |
| Q: We have an Excel spreadsheet which contains macros to work specific functions on this sheet. We have ... A: I'm not really a macro expert, but a couple of mistakes that I make are using the absolute/relative ... | |
| sorting a pivot table | 12/2/2006 |
| Q: Can a pivot table be sorted by the grand total column? If so, how do you go about it? A: Dan Sorry I don't use Pivot tables, and as such don't really have the experience to tell you if it ... | |
| Formatting In Excel | 11/30/2006 |
| Q: Richard I am creating a dictionary. I have 2 columns 1 Jarai & 2 English. I want to combine the ... A: Tim If the formatting is different in each of the two cells that you are combining the data from, ... | |
| macro | 11/29/2006 |
| Q: I am not familiar with macros and how much is possible to do with it. I am looking for way to apply ... A: Margo It is possible to do just about anything with a macro--so I'm guessing that you can do what ... | |
| Vlookup | 11/27/2006 |
| Q: I know how to use Vlookup, but but a small problem with multi value range example. sheet 1 has ... A: I'm not absolutely sure what the quesiton is but-- when you use VLOOKUP it will return the first ... | |
| interest rates | 11/26/2006 |
| Q: If I have a dollar amount to be invested and have a future value for that investment and a number of ... A: CARROL I don't use excel for this type of calcualtion since I have another program that does it a ... | |
| SUMIF problems | 11/25/2006 |
| Q: I have a spreadsheet that uses the following formula: =SUMIF('COMAH Data'!H3:H4000, "R53", 'COMAH ... A: Duncan The SUMIFAND formula won't work, so what i do is crate the criteria in another column that ... | |
| Prob. in Excel 2002 sp1,sp2 but working fine excel 2003-sp2 | 11/23/2006 |
| Q: In our excel sheet, we are populating data in a combo box from another excel sheet. for this , we ... A: Amie I'm not a good one to answer your Question I don't have excel 2002, and I haven't experienced ... | |
| unsure about a command | 11/22/2006 |
| Q: Ok this is a little hard to explain since I am new with Excel. I am making a workbook to keep track ... A: Yes it is possible to create a macro to do all that you want. However since you are new to excel I ... | |
| Shortcut key | 11/21/2006 |
| Q: When we select a range, in the status bar we can see the count/sum/avg etc. Is there any shortkey in ... A: Harendra I'm not sure I'm answering your question, but a way to get the functions up and to fill in ... | |
| Depreciation | 11/17/2006 |
| Q: I have the following in these columns A B C D E F Item ... A: Ok Formula for column E should look like this =IF(D9-(NOW()-B9)/30>0,C9/D9,0) Formula for column F ... | |
| printing excel spreadsheets | 11/16/2006 |
| Q: How do I print spreadsheets with 4 pages and get the headers on each page. When I print pages 2-4 ... A: Fran Two ways to print headers One is to use the option of Rows to repeat at top feature which is ... | |
| Multi Condition Sum Column | 11/13/2006 |
| Q: Richard, I was hoping to show only the totals on the second worksheet. Worksheet A: Date ... A: Only The subtotals will show if you click the column "2" at the top left of the sheet-- this ... | |
| Multi Condition Sum Column | 11/12/2006 |
| Q: Richard, Have a workbook with 2 worksheets, Worksheet A has numerious entries of expenses. Date ... A: There are a couple of ways to do what I believe you want, but I'm not exactly sure what you want. ... | |
| Excel formula's | 11/6/2006 |
| Q: My Question is: Staff Scheduling for payroll purpose new cupe agreement Example for Friday's Shift ... A: John I'm not sure what the question is--ck wht you asked I think it says "is it possible to make a ... | |
| VBA | 11/5/2006 |
| Q: Let's say I have 10 country names in a listbox and an another excel sheet that contains similar ... A: Hasan Sorry I've been away from a computer for a few days-so didn't get to your question. Whats ... | |
| Actual/360 amortization formula for excel | 11/2/2006 |
| Q: I am trying to change my formula or use a new one to calculate more accurate monthly payments based ... A: Nicole I don't know of a different way of doing it. I don't get any diffeence between what ... | |
| Sum Product | 10/31/2006 |
| Q: I was wondering if you wouldn’t mind helping me real quick. What I need to be able to do in my ... A: Arthur You need a couple of diferent formulas for each column. First you need to separate the data ... | |
| Hyperlink | 10/27/2006 |
| Q: I hope you can help me with this problem, seams very simple but I don't understand what is ... A: Elsa Sorry I'm not a power point expert, and in fact I've used it very few times. I suggest that ... | |
| WORKSHEET NAME | 10/25/2006 |
| Q: HOW TO DISPLAY THE WORKSHEET NAME IN A CELL AND ALSO TO USE IT IN AFORMULA A: Ramon I am not sure that I correctly understand the question, and I don't want to be flippant but ... | |
| Dates- urgent | 10/24/2006 |
| Q: I have been given new data for a finance project ( a week before its due!) and I am having trouble ... A: Calli Here is what you do First separate the number into three columns using the text to columns ... | |
| Suming numbers based on dates | 10/23/2006 |
| Q: Robert, I am having trouble making a formula that will look into another sheet for a specific ... A: Arthur I just noticed that this question is on the unanswered list, I'm sorry I answered it several ... | |
| excel sort | 10/20/2006 |
| Q: That does work but I need to bring those cells back together. How do I do that?I need to sort a list ... A: Golden What you need now is an & formula. Assume the text is now in columns A,B,C,D and you want ... | |
| IF + COUNT + OR | 10/17/2006 |
| Q: I have a list in column B. I am currently using the following formula (trying to define which client ... A: It looks like what you need is the same formula in each case, added together, but the second ... | |
| excel question PLEASE HELP | 10/16/2006 |
| Q: I want to be able to reference a certian column on one sheet and use that information (ex: cell has ... A: Alan Sounds like you need a formula that is linked to another sheet and is dependent on the contents ... | |
| Color coding of cells per a list of values | 10/13/2006 |
| Q: Is it possible to select a list of items to be totaled, and have the cells the items reside in color ... A: I'm not sure I understand the question, but it sounds like you are wanting the conditional ... | |
| 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 to ... A: Daniel Sorry--- I thought I had answered your quesiton, but I just saw, on allexperts, that it was ... | |
| Creating a budget in excel | 10/4/2006 |
| Q: I'm creating a budget so it's simple to the user. I have the columns: Item (i.e. Mobile); Amount ... A: Lisa It appears that an IFTHEN formula would work for you. I'll give you an example. Where column ... | |
| Finding data and going to that cell | 10/3/2006 |
| Q: I used VLOOKUP to compare text data in cell b2 to an array in a2:b9996 and it displays the text in ... A: Steve I may be looking at it wrong, but can you use the find feature in the excel toolbar?? ... | |
| Excell | 10/2/2006 |
| Q: Richard, When I use the formular as you suggested all I get in the destination cell is the formula ... A: Lance If you are inputting exactly as in your question, the problem is that you are not putting an ... | |
| Stuck on formula | 9/28/2006 |
| Q: I have created a spreadsheet to track stock purchases. My aim is as follows: each time I purchase ... A: Patrick Sorry for the delay in answering, I've been out of town, away from computers. I may be ... | |
| Excel Macro F2 Function | 9/27/2006 |
| Q: I need a Macro to insert a "1" in at the end of a string of 4 numbers but before a text word in a ... A: Gordon A macro would be nice, but I don't know how to change it to make it put the 1 behind the ... | |
| Saving two different versions of same spreadsheet in 2 different locations | 9/25/2006 |
| Q: Unfortunately I am a complete novice and don't have much of a clue when it comes to macros. Here is ... A: Sarah I'm not a PDA expert, so i don't know if there is anything special about the Macro that you ... | |
| Saving two different versions of same spreadsheet in 2 different locations | 9/24/2006 |
| Q: Hi Bill, What I want to do is save an EXCEL spreadsheet in two different locations (for future ... A: SARAH All you need do is change the code in the macro that reflects the range of cells that are ... | |
| Excel Autofill | 9/23/2006 |
| Q: I have used the autofill function in the past with much success. I am now trying to autofill from ... A: Bob Autofill is used to fill a series of dates, numbers, etc. where there is a logical progression ... | |
| Deleting Lines | 9/22/2006 |
| Q: I'm trying to delete lines in Excel that contain any of these: LLC LP HOMES A: To keep it simple I suggest the folowing--- Use the find and replace feature to find where the ... | |
| Vlookup | 9/21/2006 |
| Q: There is a raw report which is created monthly by access database and it is my raw report. I also ... A: NINA I just noticed that your question is listed as being unanswered--I'm sorry I thought I had ... | |
| Creating Combinations of people from column | 9/20/2006 |
| Q: I have two columns of data that looks like this Name Journal1 Journal2 Sam 1 0 ... A: I don't know of a formula that will create all of the possible relationships, and I can't really ... | |
| Summing a balance from multiple columns and criteria | 9/19/2006 |
| Q: Richard, I have a two sheets inside an excel file. On of the spreadsheets has all the data from a ... A: Arthur Everytime I need to create a formula that will do what you are wanting to do I always end up ... | |
| Excel graphs | 9/18/2006 |
| Q: It is a problem I have experienced many times when trying to use automated graphs within excel and I ... A: Jo Sorry I'm definatly not an expert in graphs--I seem to have as many problems as most people do, ... | |
| invoices | 9/15/2006 |
| Q: I'm setting up an invoice for a very small business and I have an Item column, what I want to do is ... A: Helen You can use the VLOOKUP function to to look up the item code in a pre made list and return ... | |
| Correct change for workers.. | 9/12/2006 |
| Q: A relative of mine has a factory and he has a problem for 10 years. He has to pay his workers in ... A: Nour Here is how I would handle it. first column= name second column=amount of pay third ... | |
| Excel | 9/8/2006 |
| Q: A friend using Excel wants to add cells A1, A2, A3, A4, A5 (without typing =A1, A2, A3, A4, and A5). ... A: KEITH Tell her to try this =SUM(A1:A5) This is usually on the toolbar using the greek sigma or ... | |
| Creating negative number columns | 9/6/2006 |
| Q: Im trying to create an expense column. And what i want is for any number entered in the column to ... A: Eric If you want to enter the number directly into the column then you need to enter it as a ... | |
| Modifeid Date | 9/5/2006 |
| Q: Is there a way to apply a last modified date, reference the cell changed and the user who made the ... A: leah There probably is a way to do what you want, but unfortunately I don't know how. I suggest ... | |
| CSV File | 8/20/2006 |
| Q: I export a query from MS Access to MS Excel. It looked all ok. Now from Excel, I tried to save it as ... A: Howard I copied the following from the IMF website, Hope fully it will have some informatio that ... | |
| Excel VBA Procedure | 8/18/2006 |
| Q: I want a Excel VBA Procedure that deletes rows on a worksheet based on a list on another worksheet. ... A: Jeff Ck out your question and see if you can reword it I'm not sure exactly what "Column A is the ... | |
| formatting currency change | 8/17/2006 |
| Q: I have a spreadsheet where one cell has a drop down list of different currencies. Another cell ... A: Shannon You may consider the condiional formatting feature, whereby the format of the cell will ... | |
| RANDBETWEEN | 8/16/2006 |
| Q: I am trying to utilize a multiplication table I set up for my daughter using random numbers. I have ... A: DEBBIE I'm sure you have checked out the reasons that the error #name? appears, if not go to the ... | |
| Time sheet formula | 8/15/2006 |
| Q: I have created a formula in a time sheet. Our conversion chart goes 0-5 minutes should be ... A: Vicki I'm not exactly sure what you are trying to do with your formula, but usually time formula ... | |
| Vlookup & If statement | 8/14/2006 |
| Q: I am trying to sort out a formula which will allow me to do the following: O - Original/Resultant ... A: MATTHEW I'm not quite sure in reading the formula whats going on with it but, I believe you can do ... | |
| EXCEL VB DATE QUESTIONS | 8/13/2006 |
| Q: I am new to coding in excel and VB. I am inquiring about some advice or direction on how to check ... A: Mr. LaBounty It appears form the information you are giving me that you can solve the problem with ... | |
| Macro | 8/11/2006 |
| Q: I would like to create a macro that copies all the info from sheet2 (column A,B,C row1 always), ... A: SAM You can create the macro by simpoly recording the keystrokes necessary to do all of the ... | |
| creating results in different cells | 8/9/2006 |
| Q: Richard Thanks for your reply. However those formulae don't do exactly what I need. I don't think ... A: Jamie The formulas should work EXCEPT The reference to $D1 in the formulas should be changed to ... | |
| Nested IF Statement Regarding #Value! Cells | 8/1/2006 |
| Q: I have invoice spreadsheets that sometimes get the #Value! error. I have used the formula ... A: Couple of observations I am not aware of a formula that will hide a row or column. ... | |
| Excel File option | 7/29/2006 |
| Q: I want to ask you about one Excel file which I received by e-mail, in that Excel file there is one ... A: Jamil I believe that the option you are referring to is the subtotal option. It is found on the ... | |
| Formula's | 7/26/2006 |
| Q: I need a formula that is can use to calculate current ytd vs. prior ytd. Maybe an example: a 1 ... A: Regina I can't give you a specific formula because I don't know what you data looks like, but myabe ... | |
| Excel search | 7/25/2006 |
| Q: Sir, I have this simple task and I am very much sure there is some programming solution round ... A: Byju Try the following lookup formula. =VLOOKUP(A1,'consolidated indexing'!A$1:A$8000,1) The ... | |
| Range Within Range | 7/19/2006 |
| Q: Richard, I am trying to create a pivot table report in Excel 2002 that calculates the percentage of ... A: Ken I may not fully understand the problem, but lots of times the issue is how the data is set up ... | |
| macro to calculate Decimal Deg | 7/18/2006 |
| Q: I have the data in the column C,D is in the following format. lat lon ... A: Shah I'm not a real MACRO expert, but here is a simple way to write the macro. Go to ... | |
| different in behavior between protect and not sheet | 7/12/2006 |
| Q: Let me explain the situation. I have a excel sheet that has many unlocked and locked cells. The ... A: Jerry Yes I believe that the result you are getting is because of the locked cells, and ... | |
| need a formula | 7/7/2006 |
| Q: my problem is that i use date of birth at my work to supply insurance comapnies with census for ... A: Len Sometimesw working with dates can be a bit problematic. How about this formula to solve your ... | |
| Excel data check | 7/5/2006 |
| Q: I am working on inserting 300 data entries into the computer. My question is: is there a way to ... A: Tileng The best way to check the data entry would be to use some method of tallying the original ... | |
| CONVERTION OF NUMARIC IN TO WORD | 7/4/2006 |
| Q: I TRY TO MAKE INVOICE IN EXCEL SHEET. IN THE END OF INVOICE I WANT TO WRITE THE AMOUNT OF INVOICE IN ... A: Mazhar The closest conversion is the function TEXT, which will ocnvert, but I don't believe will do ... | |
| combining stacked and column charts - graph is wrong | 6/20/2006 |
| Q: I wanted to show net and gross returns in one bar on a column chart and compare it to an index ... A: CARRIE Sorry I'm just getting back to you-- I hae a broken computer, and haven't been able to get ... | |
| Sorting a worksheet | 6/16/2006 |
| Q: Would you kindly explain how to code the following problem that I'm having. 1. Worksheet with ... A: Harry Sorry I've been away from my computer and just saw your question. first-let me say that I'm ... | |
| combining worksheets | 6/13/2006 |
| Q: I have a daily workbook with 10 worksheets in it I need to copy all the tabs into one worksheet ... A: Mike Not knowing all of the parameters of your worksheets its a little bit difficult to answer, ... | |
| calculating hours | 6/11/2006 |
| Q: I am a lorry driver I have a spreadsheet formated custom hh:mm in cells A2:A6, A2 is the start time ... A: Phil I'm a bit confused with your question, so I'll ask a few questions of my own-- What time ... | |
| Date Formula | 6/9/2006 |
| Q: I have month-end reports I run and save and I'd like to always have one cell reflect the prior month ... A: AJ You might use the end of month formula in conjunction withthe NOW formula as follows: ... | |
| Expiration date macro | 6/8/2006 |
| Q: I saw the foloowing posting. I do not know how to srite a macro. need to do the same thing can you ... A: John I can't do any better than the explanation in the answer to the other questions--as follows ... | |
| Problem with Macros in Excel 2000 | 6/7/2006 |
| Q: I developed an Excel 2003 spreadsheet with an embedded worksheet form button with an assigned macro ... A: Mohan Sorry I'm not gonna be able to help you much with this. I've not had the need to develope ... | |
| IF function in excel | 6/5/2006 |
| Q: I have a relatively simple problem - well not for me. I have numbers in column A from 1 to 50.Some ... A: Marke Ok here is the formula =+IF(ISBLANK(A7)," ",IF(AND(ISODD(A7),A7<10),1,0)) I'm not totally ... | |
| Printing invoices with excel | 5/28/2006 |
| Q: Can you help me please to make invoices in my PC, filling automatically from a data base in which ... A: August Sorry I hven't gotten back to you quicker, I've been out. Your question encompaaaes a lot. ... | |
| keystoke command for 'dragging out' in excel | 5/20/2006 |
| Q: I use the 'drag out' feature quite often in excel. Whether it is a date that I am 'dragging out' to ... A: Edward The only way I know of to make it quicker is ===copy the Formula hold the shift key down and ... | |
| pie charts from spread sheets | 5/17/2006 |
| Q: I have a spreadsheet for budget. Want to make pie chart for expenses, but spreadsheet includes ... A: I don't know what your data looks like or how you've created subtotals, I.E by your own formula for ... | |
| Recursive Search in Excel | 5/16/2006 |
| Q: i have a table with 3 columns EMPID, RptMgrID, Level Empid = employee ID RptMgrID = Reporting ... A: Venu You can create a table from the existing table that will only bring forward (to the new table) ... | |
| set format | 5/15/2006 |
| Q: I have a sheet with the column for time the format should be h:mm:ss, the time begin with 0:00:00 ... A: Shah I don't understand the question-- are you trying to write a macro that will create the ... | |
| Custom Filter with Relative Date | 5/10/2006 |
| Q: I am working in Excel 2003. I am tracking an extensive list of projects with due dates. I would ... A: Doug How about this approach First use a column with this type of formula in it to identify all ... | |
| big help | 5/7/2006 |
| Q: This is a long one. I hope I can explain it. I have a spreadsheet template that is pre filled out ... A: Steve If I'm understanding the problem correctly I believe that you can do what you need with the ... | |
| recurring payments in budget | 5/2/2006 |
| Q: I'm fairly new to excel. I am building a budget and I am looking for a way to have excel ... A: Ed How about this as a solution. Use an IFTHEN formula to determine if the day is the 1st then ... | |
| excel deleting rows with a macro | 4/28/2006 |
| Q: I do not know how to program a macro - but theoretically I can figure out what could be the best way ... A: Oma I see what you are trying to do with the macro. Since the macro is specific in its coding I ... | |
| vlookup | 4/18/2006 |
| Q: can u please tel me how to use this function (or any other function) to lookup for all the values in ... A: makeymv Can you better describe to me what your data looks like? In your question you refer to a ... | |
| Excel2000-XP Home | 4/13/2006 |
| Q: I have downloaded data from internet with IE edited with MS excel. On spreadsheet column of weigths, ... A: Gene Sorry I don't know a way to fix the download--it sounds like there will only be the choice of ... | |
| 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: Sy Try using the data validation feature and putting a message in that will alert your co workers ... | |
| Audit Trail problem | 4/4/2006 |
| Q: Richard. I have got a workbook originally designed in 97SR2 but now in use in 2000. It has approx 45 ... A: Graham In my experience the "not enough memory" message has been the result of the PC RAM, I've ... | |
| 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: Joel The formula you are using should round correctly--if applied to the result of the first ... | |
| Excel 2004 operating slooooooow! | 3/27/2006 |
| Q: Using Excel 2004, we have set up some very basic estimating sheets for the jobs we do. No heavy ... A: Michelle I don't have the 04 version of excel nor do I have a Mac so my experiences may not be the ... | |
| countif | 3/23/2006 |
| Q: I have two questions. I am first wondering how to simplify a simple repetitive formula. Here is a ... A: Luke I don't know of a way to write your COUNTIF formula any simpler assuming the object is to add ... | |
| 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: June You can merge the two together by using the following of formula. Assume the first zip is in ... | |
| DESLOC function returns #VALUE! | 3/21/2006 |
| Q: Sorry, The function DESLOC is for the brazilian version. It means the same as the OFFSET funcion in ... A: Rogerio The linked spreadsheet must be open to make the link effective. If, after having updated ... | |
| E | 3/20/2006 |
| Q: I'm working with excel 2002. When I copy a table from a PDF to excel, I lose the formating. Each ... A: Jamal You can use the test to columns feature to separate the data in the cell. This feature will ... | |
| DESLOC function returns #VALUE! | 3/18/2006 |
| Q: When I open a spreadsheet that uses the DESLOC function with onother linked spreadsheed it returns ... A: Rogério Sorry I have two version of excel 2003 and 1997, and I cannot find the DESLOC function ... | |
| Excel Formula | 3/17/2006 |
| Q: In Excel 2003, I need to write a formula that works this way: if Cell A1 is less than 1200 but ... A: DAN Yes it acan be done, the formula looks like this =IF(AND(A1<1200,A1>599),1)+IF(AND( ... | |
| Excel | 3/16/2006 |
| Q: I have a document that contains a list of departments, within the departments there are cells that ... A: Tina Not knowing exactly how your document is set up I'm gonna make some assumptions as follows: ... | |
| Color Change | 3/15/2006 |
| Q: Good Afternoon, I am hoping you and tell if there is a way that I can change a color of a cell. ... A: Jim You can use the conditional formating to do what you want. Go to toolbar/format/conditional ... | |
| ebay spreadsheet help please | 3/12/2006 |
| Q: I have several questions regarding my ebay spreadsheet. Please help. I have written a formula to ... A: JESSA Answer to your questions 1 and 2. Use this formula =IF(G3>0,(+G3+H3)*0.0295+0.3," ") This ... | |
| excel summing | 3/11/2006 |
| Q: In a column I have two different values: a percentage cell and a function cell. The function cell ... A: Michael I don't know exactly what you are trying to do, but you might consider using a formula that ... | |
| sumif formula | 3/10/2006 |
| Q: I am trying to write a sumif formula, in excel, to work out this problem: I have a range (G20:G34). ... A: Chris I'm not sure from your question is you want to Sum the amounts in the range or count the ... | |
| split 2 words in one cell to 2 cells | 3/8/2006 |
| Q: I have a first name + family name in colomn A1 (for example, Bill Clinton). I wish to split the two ... A: Moshe That's amazing I had exactly the same question yesterday from someone else. I'm going to send ... | |
| un merge cells | 3/7/2006 |
| Q: I have a simple question, can you un merge cells in excel, I have names that I want to split up ... A: June It sounds like you have the full name in the cell I.E. John,Doe. If that is the case what you ... | |
| Importing data from closed workbook | 3/6/2006 |
| Q: I'm writing a macro in Excel 2003 would like sample code on importing a cell value (eg. "Bill" in ... A: Ross You can use a linking formula to import the data. The linking formula will still work after ... | |
| Listing Spreadsheet Functions/formula/macros | 3/4/2006 |
| Q: Is it possible to produce a report/list of all the functions/formulas/macros that are in a spread ... A: Ian You can display the formulas in each cell by selecting the formulas option in the view tab--go ... | |
| Columns of information | 3/3/2006 |
| Q: I have an excel sheet to track the order numbers picked by my team members. They are arranged in ... A: Michael Now knowing what our data looks like, I.E. what column and row is occupied by the data its ... | |
| Mass Formulation! | 3/1/2006 |
| Q: How do I do a mass computation in Excel to a whole range of numbers? Like, if I have a whole row of ... A: J If you want to sum the numbers in the range and then multiply by 1.5, then you need a formula ... | |
| Excel | 2/28/2006 |
| Q: I am using Excel 2000 (9.0.2720) to keep text-type data about places where people do volunteer work. ... A: diane Sorry I'm slow getting back to you I had a hard drive crash on my computer. Anyway---You need ... | |
| Excel function | 2/26/2006 |
| Q: I need to paste the value of the checking balance into another cell. The problem is the balance is a ... A: Fred Most ckbook balances have a column for deposits and a column for checks. If this is true with ... | |
| MULTI ATTRIBUTE UTILITY TABLES | 2/25/2006 |
| Q: I AM TRYING TO MAKE TWO MULTI ATTRIBUTE UTILITY TABLES ONE WITH TWO OPTIONS AND TWO ATTRIBUTES AND ... A: Robert I need a bit more information. Since what you describe might be done in a number of ways ... | |
| Macro writing | 2/24/2006 |
| Q: Roberts, I am currently recording macros to pull information from a worksheet and placing it on ... A: Jason I'm not a real macro expert, so I'm not a good one to give advice on your question. However ... | |
| Hello Richard I have an... | 2/23/2006 |
| Q: I have an excel worksheet with a lot of data but only four field SysID alphanumerical ... A: Jose I'm not sure what is meant by "the 10 top SysID that spent more parts and the 10 top used ... | |
| pulling info from a database | 2/21/2006 |
| Q: I am trying to pull information from a database, that has to meet several criteria. I tried using ... A: aLAN Sorry to be late in getting back to you. I can't produce an answer that yields the value of ... | |
| Excel 2003 - lookup | 2/20/2006 |
| Q: I have the table set up in D4-f17. (Country,currency,rate of exchange.) A5-b8 is the place for ... A: CDP I'm not real clear on how your data is set up, etc. but try this. Use the VLOOKUP function to ... | |
| ? | 2/18/2006 |
| Q: .. can i please ask you... I have an excel spreadsheet with email addresses scattered all over it, ... A: Greg Not knowing exactly what your data looks like I'll make a suggestion that should work for you. ... | |
| Excel Question | 2/14/2006 |
| Q: I have been using Excel for a number of years. I have never needed to use any advanced functions, ... A: JC Excel can handle your problem with a formula that references the sheet you want to transfer info ... | |
| Wrap text | 2/13/2006 |
| Q: I have a spreadsheet that someone had sent my boss where part of the text is not printing when it ... A: Michelle I don't know exactly what is causing the problem, but its likely it is some type of ... | |
| excel formatting | 2/7/2006 |
| Q: I'm running Office 2003. In Excel, if someone sends me dates that are formatted in this manner: ... A: Jerry If you are using the RANDBETWEEN() function I don't know why you would be getting the two ... | |
| Is there a function to compare... | 2/5/2006 |
| Q: Is there a function to compare data in two columns, then return values that are not in your primary ... A: Millie Yes you can use the VLOOKUP in an IF formula to accomplish what you want with a formula as ... | |
| excel formatting | 2/2/2006 |
| Q: I'm running Office 2003. In Excel, if someone sends me dates that are formatted in this manner: ... A: Jerry Since the formatting that you have, 20041225, isn't an accepted date format in excel 2003, we ... | |
| Delete initial blank space in data | 1/30/2006 |
| Q: but still cant get it. Im not sure I was clear enough with my query- I have collumns of data. ... A: Steve Yes I misunderstood the way your data was set up. I still think text to columns will do it, ... | |
| Delete initial blank space in data | 1/29/2006 |
| Q: I stumbled upon your site while looking for this answer. I imported my financial records into excel ... A: Steve The text to columns solution should work. Maybe you aren't approaching it correctly. I ... | |
| LOOKUP command | 1/27/2006 |
| Q: I am trying to get the following: I have in column “B� these numbers: 20, 25, 30, 32 and in ... A: Mace Sorry I've had a computer crash and haven't been able to get back to you. I like to work out ... | |
| Text Formatting | 1/27/2006 |
| Q: Richard, Hope that all is well. I wanted to see how I'd be able to format a cell so that at normal ... A: Mark I believe you will be able to do what you want with the conditional formatting feature. ... | |
| Date question | 1/27/2006 |
| Q: I have 2 dates Start Date Maturity Date Need to return a quarterly payment like Month/Day/Year ... A: Jane Sorry for being late, I just got your question tonight. I don't use excel for payment or ... | |
| Excel Formula | 1/26/2006 |
| Q: Richard,I often save data to excel spread sheets which may look as follows. MI / B2530/ 2/ 10.75 ... A: DARREN Try the following formula: {=+SUMIF(A1:A7,"OT",D1:D7)} Where column A is the column with OT ... | |
| Saving cached links into Excel | 1/25/2006 |
| Q: My boss wants me to save links into an Excel 2000 spreadsheet in such a way that when you click on ... A: Dinah Sorry I've not done what your requesting so I'd have to do some research to figure it out. ... | |
| Scrolling text box | 1/21/2006 |
| Q: Using Excel 2003, is there any way to create a simple text box with a scrollbar (up/down)? Text will ... A: Al Sorry I can't give you a really good answer on this, but--yes you can do it. I've done in the ... | |
| Excel Macros | 1/20/2006 |
| Q: I am a analyst and have joined my new job only a few months back. I need to know about Excel macros. ... A: Raina I'm not much help because I'm definatly not a macro expert, but I'll make a few suggestions. ... | |
| Excel for ebay | 1/19/2006 |
| Q: ------------------------- Followup To Richard That looks great, only one thing I didnt mention,The ... A: Joe Take the original formula I gave you, put parenthesis around it, and put a minus sign befor the ... | |
| Excel for ebay | 1/18/2006 |
| Q: i am looking for a one line formula if possible to track final value fees on ebay.from .01 to 25.00 ... A: Joe Try out this formula Where A1 is the sales price ... | |
| Filtering data using Excel 2000 | 1/17/2006 |
| Q: Hope you can help. I have Excel 2000 version 9.0.2720. I use a database list to record all my spend ... A: Adrien Sometimes the filter process can be a bit cumbersome to work with. I would suggest you ... | |
| protecting a cell | 1/16/2006 |
| Q: I am trying to protect just a handful of cells that have formulas in them. If possible I would like ... A: Kim You can protect the cells by using data validation and then protecting the data validation by ... | |
| Excel Auto sum.... | 1/13/2006 |
| Q: I have Excel 2002 and i have a workbook which has autofilter on. I select the whole column and use ... A: Alex Sounds like a formatting issue--You can format the cells that are a problem for you by ... | |
| vlookup alphabetical order | 1/12/2006 |
| Q: I wonder if you can help. The problem that I have is this. I have written a lookup formula that ... A: Chris There isn't a good alternative to the ordering of the lookup column in ascending order. The ... | |
| SQL and Excel | 1/7/2006 |
| Q: Roberts, I am an experienced VB and SQL programmer. I would like your help in Excel programming. Is ... A: Julia Sorry, the use of SQL in a vba macro is way beyond me. I would be surprised if it could not ... | |
| Cascading combo options/combo boxes | 1/4/2006 |
| Q: Is there a way producing lists or combo boxes in excel that cascade? i.e. choosing 'competitor' ... A: Julia Yes you can create list boxes that are dependent on your selection from other list boxes. I ... | |
| excell | 12/28/2005 |
| Q: How can i have one templet but the first line change all the time. I have 800 items that need to be ... A: ESPY I need a bit more information about your database you are accessing, and how it is formulated. ... | |
| chart transfer frm excel to word | 12/23/2005 |
| Q: I am writing from Russia. I have a P-3 and i am working on my PhD thesis. From my data i have ... A: Aseem I have to tell you that I'm not a real chart expert. I've not heard or seen of a situation ... | |
| Inovice | 12/17/2005 |
| Q: I am working in a bilingual environment(Arabic & English). Most of my work is related to sales, I ... A: Shaliq I'm not familiar with the way Arabic/kuwaiti dinars are stated, but how about this. Use a ... | |
| Appending Records | 12/14/2005 |
| Q: I am using MS Office XP I hv two questions (1) I need to import near about 100000 records from ... A: Parmesh Question 1--I'm sure it can be done, but I do not know the method to use- I suggest you ... | |
| Formulas | 12/8/2005 |
| Q: Followup To Question - I can do a basic spreadsheet but want to set up a sheet that will compare ... A: Lenora Ok column D should be % of difference between col B and col C. I assume you want this to be ... | |
| Formulas | 12/7/2005 |
| Q: I can do a basic spreadsheet but want to set up a sheet that will compare sales from last year to ... A: Lenora Glad that the answer helped. You get the #DIV/0! error message when there in a zero value ... | |
| Formulas | 12/6/2005 |
| Q: I can do a basic spreadsheet but want to set up a sheet that will compare sales from last year to ... A: Lenora You should be able to do the comparison sheet that you want. Here is what you need to do. ... | |
| UDF recalculation | 12/2/2005 |
| Q: I've created a UDF in Excel 2003 that takes the raw unformatted data in sheet2 and displays it in ... A: EJ Maybe to simple but how about automating the copy of UDF to sheet 1 via a macro and have it ... | |
| Excell job number spreadsheet | 12/1/2005 |
| Q: I need somebody to build a few formulas for my business job P.O. spreadsheet. My need is this. We ... A: Bryan I'll be glad to build your spreadsheet for you. I need a few additional paramaters. How ... | |
| Pivot Tables - Calc % using Sub-Total, not Grand Total as base | 11/29/2005 |
| Q: created using MS Excel 2000, that looks like this: Prod: Widgit ... A: Sandi I'm definatley not a pivot table expert. I can't see a way to accomplish what you want to ... | |
| calculation problem | 11/24/2005 |
| Q: I'm trying to create a spreadsheet to expedite job site takeoffs and associated costs with a ... A: Les I've a little problem understanding exactly what you want to do. Assigning hiden cost "within ... | |
| Date conversion | 11/21/2005 |
| Q: Hope that you can assist me on this small matter.. :) I would like to convert a set of numbers ... A: Edward It looks as though you want to type in dates without putting in the forward slash between ... | |
| Find worksheet in Excel | 11/17/2005 |
| Q: I would like to ask if there are a lot of worksheets (about 90) in the excel file, can I go to the ... A: Peggy I'm not sure what you know, so if I tell you something you already have knowledge of then I ... | |
| Linking cells between worksheets from Word. | 11/15/2005 |
| Q: I have a Word template that has several embedded Excel worksheets that I need to link cells from one ... A: Donna I'm not much help with this one, I seldom use linked excel sheets in word so I have very ... | |
| Regression Data Analysis function in a Macro | 11/12/2005 |
| Q: I am new in macro programming in excel. I would like to know, if it is possible, how to include ... A: Jose Sorry I didn't get back to you quicker, I've been out of town without computer. I won't be ... | |
| Counting time with Excel | 11/10/2005 |
| Q: I am trying to make a timesheet for my work in which I enter the starting time, ending time and make ... A: Working with time can be very tricky--I've used the folowing formula to calculate the differences in ... | |
| Excel 2003 - Compound Interest | 11/9/2005 |
| Q: I'd like Excel to compute the following: To invest $1,000 for 300 days at 2%. And would like ... A: Terry There are a couple of ways that you can do what you want. I assume you need a schedule that ... | |
| bold | 11/7/2005 |
| Q: I am working on a sheet with the page set up as portrait,black and white ,margins are okay, but when ... A: gdelmez Prolly not something that I can be of much help on. Ocassionally I will get the same type ... | |
| Mapping | 11/4/2005 |
| Q: I am usig MS MS Excel XP I have two extremely large files. They contain lists of company names from ... A: Parmesh Sounds like you need to find matches where the data doesn't match because of its ... | |
| Excel Worksheets | 11/2/2005 |
| Q: Microsoft Office Professional 2000 How do you Sum from separate worksheets in same workbook? ... A: Pam You can write a formula that looks like this: =SUM('week 1'!C6:C9)+SUM('week ... | |
| EXCEL 2002 formatting question | 10/30/2005 |
| Q: I am a volunteer working with "At Risk" elementary school children to improve student attendance and ... A: Dean Working with hours and minutes can be very tricky since part of what we are dealing with is in ... | |
| drop down list to filter worksheet | 10/28/2005 |
| Q: I have created a drop down list and wish to modify the below code to be able to select from the drop ... A: Darren Sorry I'm not a VBA expert, so I'm not sure how you would activate the drop down list with ... | |
| Daily Interest Calculation | 10/27/2005 |
| Q: I've got a friend who has lent money to his church to build a sanctuary. He did not lend them a huge ... A: Barry You can use the FVSCHEDULE()function to do your calculation. the earnings on each loan should ... | |
| Subtotal Lists | 10/26/2005 |
| Q: I am looking at using the Subtotal function for lists but rather than have for example columns A-C ... A: Julia I'm not sure that I'm reading you correctly--if as you say you want to have the brand and ... | |
| RELATING TO COMBO BOXES IN EXCEL | 10/25/2005 |
| Q: I have already set up two Data validation boxes which works perfect that is, in the first box I have ... A: Naresh I apologize if I am misreading the quesiton, but---with the data validation under the ... | |
| Excel 2003 - Changing Case | 10/24/2005 |
| Q: Once text is typed, is there any way to select all and change it to uppercase? In Word, there's a ... A: Vicki There isn't a real simple way to do the conversion as there is in word, but you can use the ... | |
| I've used Excel for many years,... | 10/23/2005 |
| Q: I've used Excel for many years, but only for basic things. I am trying to make a program to keep ... A: Sarah I don't know of a way of sorting that will sort all of the sheets simultaneously. It is ... | |
| My data has more than 65k rows, how to use pivot table? | 10/21/2005 |
| Q: 1) Office 97 on a Win98 OS. Running on 1.7Hz celeron. 128+256 RAM 2&3) I have been using Pivot table ... A: Mun Kit I'm not much help on this one, I've never run into the need to use more than 65k rows in a ... | |
| Excel -- Adding Cells from different worksheets together | 10/20/2005 |
| Q: MyHow do I add up cells from different worksheets together. Let's say, one cell in one worksheet ... A: Kevin You need to use a linking formula that looks like this: =Sheet1!A1+Sheet2!A1 The formula is ... | |
| excel | 10/18/2005 |
| Q: I would like to seperate the value of a cell which has been concatenated(combined)..for ... A: Kalifo I don't know of a way to insert the delimeter where you have an inconsistent number of ... | |
| Microsoft Excel | 10/17/2005 |
| Q: what i meant by subtracting the lowest two results is, add all of the cells from A to G, that would ... A: DaN Ok Dan now I think I understand--- This is the type of formula that you need ... | |
| Microsoft Excel | 10/15/2005 |
| Q: How would i add a row of numbers up and subtract the 2 lowest results? A: DaN I've been trying to answer your quesion for several days, but I haven't been able to get to the ... | |
| Financial Spreadsheet | 10/13/2005 |
| Q: I am a small sole propreitor and have one employee. Trying to develop a few excel spreadheets. ... A: Roomi Ok send me the file-- I can help you with some suggestions, but as you may note I limit my ... | |
| Entering algebra into excel formulas | 10/11/2005 |
| Q: If I used the commonly known formula P + P*r = Total I can't get this to work. Can you help? A: Chris I'm not sure what the P+P*r formula is, but maybe some hints as to why it won't work In the ... | |
| Excel 2003 | 10/10/2005 |
| Q: I work for an alternative school and I have to do quarterly reports involving number of weeks a ... A: Phylis I tried to answer your question earlier but couldn't get on the allexperts web site. In any ... | |
| find the values that make a sum | 10/9/2005 |
| Q: I want to find the values that make a sum in a range. Eg : values 7, 8, 9, 107, 108, 90. Sum I'm ... A: Korneel I'm sure that a formula can be contrived to calculate what two numbers, or more, combined ... | |
| Graphs | 10/7/2005 |
| Q: I have been working on a scatter plot with my grandson for school and have a couple of ... A: Ed I see this questions poped up again on my list, I'm sorry I thought I'd answered it, or rather ... | |
| Data Validation | 10/6/2005 |
| Q: I would like to know if there is a way to use data validation looking at another workbook. I know ... A: Kelly The data validation reference needs to refer to a group of cells in the same worksheet ... | |
| Remove "old" links in an excel file ??? | 10/5/2005 |
| Q: I have an excel file including several links (Edit->Links) that I want to remove. Can you give me a ... A: Rune I have an even older version of excel than you have, and I don't have a Break link function or ... | |
| Condition Formatting (more than three conditions) | 10/4/2005 |
| Q: Using a conditional formatting allows to add only three conditions. What to do, if you want to add ... A: Renate Using conditional as you say only allows three conditions in the same cell, what I have done ... | |
| Excel formula | 10/3/2005 |
| Q: Followup To Question - HELP! Hi In column O Row 8 of my sheet I could enter a number between 1 to ... A: Garry I may be a little closer to understanding--how about this-- I don't know if you want the ... | |
| Excel formula | 10/2/2005 |
| Q: HELP! Hi In column O Row 8 of my sheet I could enter a number between 1 to 500. In column P Row 8 I ... A: Garry Ok here goes"What would the formula be to place 1 in col D" Answer: +1"---and Sum in col ... | |
| Excel formula | 9/30/2005 |
| Q: HELP! Hi In column O Row 8 of my sheet I could enter a number between 1 to 500. In column P Row 8 I ... A: Garry We surely don't want you to go bald, but I'm having a bit of trouble trying to understand ... | |
| Quattro Pro 11 | 9/28/2005 |
| Q: I couldn't find any Experts for Quattro Pro 11 but thought maybe the Excel procedure might be ... A: Ron Its been many,many, many years since I used quatro pro, and unfortunatley I've forgotten ... | |
| Excel Menu Editor | 9/25/2005 |
| Q: I have a book on Using Excel Visual Basic for Applications. One of the chapters talks about ... A: jerome I'm definatly not A VBA expert, and my excel version is older than yours. I don't seem to ... | |
| Please help with an excel question. | 9/22/2005 |
| Q: How do you create an absolute cell reference to maintain the entire cell reference? The moving ... A: Ashlee To make a cell reference absolute you use the $ sign. for example: assume the cell ... | |
| Choice lists defining formulas | 9/21/2005 |
| Q: I want to make a spreedsheet in which I have a choice list in the A column, and I do math in the ... A: Keith One way to handle the problem is to create a list of choices and in the list use the choice ... | |
| Data Analysis Plus | 9/20/2005 |
| Q: my question is concerning how to enable the Data Analysis Plus function. I have excel 2003 and when ... A: Dan To use the Data Analysis tools do the following: 1 On the Tools menu, click Data Analysis. ... | |
| Put What is in Worsheet X A2 in This Cell - Lookup? | 9/16/2005 |
| Q: How do I have the student name in tab StudentList cell A2 appear in tab Attendance cell A2 ... A: TOM I'm not real clear on your question as to how your worksheets are formulated or wht criteria ... | |
| Sorting Data | 9/9/2005 |
| Q: I have a large dataset of monthly solar radiation values, which I need to sort by latitude in Excel ... A: Steve Yes excel will sort based on first number or letter in the sort column, so what we need to do ... | |
| Where is download kept | 9/6/2005 |
| Q: When I do a copy from a web site where is the data kept on my hd and can I view the data before I ... A: Max Short answer is I'm not sure why it's taking longer on your computer. Seems like its not an ... | |
| Where is download kept | 9/5/2005 |
| Q: When I do a copy from a web site where is the data kept on my hd and can I view the data before I ... A: Max A copy and a download are different. If it is a download it usually depends on your browser, ... | |
| removing links | 8/25/2005 |
| Q: I have a spreadsheet that has been past on to me, and it is linked to another workbook. I would ... A: Delores I assume if you want to remove the link, but you want to retain the values that are created ... | |
| Excel Formula | 8/24/2005 |
| Q: I have a column of 5 values. I would like to be able to use the LAST non-zero value in this column ... A: Tricia Try the following formula ... | |
| spreadsheets | 8/23/2005 |
| Q: i want to know all the basic steps to make a spreadsheet and also different types of spreadsheet.can ... A: Shradha As you learn how to work with Excel and learn the different formulas, etc. that can be used ... | |
| Windows on Task bar | 8/19/2005 |
| Q: Warm Greetings. When I use shared file of excel,all my excel sheet gets hidden.Then every time I ... A: Venkatesh I'm not much help, I tried to duplicate the problem and I cannot. Have you checked the ... | |
| Addressing '99999' values | 8/16/2005 |
| Q: My problem is that in the dataset, the author has used '99999' to denote a failed measurement, or an ... A: Steve I don't believe there is a way to tell the graph that you want to ignore the 99999 data, but ... | |
| Excel formula for percentages | 8/15/2005 |
| Q: I need a formula when working with two quarters, total amounts in a column, I need to know the ... A: Kim I'm not totally sure about your question so I'll make some assumptions. Assume you are talking ... | |
| Excel XP | 8/10/2005 |
| Q: I need a formula that will calculate and return a dollar amount for a series of numbers. Example: In ... A: Gail If I understand your question correctly you need a SUMIF formula such as the following: ... | |
| formula | 8/9/2005 |
| Q: I am using xp professional - I need to put a letter value in on column (A or B = 1 year, C = 3 ... A: Ruth I'm not sure what the training requirement are but here are a couple of formulas that may work ... | |
| Payback period | 8/3/2005 |
| Q: I want to calculate payback period in excel. Both Simple as well as discounted payback period. So ... A: Mona The best explanation I can give you is to tell you to look up NPER in the help section. It ... | |
| IF+ AND + MAX | 8/2/2005 |
| Q: It works. Please explain the following part: (E1-F1)<G1),E1-F1,G1) thanks MosheHi, Here is my ... A: Moshe I noted that in the ratings you gave me an 8 for clarity. I'm sorry, I did not know you ... | |
| excel - subtotals | 7/27/2005 |
| Q: Is there a way to take a worksheet that has subtotals and is compress to just show subtotals and ... A: Susan Yes you can copy/paste special/values the subtotals to another worksheet. The Subtotals will ... | |
| Exporting info to word doc | 7/22/2005 |
| Q: I use Excel 2003, in Windows XP Home Edition, for relatively simple invoices. I then send out a ... A: Peter Sorry I'm definitely not an expert in exporting to word, so I can't be of much help to you. ... | |
| WORKING WITH DOLLARS AND CENTS | 7/14/2005 |
| Q: I put together a spreadsheet to help me with my financials at work. However, it seems that when I ... A: Todd I'm not quite sure what your input is, but apparently the input is more decimals than you ... | |
| Currency calculation problem <> $ and £ | 7/13/2005 |
| Q: ' Premises: ' ' Column 5 / Row 3 contains the Starting Budget in US Dollars - The only ... A: John Sorry I'm not gonna be able to get to this for any amount of time for several days. With a ... | |
| linking Excel worksheets | 7/12/2005 |
| Q: I have an Excel file on a mapped drive (G) that I would like to have linked to a copy on my C drive, ... A: Jay I never use this feature, so can't be of much direct help. I suggest you reask the question of ... | |
| Calculating hours worked | 7/9/2005 |
| Q: I'm using excel 2000 and would like to know how to calculate the hours worked. Below are the fields ... A: TC The following formula should work for you in cell B6 ... | |
| formula - i can send an excel file | 7/6/2005 |
| Q: if you have an email address... i just wanted to match the columns A,B,C in each ws (AY-2q05 and ... A: Tim I'm not clear on what your match needs to be Do you want to match a cell in column A with a ... | |
| Excel Titles | 7/5/2005 |
| Q: Using Excel XP. I'm trying to find the way to insert text at top of 14 columns worksheet showing ... A: K. I'm having a bit of difficulty understanding exactly what configuration you are looking for. It ... | |
| Sum same cell across multiple worksheets | 7/1/2005 |
| Q: is there a simple way to auto sum the same cell across multiple worksheets? Answer - Troy I ... A: Troy Sorry, same answer as the first time, I just gave you the different workbooks example to show ... | |
| Sum same cell across multiple worksheets | 6/30/2005 |
| Q: is there a simple way to auto sum the same cell across multiple worksheets? A: Troy I wouldn't call it a "simple way", because the formula you construct has to make reference to ... | |
| Excel Array | 6/22/2005 |
| Q: Please help identify the correct array formula that would sum specific numbers in a range that meet ... A: Robert Not sure if this is the best answer, but since the array formula won't work very well with ... | |
| Macro | 6/21/2005 |
| Q: This one is somewhat difficult. I have two different workbooks. In first workbook I have 10 columns ... A: Pawan Sorry I have absolutely no experience with mapping so I won't be of much help. It appears as ... | |
| using sum in excel from previous sheet | 6/17/2005 |
| Q: I have numerical and text data on sheet one. On sheet two I wish to use the SUMPRODUCT FUNCTION ... A: GLEN Couple of suggestions. If you are correctly using the formula in sheet one, then just refer to ... | |
| Macro | 6/14/2005 |
| Q: I have some columns (say 10)in Excel spreadsheet. There will be many sheets like this. Few columns ... A: Pawan Depending on the criteria for selecting what columns to delete it is possible to select them ... | |
| Exporting to fixed-field text | 6/10/2005 |
| Q: Using Office 2003 with Windows XP In Lotus 123 I've been able to print data to a file and end up ... A: Doug I'm not sure I understand what is meant by a "fixed field file", but in any event I do very ... | |
| Moving the contents of a cell or a paragraph to another file(s). | 6/6/2005 |
| Q: Hello. I wish that you are doing well. I have the following question in Microsoft World or Excel. I ... A: Ali You can copy by the following steps. First it usually helps to have the document you want to ... | |
| short cut to a name | 6/3/2005 |
| Q: The request is to change Bill to B. (with "." after the B). MosheHi, I have a first name colomn ... A: Ok I understand, To add the "." after the B, which we have already created, do the following. (I'm ... | |
| goalseek | 5/29/2005 |
| Q: I use a macro which contains the goalseek facility, I would like the target value of the goalseek to ... A: Andy I don't believe goal seek will allow a cell reference in the "to value" box, so I don't think ... | |
| EXCEL TEST | 5/25/2005 |
| Q: I HAVE TO TAKE AN EXCEL TEST AND WORD TEST, WHAT ARE SOME OF THE QUESTION THAT MOST TEST ASK YOU ... A: Latasha I'm sorry I have no idea what type of questions will be asked. Excel can be very advanced ... | |
| Setting up a Spread Sheet in Excel | 5/24/2005 |
| Q: There are 5 people in my office who answer phones and then log the daily total into their own spread ... A: Vicki This should be a pretty easy application, however there are several ways that it can be done, ... | |
| Warehouse spread sheet | 5/22/2005 |
| Q: (USA) I'm looking for a spread sheet I can modify to my own needs. The comany I work for have too ... A: Mike Don't know of a spreadsheet that, already exists, that has all of the items that you need. ... | |
| Percentage Formatting | 5/20/2005 |
| Q: I'm trying to format a cell with percentage formatting so that when I enter a fraction of a percent, ... A: Jim Of course the reason that .22 comes out 22% when you enter it is because .22 is in fact twenty ... | |
| INDEX problem | 5/19/2005 |
| Q: Is there any way that I can define a range in an INDEX function based on the selection made in ... A: Emmaro1 I can't seem to understand the question. I don't believe you can use index the way you are ... | |
| ADDRESS of a range | 5/18/2005 |
| Q: hope you can assist: Can I use the ADDRESS function to define a range rather than a specific cell ... A: Emmar01 I'm not sure exactly what you are trying to do with the range, but it sounds as though you ... | |
| excel forms | 5/12/2005 |
| Q: How do I do an excel form for fill-ins? or a template from scratch A: Carol What you do is create the form or format that you want on the spreadsheet, and then save the ... | |
| Omit zero cells | 5/11/2005 |
| Q: All I want to do is omit a zero (0) cell. I am using the zero(0) as an input in another cell formula ... A: Dan Try the following formula: ... | |
| Cant save formula | 5/10/2005 |
| Q: I have 3 sheets in an XLS workbook. now sheet1 has information, sheet2 has information and sheet3 is ... A: Rob You need to use the copy/paste special/values command. First clic on the corner intersection ... | |
| I would like to do my accounting... | 5/5/2005 |
| Q: I would like to do my accounting on excel, When I will make deposit in my bank it should ... A: Joseph Yes its possible to do what you want with excel. You will need to tell excel what type of ... | |
| SEARCH Text within an IF loop | 5/4/2005 |
| Q: Richard, First off I use Excel 2002. I seem to be having a problem and I'm sure there's a simpler ... A: David I approached the solution a little differently, and I hope I understood the question. As I ... | |
| Deal with three dimension data | 5/3/2005 |
| Q: I have a data in excel. First tab: column lable is months from 1998 to current month, row lable is ... A: Hannah It looks to me like a couple of sorts can give you the information you want. First I would ... | |
| An impossible formula?! | 4/25/2005 |
| Q: I would like a formula that will: ...search for a single date (15/04/2004), which is located in cell ... A: Richard Try the following: +IF(LOOKUP(D2,A13:A80)=D2,"L0","L50") The first part of the formula ... | |
| Password | 4/20/2005 |
| Q: I am pulling information from linked files that are password protected. How do I get the ... A: Daryl I'm not real expert at this since I seldom use passwords, but I tried to recreate your ... | |
| Using Macros to transfer Information. | 4/19/2005 |
| Q: I'm trying to use a macro to copy information from a laid out form into a list format on another ... A: Mike There is a command that you can put into the macro that will tell it to go to the next blank ... | |
| excel | 4/17/2005 |
| Q: i have many questions ,my exam is after 2morrow and i do nt have a teacher so i would really ... A: Dina Most of your questions are answered directly in the help section and they are answered better ... | |
| Forms in Excel | 4/14/2005 |
| Q: I want to create a form in Excel that works like a template but I want to work outside the column ... A: Becky I'm not sure what ou need to do in working "outside the column limitations" so its kinda ... | |
| workbook closes when opening another workbook | 4/13/2005 |
| Q: i have excel 2000 and when i open a workbook then open another it closes my first workbook and opens ... A: Steve Are you sure that the first workbook is closing or is it being hidden by the opening of the ... | |
| Drop Down Menus | 4/11/2005 |
| Q: How do I make a drop down menu display information when you choose a selected object? Like, I have ... A: Jack Don't know that you can do it with the usual data validation drop down menus, I'd suggest you ... | |
| Excell formula | 4/5/2005 |
| Q: what formula can i use to accomplish that. A: Rob I can't tell from your question whether you need to simply copy the data from one worksheet to ... | |
| Excel startup prob. | 3/24/2005 |
| Q: Excel is opening a bunch of docs when excel is first opened, but most are not excel doc. It should ... A: Bob Sounds like maybe a macro is working to open the other docs, but I'm not sure. Check out the ... | |
| Excel | 3/21/2005 |
| Q: I work with excel in my job and we have windows 2000 Professional. I am fairly new to all of this ... A: Kathy My understanding from your question is--- The worksheets/workbooks you are trying to open have ... | |
| help | 3/19/2005 |
| Q: I have an Excel spred sheet that I want people to view for a limited time. I want to email it or ... A: STEVE I'm sure it can be done. I'm guessing with some macro code. Unfortunately I'm not expert in ... | |
| Rows & Columns re-size themselves in Excel 97 | 3/16/2005 |
| Q: Good day, I use Excel 97 to create financial worksheets. When next I open such a sheet, the rows and ... A: Joe I haven't had or heard of others having this problem. I can imagine what is causing the ... | |
| Current Exchange Rate | 3/15/2005 |
| Q: Is there any way to pull the current exchange rate from the internet into a cell? A: Tomos I do not know of a way, but that doesn't mean it can't be done. I suggest you reask the ... | |
| Excel report | 3/11/2005 |
| Q: I have created a worksheet which contains information on many companys, such as telephone number, ... A: Tom I don't really use checkboxes very much so I'm not really expert at answering this. However I ... | |
| Linking a range of cells to a different worksheet | 3/10/2005 |
| Q: I'm working with Excel 2002 and need some help. I have a workbook which contains 5 worksheets. ... A: Kim Let me suggest the following: First link the summary sheet to the individual sheets. If you ... | |
| Worksheet view | 3/9/2005 |
| Q: On a worksheet I seem to have brought up a gray area at the left hand edge with plus and minus signs ... A: John What you have in the gray area is the subtotal colapse keys. to get rid of it. Paint the ... | |
| accidental changes during multiple sheet selection | 3/8/2005 |
| Q: If you could help me I would be extremely grateful! I have created a database for my team to input ... A: Sarah Sorry I didn't get back to you sooner I was out of town yesterday. If people have to access ... | |
| protecting Cell | 3/3/2005 |
| Q: Richard, I would like to prevent changes to certain Cells, mostly where a formula exist. First, I ... A: Daniel sorry I didn't get back to you sooner, I was uot of town yesterday. It looks like you have ... | |
| Working with a huge list | 3/1/2005 |
| Q: I am facing a problem with a huge list in excel. To explain you the problem I will have to take ... A: Sanjay This isn't a real simple solution but--- I would use the LOOKUP function to determine if the ... | |
| Zero fill a cell | 2/28/2005 |
| Q: I am creating a file to export AP check data to our bank. I need to zero fill the cell and remove ... A: Tom I don't believe that any of the number conversions will do what you need, but depending on what ... | |
| Time Formatting | 2/24/2005 |
| Q: How do you format a cell so that if you type in a time, say 1330, the value in the cell is returned ... A: Jim As far as I know there is not a format that will allow you to type in the 1330 and get the ... | |
| Excel Numbering | 2/22/2005 |
| Q: Excel 2003 (i think) Dear Richard, I hope that you can help me! I am making a table in excel and i ... A: Junilla Yes there is an easier way for example In cell A1 put the number 1 make cell A1 the active ... | |
| Excel Centering | 2/17/2005 |
| Q: Is there a way to put into a cell with a formula to center it if it is text result (such as "N/A" if ... A: Mike I don't know of a way to do it with a formula. but I'd bet that it can be done with a Macro. ... | |
| Conditional formating | 2/10/2005 |
| Q: I have a sheet using say columns A through D and rows 1 through 6. Each cell in the Group may ... A: Jim Sorry I thought I'd answered your question, guess I didn't clic on the send button. anyway ... | |
| 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: Saif Sorry, I'm not much help with this one. I'm definately not a macro expert, and I've never ... | |
| Excel | 2/8/2005 |
| Q: I cannot remember how to change the formula to a number. I have weekly totals that I want the ... A: Michelle I'm not really sure what the question is. But let me try. Sounds like you have a total ... | |
| IF SUM VLookup Match | 2/7/2005 |
| Q: Hey Richard, This should be cake for you, but I am having a hard time with it. Spreadsheet goes ... A: Steve I'm gonna give you an answer not using VLOOKUP, cause I don't think thats the easiest way to ... | |
| Excel to Works | 2/3/2005 |
| Q: I have created a form, using Excel (Office 2000), then emailed the form to another employee who has ... A: Grant I think your answer, "instal Works on mine and develop the forms using Works", is the ... | |
| Finding lowest integer using a set criteria | 2/2/2005 |
| Q: I was curious if there was a way to find the lowest (or) highest integer in a data filed using a set ... A: Steve There are several ways that you might find the lowest interest rate. One would be as follows ... | |
| Get rid of an unwanted list on Excel | 2/1/2005 |
| Q: We have an Excel file (Excel 2001 for Macintosh) that we use as a schedule for our employees. But ... A: Carmen Converting the data into a list should not have changed the date format, so they might have ... | |
| summation in excel | 1/31/2005 |
| Q: If I have two random columns of numbers A and B. I determine the sum of A equal to some number N ... A: Troy I don't believe I fully understand the question, but I'd suggest that you check out the LOOKUP ... | |
| Record Keeping | 1/30/2005 |
| Q: I am a licensed acupuncturist and plan on giving the "paid online surveys" thing a whirl. If the ... A: Michael I would suggest you invest in a copy of Quickbooks software. This software will provide ... | |
| How to split an excell field | 1/25/2005 |
| Q: The excel practitioner in our company was supposed to enter the data in two different fields. But he ... A: Mehrdad Sounds like the simplest way would be to insert another column to the right of the column ... | |
| Excel Spreadsheet data change between 2 worksheets | 1/10/2005 |
| Q: I am using Microsoft Excel 2002 and I would like to join the items sold in a transaction file to the ... A: Barbara What you need to use in your worksheets is links between the two worksheets. You also need ... | |
| sorting in excel | 1/6/2005 |
| Q: I'm a pretty experienced Excel user but there's this one thing that's been bugging me: When sorting ... A: Dave The sort feature won't allow you to sort in B,A,C order, but what I do if I need this kind of ... | |
| Date computation in Excel to track transaction on day of month | 1/5/2005 |
| Q: I have to calculate a date on the fly for each month of the year, but need it to stop counting once ... A: CH I'm not sure what your data looks like so its a little difficult to give you a precise formula. ... | |
| sum based on two criteria | 1/4/2005 |
| Q: I have three columns: Employee Name,Area, and Sales I want to know how much "joe" sold in the East ... A: Ana I think you can do this with an if(and( array formula, but I can't get it to work, so i'll give ... | |
| Unique records count from multiple cells | 1/3/2005 |
| Q: Sir, Please help me with the following problem: ColA ColB abc 123 abc 123 bcd 234 bcd 345 ... A: Kishore I'm not sure what you mean by a "unique record" but if you are comparing columns for ... | |
| Lists | 1/2/2005 |
| Q: I am doing a piece of coursework and in my first year of sixth form. I am currently trying to ... A: Samuel Yes it is possible to automatically put in the account code. There are several ways to do ... | |
| Creating a profile | 12/29/2004 |
| Q: A. How can I split an statement in a cell. Exa. John Doh Any suggestion on a book or cd that is ... A: m. I don't understand what you mean by "split an statement in a cell" can you explain and I'll be ... | |
| IF+ AND + OR | 12/26/2004 |
| Q: Given - there are numbers in cells A1 - G1. I need to know how do you enter the following function: ... A: Moshe I usually work these types of problems out in steps, so I use several different formulas one ... | |
| custom format | 12/22/2004 |
| Q: I am trying to cahnge the cell font colour depending on it's value if the cell is entered with a ... A: Alan I believe you can do this with the conditional formatting feature, but you have to be kinda ... | |
| Macro? | 12/19/2004 |
| Q: Excel 2002 Trying to scrape various pieces of data from a chosen line in a booking sheet, across to ... A: Simon I may not be understanding the question, but it sounds like you need a simple link from one ... | |
| Excel limits | 12/16/2004 |
| Q: am having problems with excel cells not holding all the HTML i enter in there. ill explain.. I have ... A: Rob I don't know if this will help in your situation, but similar experiences I've had were fixed ... | |
| different printers | 12/14/2004 |
| Q: Richard I am using Excel 2000 I am having problems with different makes of printers and what they ... A: Eric Sorry I don't know of a code that will control the printers and limit or control the number of ... | |
| Advanced Adding | 12/13/2004 |
| Q: I know that when you input the following formula it will count all of the items that meet the ... A: Steven The sumproduct function is not really a count function but one that multiplies components of ... | |
| Format | 12/6/2004 |
| Q: Is there an instruction to color a number, for instance all 5's red? Verty Truly Yours A: Eugenio yes you can use the conditional formatting feature of excel. First paint the cell that you ... | |
| Comparing columns of data | 12/1/2004 |
| Q: I have eight columns of data where I'm comparing stock# and dollar value to the other columns. The ... A: Orlando Yes there are ways to shorten your three or four day comparison to three to four minutes. ... | |
| opening spresdsheets | 11/30/2004 |
| Q: Is it possible to open a spreadsheet work book on a specific worksheet every time you open it. Also ... A: Philip The workbook will open wherever it was last saved. I.E. if it was saved on sheet 1, with ... | |
| how to pass a formula down a column - NOT autofill (I think) | 11/25/2004 |
| Q: I fear what I want to do is entirely basic, yet I cannot find the answer anywhere. all my searching ... A: rd The autofile or copy/paste is the corect wqy to get the formula into the cells. The problem is ... | |
| IF, THEN wildcard in Excel | 11/23/2004 |
| Q: Perhaps you know the answer. I'm looking for the syntax to return a true value for any text in a ... A: Rich You can use the wildcard in the search function such as +SEARCH("*",A1,1) In this case if A1 ... | |
| Advanced Counting Formula In Excel | 11/19/2004 |
| Q: is there a way to nest a range in there. I.E. =COUNTIF(A:A,"BETWEEN 38292 AND 38296") If not do ... A: Steven Not sure what you are tring to do but you can use a formula something like this to calculate ... | |
| Sales Tax | 11/17/2004 |
| Q: I'm trying to do a simple tax rate spreadsheet for a small business who does not have a computer. ... A: Lila I assume that you need to print the tax schedule so that your client can refer to it when they ... | |
| IF THEN Formula | 11/15/2004 |
| Q: Does the following IF THEN Formula look correct to you because it is not generating the correct ... A: Christine The formula does not look correct. You are limited to 7 IF's in one formula. You only ... | |
| Excel to PDF Creates 3 files! WHY? | 11/12/2004 |
| Q: I have an Excel spreadsheet with 8 worksheet tabs at the bottom. When I try to print all the ... A: Mark I'm not much help on this, but I'm guessing that the problem is created by Acrobat not Excel. ... | |
| Auto Increment | 11/11/2004 |
| Q: I have one more. I've included the code from the macro to hopefully make this simple. In Excel ... A: Charles Here is a little bit of a different approach. First I create a quote number sheet whose ... | |
| Days in a Month | 11/7/2004 |
| Q: I would like to enter the name of a month in 1 column and get the resulting days for that month in ... A: Robert I'm not sure of what you are asking, but I'm assuming that you want to type in the month and ... | |
| Microsoft Excel 2002 | 11/5/2004 |
| Q: Help! I am trying to create a chart with cumulative totals - it is a daily sales report that has a ... A: Carolyn I'm terrible at charts, so I'm not a very good one to answer a chart question. ... | |
| Excel | 11/4/2004 |
| Q: I'm trying to make a cell for example: "A1" Change colors when I enter in diffrent numbers for ... A: Alma You need to use conditional formatting. Go to toolbar/format/conditional formatting. I think ... | |
| cant find the grid button | 11/2/2004 |
| Q: i have a really simple question, i have lost the grid button on my toolbar, the one you use to make ... A: June You should be able to reset the toolbar to its original configuration. Go to the help menu, ... | |
| excel shading | 11/1/2004 |
| Q: Sir, Do you know how I can program a cell to be shaded in red if the cell contains a number greater ... A: Todd You need to use the conditional formatting feature Pick the cell you want to format (make it ... | |
| Formatting page | 10/31/2004 |
| Q: Your rapid response yesterday was great! However, I was perhaps not exactly clear on what I am ... A: Paul Maybe I didn't make my answer clear. As an exercise let me have you do the following. Open a ... | |
| Formatting Page | 10/30/2004 |
| Q: I am using Excel 2000 pro. I would like to make the upper part of my page (row 1-15 and column A-G) ... A: Paul To size the rows, paint the rows that you want to size Clic on toolbar/format/row height Put ... | |
| Pointing to a worksheet | 10/29/2004 |
| Q: I'm trying to point and click on a cell and have it respond by taking me to another worksheet in the ... A: Jim You can do this by writing a macro that will go to the cell And then assigning the macro to a ... | |
| Rental Invoices | 10/27/2004 |
| Q: We have a rental business and our invoicing process needs to be updated. What we need is a ... A: Lana I'm not sure if the question is can you design me an entire spreadsheet, or how to solve the ... | |
| Clipboard | 10/25/2004 |
| Q: Everytime I copy innformation from one cell to another, I get an error message that reads, "cannot ... A: Paula That does sound annoying, I'm not gonna be much help, cause I haven't experienced it nor ... | |
| Time keeping sheet | 10/23/2004 |
| Q: I am trying to create a speadsheet on excel which will keep track of how many hours i work in a day. ... A: Dipak Ok here is what you do Column A=date Column B=time in Column C=time out Column ... | |
| Date Range in Cell | 10/22/2004 |
| Q: I have a cell in Excel 2000 that autopopulates the date when it is opened initially. Is there a way ... A: Charles The way I usually handle this is with a macro that copies the date from the initial cell ... | |
| =lookup function | 10/21/2004 |
| Q: ok, I have 2 tables of what is, for the most part, the same data. unfortunately, they're sorted ... A: Shaun I think the best thing would be for you to send me the spreadsheet and I can then better ... | |
| Cell Protection and COlors | 10/20/2004 |
| Q: I have two questions and wanted to see if you could help. #1 - When I protect a worksheet the ... A: Dan You're not gonna have much luck here #1 with the protection on if the contents are protected ... | |
| formula | 10/18/2004 |
| Q: Is it possible to count the amount of times any number occurs that is in a specific coloured font ... A: P In the count functionf excel cannot discern the font color as a criteria, however excel can use ... | |
| reference a text color | 10/17/2004 |
| Q: I am using Excel 2000 & have minimal knowledge of excel. I was trying to find out if you can ... A: Heath You can't write the formula such that it will use the text color as a criteria for summing, ... | |
| excel text formatting | 10/15/2004 |
| Q: One of my columns has the following text: 00011111234 These are text, not numbers. They represent a ... A: Richard Sounds like a perfect application for the text to columns feature of excel. Select the data ... | |
| doubt in excel | 10/14/2004 |
| Q: Hai I had pasted some values from the txt file to excel.Now what i need is i have to insert an ... A: Ramya If I correctly understand what you need want to do, here are two approachs: Excel has an ... | |
| IF in Excel | 10/13/2004 |
| Q: Richard, thanks for that. It has helped but I need to know how i convert the .111111 so it shows how ... A: Paul The rest is just math If 18 units equal a basket, and 9 baskets equal a stack, then 9 times ... | |
| IF in Excel | 10/12/2004 |
| Q: ------------------------- Richard, thanks for your reply. i will try to explain better. Lets say ... A: PAUL I'm not sure about some of the math in your question, i.e. 60012/18=3334, not 334, and if ... | |
| Delete Empty column | 10/8/2004 |
| Q: Hai I downloaded a txtfile and i import it into excel.It contains 3000 records with some blank ... A: Ramya You can delete an entire column by first selecting the column, then go to ... | |
| Date Data Entry | 10/7/2004 |
| Q: Any way to enter 6 digits and get excel to actually use the six digits to enter a DATE. Example ... A: JOHN You have to enter a slash or a hyphen, then excel assumes it is a date and will, depending on ... | |
| Dates in excel | 10/6/2004 |
| Q: Is it possible to make Excel insert today's date into a cell by simply double clicking on the cell ... A: Jacob This doesn't do the double clic that you mentioned but it will insert the date into a cell. ... | |
| Excel copy mass data | 10/4/2004 |
| Q: I would like to know what the easiest methods can copy mass data listing in horizontally to listing ... A: May To go from horizontal to vertical or vice versa you can use the paste special feature. Paint ... | |
| excel performance | 9/28/2004 |
| Q: I am looking to purchase a computer system that can handle massive, number-crunching Excel ... A: Kevin Excel does not use much memory compared with other programs. If you are getting an out of ... | |
| Mulit SUMIF | 9/27/2004 |
| Q: Richard, Working with Excel 2000. Have 3 Columns (Dept,Acct,Amount) Want to write an If Function ... A: RICHARD What you need is a formula that is a SUMIF(AND formula. Unfortunately it can't be writen ... | |
| MS Office 2002 - Excel Problems | 9/26/2004 |
| Q: I am not sure what I did wrong, but all I know is that Excel is the only part of Office on my ... A: Stephanie Sounds like somehow your properties of your excel icon are pointing to the frontpage ... | |
| Alarm | 9/23/2004 |
| Q: Is there any way in excel that if a cell does not do something by a certain date an alarm / pop-up ... A: Anthony One way I can think of of doing what you want is as follows: You have two conditions that ... | |
| Excel Macro for Print | 9/21/2004 |
| Q: I am using Excel 97 and I have an excel file with a button for print job. The problem is printer ... A: Philip I don't see anything wrong with the code, but try this code. ... | |
| Excel application that will generate the return of investment. | 9/16/2004 |
| Q: i am having some serious problems in tryin to construct a project that will generate the return of ... A: Anna Send me your e-mail address (we don't get the address through allexperts) and I'll send you a ... | |
| excel question | 9/15/2004 |
| Q: Just like to start off by saying thank you for your help. I am looking for a formula that will ... A: Stephen Sounds like you need to check out the IRR function, I believe it will get you what you ... | |
| Formatting cells in Excel for time | 9/13/2004 |
| Q: I hope you can help. I am working on a program in Excel. It actually is a billing program, but ... A: Barb Time is always tricky to work with becaue of the formatting etc. In your example of 6:41 Am ... | |
| VBA programming | 9/10/2004 |
| Q: I am using Microsoft Excel 2002. I am framiliar with some programming but I have run in to a brick ... A: Cameron I think you an solve it in a easier way by using sraightforward formulas As follows First ... | |
| Changing printer commands in Excel2000 | 9/9/2004 |
| Q: Richard I am using Excel2000 The printer I am using is permanently set up to print 2 A4 pages on to ... A: Eric I'm not a macro expert, but I believe that when you write the macro yu can go to page set up ... | |
| Spreadsheet Help | 9/7/2004 |
| Q: One of the things I do at my job is rekeying cores for locks. A lock is rekeyed using pin segments ... A: Tony I believe you can get to the answers you want using the small function. Here are the ... | |
| VLOOKUP | 8/26/2004 |
| Q: I know I am missing something obvious. In Excel version 9.0.2720: =VLOOKUP(H2,P2:Q11361,2,FALSE) ... A: Stefanie Your formula worked for me. I copied it directly from the text of your question to an ... | |
| Tab direction in excel | 8/25/2004 |
| Q: i've got a relatively basic excel worksheet i'm working on. The problem i'm having is that the ... A: Scott If you can use the enter key instead of the tab key excel has a built in way to make it move ... | |
| Cannot view embedded object in Excel 2003 | 8/12/2004 |
| Q: I have an Excel 2003 document with an embedded Visio Diagram. I can see it fine. If I look in print ... A: Paul No I haven't had the problem you are experiencing, but I don't deal very often with imbedded ... | |
| reorder level | 8/9/2004 |
| Q: I would like to create a simple inventory spreadsheet which will include a reorder level cell MS 98 A: Bertha Its not hard to do with excel, but I need to know some details of what you want your ... | |
| spliting addresses in 1st column | 7/31/2004 |
| Q: I need to take mailing addresses listed verticaly in the first column : Joes Apples 1227 N TUSTIN ... A: Kevin If your data is in three different cells I.E. A1, A2, A3, A4, then you can use the copy/paste ... | |
| re: splitting cells | 7/30/2004 |
| Q: Afternoon, Hope you can help. In Col.A, I have a list of store numbers followed by a dash followed ... A: Imtiaz You can use the text to columns feature. Go to toolbar/data/text to columns and follow the ... | |
| Run Excel macro from command line? | 7/30/2004 |
| Q: Hey Richard, We run a ton of automated processes via batch file and command line. We run a number ... A: Scott I don't know of any excel command line options that will do what you need, but I'm definately ... | |
| Calculate entire spreadshet | 7/29/2004 |
| Q: My question is: Is there a way to calculate automatically a given cell in every sheet, even when you ... A: Marc I don't know of a way to automatically add the calculation when you add another sheet. Maybe ... | |
| 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: Haythem If the cell is colored based on conditional formatting then you could use a formula that ... | |
| Excel/Query Parameter Issue | 7/22/2004 |
| Q: This isn't a cell formula. It is a data query. The problem is that the [Parameter1] global ... A: Ted Sorry-- I consider queries merely as query formulas that when entered incorrectly will not ... | |
| Running tally | 7/20/2004 |
| Q: I am working at a small construction warehouse for the summer and my boss would like me to develop ... A: James I'm not sure what you're worksheet look like but you can do what you want with a macro that ... | |
| can not open worksheet | 7/16/2004 |
| Q: About a week ago, after a power failure,I tried to re-open an Excel worksheet directly from "My ... A: Heather I've not experienced that problem before nor have I had any questions regarding the ... | |
| Excel spreadsheet Links | 7/15/2004 |
| Q: I have a spreadsheet with a "phantom" link, that is a link is indicating when you open spreadsheet, ... A: BILL Sorry--if there is no source file listed or no cell with a link in it that you can clear, I ... | |
| Excel spreadsheet Links | 7/14/2004 |
| Q: I have a spreadsheet with a "phantom" link, that is a link is indicating when you open spreadsheet, ... A: Bill If you go to the links edit list it will tell you the source of the link, the name of the ... | |
| How to get only one workbook from a multi-workbook spreadsheet into an e-mail as an attachment | 7/12/2004 |
| Q: I use WindowsXP -- Often I have a multi-workbook spreadsheets which contain date for internal use ... A: Rebecca Sounds like the easiest way would be for you to create a new worksheet for e-mailing, but ... | |
| Inserting worksheets | 7/9/2004 |
| Q: Roberts, Thank you for being with All Experts. My question is I have two excel workbooks. I want ... A: Nelson What you want to do is a copy paste operation, its just a little different since you are ... | |
| Excel Macros | 7/8/2004 |
| Q: I have a question with macros I am hoping you can clarify for me. I have created a Macro that I want ... A: Kevin I'm definately not macro man--however I'm pretty sure that you can run the macro in all of ... | |
| Applying a custom template to an existing document | 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: KEVIN Sorry I don't know of a way that you can accomplish what you want, but I would be surprised ... | |
| value in $Millions | 7/4/2004 |
| Q: Basically i am accountant working for a textile I design my financial statements in Ms Excell for ... A: Abdul I don't know of a way of formatting the worksheets to show only millions and fractions ... | |
| pivot table problems | 7/2/2004 |
| Q: I am having problems creating my pivot table. No matter how I manipulate the fields, I cant seem to ... A: Grace I'm really not very good with pivot tables. I believe you will get a better and quicker ... | |
| Copy excel formula | 6/29/2004 |
| Q: I have a column from f6 to f23 with the following figure say 570, 890, 900, 500, 620.....etc. I ... A: HM You could use the following formula: +F6&$H$6 The cell F6 contains 570 The cell H6 contains ... | |
| Excel Formula in using multiple file data | 6/27/2004 |
| Q: This is a recurring problem I have been having, but take the belwo example. I have two Excel files, ... A: Andrew I created the following formula, which I think duplicates the way your worksheets are set ... | |
| Multiplication / sum on parts of a number | 6/24/2004 |
| Q: Could you help me with a good solution to the following problem? In col.A there are bank account ... A: Ulf Unfortuantely since all of your conditions need to be tested before the calculation can be ... | |
| CountIf with Multiple Conditions | 6/23/2004 |
| Q: I've asked this question before, but can't seem to get an answer that works! Great if you can help ... A: Beth I don't know of a way to do it in one step, but you can do it in a two step process, for ... | |
| Delete old links | 6/22/2004 |
| Q: I cannot seem to be able to delete old links that are not valid anymore in Excel 2000. I only seem ... A: Stacy The links are usually contained in individual formulas and they have to be eliminated ... | |
| Lookup problem | 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: Chester I'm having a hard time reading the data and the results that you want. Question is the ... | |
| Cell History tracking | 6/16/2004 |
| Q: Richard, Is it possible to build a history spreadsheet of changes made to cell in a separate linked ... A: Dave Sorry, I just don't know if you can do what you want. I suspect that it can be done, but its ... | |
| Dates | 6/11/2004 |
| Q: I keep putting in 6-1 as I would want to put in for height but it changes it to the date is there a ... A: Jason If you format the cells as text it will accept the 6-1 and show it as 6-1 not as a date. To ... | |
| Excel error when changing tab name | 6/8/2004 |
| Q: My colleagues and I are getting an Excel error message I've never seen before. After changing a ... A: Paul Sorry to be just getting back to you. I put myself on vacation, as not accepting questions, ... | |
| excel | 6/7/2004 |
| Q: respected sir i am working in exchange co and i have the dollar amount in a1 cell and rate for ... A: Aman I understand that you wanted it all done in one row, and within three cells, however this is ... | |
| excel | 6/6/2004 |
| Q: respected sir i am working in exchange co and i have the dollar amount in a1 cell and rate for ... A: Amanullah the simplest way to handle the problem is to have three formulas the first in row 1 the ... | |
| macros | 6/4/2004 |
| Q: i do not know alot about exel but i know how to use it to a certain extend. i have imported some ... A: Sudha You do not need a macro to make our comparison, you can do it with a formula as follows ... | |
| "What if" operation | 6/3/2004 |
| Q: I have done a spreadsheet on salary increase proposal and need to perform a "what if" operation. It ... A: Nisa Check out the help on "What-if analysis". Your question poses a lot of different potential ... | |
| "Include" | 6/2/2004 |
| Q: My question is: I have a list of phone numbers in Excel (068-919122, 054-356411 etc.) I wish to ... A: Moshe The = or equals sign would be appropriate in place of include, however it would be simpler if ... | |
| Excel References | 5/25/2004 |
| Q: I've lost my ability to think clearly due to an abundance of college homework. Haha. I'm using ... A: Adam Looks like you just forgot to tell excel what to do if text wasn't present, so it puts in ... | |
| Removal of 'New Window' in Excel | 5/19/2004 |
| Q: In Excel you can add a New Window under the Window menu. I know I can Hide this new window if I ... A: Steve You can eliminate the window by making it active and then clicking on the x (top right hand ... | |
| macros | 5/17/2004 |
| Q: I have two macros developed for one worksheet I am not able to find a way to run them both at the ... A: Ron You can add one of the macro commands to the other and make one macro out of the two. You'll ... | |
| Hiding formulae from a worksheet | 5/12/2004 |
| Q: If I have a worksheet full of formulas and I am going to send this worksheet to others but I don't ... A: Peter Yes you can hide the formulas--the following is from help in excel: Hide and unhide formulas ... | |
| I have 4 different excel sheets... | 5/11/2004 |
| Q: I have 4 different excel sheets with names on them. I have to compare these 4 sheets with one ... A: Annie You can use the vlookup function to find the names that are matched on the various lists. ... | |
| Macro using relative references | 5/10/2004 |
| Q: What a great service! Here's my problem. I get a list of many reports on one excel worksheet on a ... A: Bob I believe a macro can be written to do exactly what you need and I believe that you are taking ... | |
| Writing a Macro in Excel | 5/6/2004 |
| Q: How would I write a macro in Excel to do the following? In a given column of numbers, I need to ... A: Carol Sorry if you didn't get my original answer. I answered on 5/6 but for some reason it didn't ... | |
| Link worries ... | 5/5/2004 |
| Q: I have taken over a new finance job where our models are a web of links. I have been looking for a ... A: Scott Books should be opened when you move data around, i.e. adding rows and lolumns, etc. then ... | |
| Insert rows formulas in protected worksheet | 4/30/2004 |
| Q: I am running Office 200 XP Pro. I ran into a problem when I tried to insert a new row in the ... A: Ronald I know of no formula or function (short of writing a macro) that will automatically insert ... | |
| autopopulate row if | 4/29/2004 |
| Q: I have a workbook with expense reports on each worksheet and what I am looking for is a formula that ... A: Leon I'd suggest you use a formula that will link the 37 worksheets with the over 300 worksheet if ... | |
| right way to set up certain type sheet | 4/27/2004 |
| Q: At work I have been asked to compare several types of products from several companies. I need to ... A: PK Usually a question asked generates more questions that I have. There are a lot of different ... | |
| Freezing cells | 4/26/2004 |
| Q: I have created a workbook that I am going to use as a data import utility. The first sheet of the ... A: lynne I don't know of a way to lock the individual cells, however two things usually work for me ... | |
| CONDITIONAL FORMAT | 4/24/2004 |
| Q: if i have data in a row, say cells A1 to A10, can i get the whole row to change colour if say cell ... A: Philip You should be able to do it with conditional formating and using the "formula is" instead of ... | |
| Master Worksheet | 4/23/2004 |
| Q: Word has a powerful feature called a master document which allows you to create a document and ... A: James I'm not familiar with the word feature that you are talking about, but Excel can link you to ... | |
| Excel 2002 | 4/21/2004 |
| Q: I have a spread sheet that lists the number of respondents to each survey question by age. The ages ... A: Ruth I do very little work with staistical functions which the FREQUENCY formula is, so I'm not ... | |
| Creating graphs | 4/20/2004 |
| Q: How do I create a graph using data from different worksheets A: Hermann The easiest way is--- Using the chart wizard, when the screen asks for the data range, clic ... | |
| Excel | 4/17/2004 |
| Q: Microsoft Excel for XP I have a master list on Excel, which contains hundreds of entries and I make ... A: Alex I don't know what your data looks like or what your criteria are for your smaller lists, but ... | |
| Excel - Cell color based on data | 4/16/2004 |
| Q: Can you tell me how to make a cell background change color based on the data or information entered ... A: Brian you can do the background color change with conditional formatting. go to ... | |
| tracking time | 4/9/2004 |
| Q: what is the formula to use if i want excel to keep track of my time in and time out total. so if i'm ... A: Billy The simplest way is to use regular numbering to input the time in and the time out and then ... | |
| vlookup | 4/7/2004 |
| Q: i have 2 separate excel files. (check register and checks) on my checks sheet i have a separate ... A: Steve I've read your question a bunch of times and I'm confused as to exactly what you want and how ... | |
| Modified date | 4/6/2004 |
| Q: Is there any way to apply a time stamp to a given cell based on when it was last modified? A: Steve I've done this with a macro that compares the cell to previous cell and inserts the date of ... | |
| Financial spreadsheet | 4/3/2004 |
| Q: Am consolidating monthly the total firm's financials. This was previosuly done as a straight data ... A: Diane Without knowing specifically wht your data looks like, I obviously can't write a formula or ... | |
| Searching a value in a matrix? | 4/1/2004 |
| Q: 1,I am using excel 2000. 2,what i am trying to do is given below. suppose below is a matrix having ... A: Nayyier There may be an easier way, but this is how I would do it. First use the match formula to ... | |
| changing a range of number formats | 3/29/2004 |
| Q: If I have a large group of numbers in Excel and I want to change whatever their format is, i.e. ... A: DANIELLE You can create another worksheet and transfer the numbers via formula to the second ... | |
| Macro Toolbox | 3/27/2004 |
| Q: I've been working on a problem for class and have experienced problems along the way. Last week, ... A: Judith The macro toolbar and the record button should only be reflected on the major toolbar if you ... | |
| if command | 3/26/2004 |
| Q: i need a simple formula for a glof score card spreedsheet cell 1 is par(4), cell 2 is score(6),cell ... A: Robert I'm a golfer also so I may relate to what you are trying to do,looks like you are trying to ... | |
| MS Excel 2000 | 3/25/2004 |
| Q: I would like to make some practice worksheets for my accouting class. I am currently stuck trying to ... A: Elizabeth The best way to think about it is to expand the cell above the columns rather than ... | |
| Automatic value cell change | 3/24/2004 |
| Q: I've this spreadsheet that is a catalog. I want for to change one word in sheet2 to another ... A: Armando Based on my understanding of the question you should be able to use the "replace" feature ... | |
| Array formula problem | 3/23/2004 |
| Q: I have an array formula to rank sales territories within their respective regions. The territories ... A: Bill The following may be the problem--this is straight out of the help Using an argument in an ... | |
| Formula | 3/21/2004 |
| Q: I am trying to create a formula that will give me a total based on criteria in two seperate columns. ... A: Stacy There may be a better way, but I would create a word from the two columns such as ... | |
| adding blank rows in excel | 3/18/2004 |
| Q: You were so helpful before - thank you - but now I have another question about MS Excel Office XP ... A: LORI You can do what you want with a macro that inserts a row between every row or every active ... | |
| excel spreadsheets for budgets | 3/18/2004 |
| Q: I need help in developing a format to track office expenses. Can you help me please? I just need a ... A: Latoya I use a format that tracks expenses as they occur by putting the expense in one column and ... | |
| Formula to Sort a list | 3/17/2004 |
| Q: First of all thanks for your time and help and I'll try and make this as painless as I can for you ... A: Marc I suggest that you separate the data into two columns (I.E. numbers on the first column and ... | |
| excel | 3/16/2004 |
| Q: I have a query result from an access database, dumped to excel, pat_id, age_at_exam . Now I want to ... A: Sara Its really difficult to tell you much without knowing exactly what your data looks like. ... | |
| Excel Conditional Formatting | 3/15/2004 |
| Q: I took a very basic class for excel and can get around pretty good, however I am having trouble with ... A: Adan You can use conditional formatting to accomplish what you want. Go to ... | |
| print area | 3/12/2004 |
| Q: I need help with what is probably a very basic macro. I want to print a sheet whose print area ... A: ALAN Sorry to get back to you so late. Yes you can do what you need with a basic macro, but ... | |
| Importing a worksheet into a word doc. | 3/11/2004 |
| Q: Someone informed me that there is another way to import, merge (or whatever the correct term is) an ... A: Sweet I'm prolly not an expert on this but they may be referring to linking the cells from excel to ... | |
| Cell will not calculate | 3/10/2004 |
| Q: Currently using excel 2000 Have visited MS site and loaded all updates. autocalc is on. Problem: ... A: Tom I haven't experienced the problem that you mention nor have I had any other questions along ... | |
| template wizard | 3/7/2004 |
| Q: You helped me last tnight in relation to the template wizard. Thanks for that. I'm now sorted with ... A: Alan I believe you would be better off creating your own Macro assuming you have that ability (go ... | |
| template wizard | 3/6/2004 |
| Q: I have used the template wizard to create a template with the cells i want being copied to a ... A: ALAN It helps greatly if you save your work in the folders/workbooks befor creating the links. Then ... | |
| excel lists | 3/4/2004 |
| Q: Firstly my appologies, the email address I gave (ozwalks@aol.com) on my question has a problem, so I ... A: STEVE Sounds like you have been working with another allexperts person since I don't recall ... | |
| formula | 3/1/2004 |
| Q: I am using Excel 2000 and cannot figure out the following formula: I want to type a part number ... A: DAN The formula looks like this: +VLOOKUP(A1,Sheet2!C2:D6,2) Where the part number you are ... | |
| labels from an excel database | 2/29/2004 |
| Q: This is a very simple question but I was wondering if you can make mailing label from an excel ... A: Laura Its easiest to print your mailing labels in Microsoft Word you can merge your list into Word ... | |
| Inventory | 2/27/2004 |
| Q: We use MS Excel 2002. We would like to have a simple inventory spreadsheet to track our consumables ... A: Larry There isn't a macro that will automatically create all of your criteria. You will have to ... | |
| xl calculations | 2/26/2004 |
| Q: How do you enter times in xl and then how do you subtract one time from another? ie 12:10 minus ... A: SHANE The time entry and subtraction issue is a bit of a problem and is best explained in the help. ... | |
| Copying only new items into an excel worksheet | 2/23/2004 |
| Q: I have copied an Excel worksheet on my clipboard, opened a new blank excel workbook, and pasted the ... A: Al Instead of the copy paste routine you can do a link from the new workbook to the old workbook. ... | |
| vlookup | 2/22/2004 |
| Q: You came up with this yesterday =IF(Sheet1!A1>0,Sheet1!B1,"") I created a cell in ... A: STEVE Couple of ways you can solve the problem First you could insert another column and use ... | |
| vlookup | 2/21/2004 |
| Q: What I would like to do is the following. I have a database of several thousand items on an excel ... A: Steve I'm having a hard time following what you are doing with the worksheets, so my response could ... | |
| Excel Project- Cost/Volume/Profit Analysis | 2/19/2004 |
| Q: I have Microsoft Excel 2002 and I am attempting to set-up a C/V/P analysis. The only area of the ... A: Lynne I'm not familir with the term "C/V/P analysis" can you tell me what it is. Also I'm not ... | |
| Unique data in a column | 2/17/2004 |
| Q: Using Office XP professional Excel I need to count the number of unique IDs in a column. The ... A: Lori I don't know of a way to do a COUNTIFUNIQUE formula, however with a couple of steps you can get ... | |
| lookup by selection of two or more fields | 2/13/2004 |
| Q: i would like to find a way where by selecting two fields will return one result: example table: ... A: Samir You can use data validation and drop down lists to make your selection of city and rate, then ... | |
| Negative 'parenthesis' | 2/12/2004 |
| Q: We cannot get negative numbers to auto' display in brackets - eq (33.00) instead of -33.00 Is this ... A: Brian Yes the display is a function of how the cell format is set. To change the format, paint the ... | |
| using AND function with SUMIF | 2/11/2004 |
| Q: Hoping you can help me. Looking for average sales per square foot for stores less than 6000 sq ft, ... A: Tim first thing that occurs to me is as follows use a count formula for f7:f86 as follows ... | |
| converting Mac to PC | 2/10/2004 |
| Q: I have received a disc with information on a Mac spreadsheet. I need to convert it to Excel on my ... A: Frank I haveen't had the experience of trying to open a Mac excel file, so I can't be much help. ... | |
| Updating Charts in Excel | 2/9/2004 |
| Q: Roberts: Thanks for your response. Here's some more info: The data source chart contains monthly ... A: Helen I've worked out some worksheets that will produce different charts on a rolling twelve month ... | |
| Updating Charts in Excel | 2/5/2004 |
| Q: Roberts: I'm using Excel 2000. Each month I add data to a spreadsheet to track our performance in ... A: Helen Sorry for the late response, but for some reason I just got notice of your question from ... | |
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
Answers by Expert:
- Nathan Head
- Chad Welch
- Philip Buckley
- Tushar Sakhalkar
- Bhaskar
- Amal
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bob Umlas
- Edward H. Mori
- Jessica L.
- Jan Karel Pieterse
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- Craig
- Adelaide carvalho
- Miguel Zapico
- JP
- Douglas M. Smith
- Richard Rost
- Ken Marron
- Victor Lan
- Bill
- Anne Troy
- Claire Blinman
Richard Roberts
Top Expert on this page
Expertise
Can assist you in most areas of Excel, have been working with it for about 15 years in many types of applications, but primarily in financial and accounting applications. I am a CPA and many client or client problems have necessitated the use of excel. I am not an expert in charting, macros, or pivot tables.
Experience
Have been working with Excel for about 15 years primarily in accounting and financial areas.
Education/Credentials
BA, CPA
©2009 About.com, a part of The New York Times Company. All rights reserved.