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