You are here:
| Subject | Date Asked |
| Excel Help | 2/8/2012 |
| Q: I have a short list of question for you. Hope you can clear my doubt. 1) Is it possible to ... A: Chan I am not sure what you mean by your first question. Second question--If you make your list ... | |
| military time spread sheet | 2/5/2012 |
| Q: I am trying to extract emergency department times to certain events--- ie admission to ... A: Laura Time is always tricky to work with because of the hours days, etc are not easy for us to ... | |
| Excel Problem | 2/4/2012 |
| Q: my first problem is n the excel sheet, if there is 2 in Column B3,8 in Column C3, 10 in Column D3, ... A: Pravin In your first question I am not sure if you want the numbers to be horizontal or verticle ... | |
| Excel timesheet question | 1/31/2012 |
| Q: Good morning; Where I work we use excel for our monthly schedule. We enter it in like so (Ex) ... A: Joseph You are correct, excel will recognize the 10:30-3:30 as text and won't calculate it as a ... | |
| creating a formula? | 1/27/2012 |
| Q: I would like to create a formula that takes the value on cell B1, deducts from cell B10 and gives me ... A: Zhesketh Check the data in cells B1 and B10 and in your formula cell. Excel is probably reading ... | |
| Entire number for percentage | 1/26/2012 |
| Q: I got a question for you that i spent years working on. Maybe you can help. Here it is, in my work ... A: Marc I tried the formula on several allocations of about 3000 units with orders of about 8000 with ... | |
| hyperlinks | 1/25/2012 |
| Q: I am trying to link a large excel workbook manaually rather than by individually going through the ... A: JON I do not work with hyperlinks much, so someone else might be able to give you a better answer. ... | |
| Entire number for percentage | 1/24/2012 |
| Q: I got a question for you that i spent years working on. Maybe you can help. Here it is, in my work ... A: Marc Not an easy answer to this problem, since it is difficult to make the numbers to the right of ... | |
| Adding cells form multiple worksheets | 1/23/2012 |
| Q: I would like to add the values of the same cell in 120 worksheets. It appears that the traditional ... A: Thom In excel 2007-2010 you are not limited to 30. I don't recall if there is a limit in prior ... | |
| Assigning a word to a number | 1/21/2012 |
| Q: I am attempting to assign a word to a value in excel. For example, when I enter the "001" into any ... A: Chris The formula should refer to another cell and would look like this =If(A1=001,"Lean Pro ... | |
| Excel Formula | 1/20/2012 |
| Q: I am trying to right a conditional formula that looks at a tiered billing schedule and returns a ... A: Chris Chris Assuming you have a cell you can look at to determine the number of items purchased-- ... | |
| EXCEL FORMULA | 1/17/2012 |
| Q: I have a little problem. I have a table with 2 columns, and I want a formula which will return the ... A: Julia There are a couple of answers depending on what your question is. I am a bit confused with ... | |
| Cell contents in Excel 2010 | 1/12/2012 |
| Q: I am entering the number 002556434E53 into a cell. It displays as 2.56E+59 which is not acceptable. ... A: Nancy The problem is that the "number" really isn't a number to excel because of two things it ... | |
| Incrementation of non last numbers in excel | 1/5/2012 |
| Q: I'm trying to do data entry involving real estate unit numbers. Each unit number looks like #01-187 ... A: Andy Sorry there isn't a built in way to denote by digit what you want to fill in a fill series. A ... | |
| entry in one sheet get entry in another sheet/book | 1/2/2012 |
| Q: HI, I HAVE TO CREAT CUSTOMERS MASTER LIST. THIS SHOULD BE CREATED FROM MANY DIFFERENT WORKBOOKS, ... A: NITIN It will be difficult to give you a specific answeer without knowing what your data looks ... | |
| excel query | 12/31/2011 |
| Q: Please tell me how to use isnumber and match function for multiple conditions. ... A: B. Sorry without having all of the data available, for example what the data in the sheets used and ... | |
| Using Excel for AR Ageing/ statement of Account? | 12/29/2011 |
| Q: My staff is currently using Manual AR Statement of Account and AR Ageing. I am thinking of coming up ... A: Chan Sorry the only part of your previous that had a question mark was as follows--- "If the above ... | |
| Using Excel for AR Ageing/ statement of Account? | 12/28/2011 |
| Q: My staff is currently using Manual AR Statement of Account and AR Ageing. I am thinking of coming up ... A: CHAN It will be relatively easy to classify the invoices by length of time outstanding. You need a ... | |
| Complex Charts | 12/21/2011 |
| Q: Please guide me on how to do this. I have Inventory, Turnover and Profit monthly figures for 2010 ... A: Yana I seldom use charts, so am not really expert in them. I suggest you reask the question of ... | |
| How to use sum formula to sum values between dates | 12/8/2011 |
| Q: Can you provide the formula to SUM the values between two different dates, i.e: Example for ... A: shrishaktiprashad With excel 2007 or later you can use the function COUNTIFS(). This function will ... | |
| Excel Random Numbers | 12/6/2011 |
| Q: I am using Office 2007 and trying to generate random percentages with 2 decimal places e.g. generate ... A: Joe Sorry to be late in responding I just saw your question-- I believe you will have to trick ... | |
| How to inset checkboxes in a drop down list | 12/5/2011 |
| Q: I am using excel 2007. I want to insert a drop down list in each cell of range K2:K90 but the list ... A: Neha Sorry I just saw your question-- I am not sure how to do what you want to do--I suggest you ... | |
| Match up price on another list | 12/2/2011 |
| Q: i m trying to calculate some business cost that i got price list from fedex, i need to get the ... A: cody You should be able to use a vlookup formula that might look something like this--- ... | |
| workbook working together | 12/1/2011 |
| Q: Here i am again, i need a formula about 3 workbooks working together. For example i have workbook1, ... A: Mark Edward You use the same type of VLOOKUP formula that I believe I gave you before, except your ... | |
| Loading Value | 11/30/2011 |
| Q: I want to ask my question with below example. -in A column student name -in B column Student age -in ... A: Eran You can use a VLOOKUP foremula to bring over the data from the data sheet to the userform. ... | |
| excel formula | 11/25/2011 |
| Q: Good Morning Sir, Can you help me please with my worksheet, i have a sheet that sums or i mean get ... A: Unfortunately you want the data in the inventory sheet to be in a different order than the date ... | |
| excel formula | 11/24/2011 |
| Q: Good Morning Sir, Can you help me please with my worksheet, i have a sheet that sums or i mean get ... A: MarkEdward I am not sure that I am understanding the problem correctly, but I will make a couple of ... | |
| Pivot charts | 11/21/2011 |
| Q: hope you are doing well. i need your help regarding pivot charts and tables. i have this excel file ... A: Nissar I am sorry-- I am really not expert in Pivot charts an tables. I may be able to answer your ... | |
| Excel formula | 11/18/2011 |
| Q: I need a formula that will determine the difference between a positive and negative number and ... A: Hey Ray I am sure your question is clear as can be to you but I am struggling a bit to understand ... | |
| Excel transfering data | 11/17/2011 |
| Q: I need to transfer data from one worksheet to another without getting an error value each time I ... A: Manuel I am guessing that you are using a copy to transfer the data. What this is doing is copying ... | |
| Make excel worksheets work together | 11/16/2011 |
| Q: Is there a way to make worksheets work together. I have a list of items and prices and a invoice ... A: Dylan Yes you can do this with a VLOOKUP() formula The formula might look like this ... | |
| exce/formula question | 11/14/2011 |
| Q: GOODDAY! May i know how can i make a formula that says (for example) if cell A1 is equal or less ... A: Mark Here is what your formula looks like. ... | |
| Formula question | 11/10/2011 |
| Q: I have a spreadsheet with columns for job number, code number, hours, and total amount. The total ... A: Jim You are welcome The ability to rate an expert is the choice of the expert, we can turn the ... | |
| Formula question | 11/9/2011 |
| Q: I have a spreadsheet with columns for job number, code number, hours, and total amount. The total ... A: Jim Usually my problem in answering questions is figuring out exactly what the question is, so If I ... | |
| Creating multiple worksheet from one file | 11/7/2011 |
| Q: I am in extreme need of VBA assistance. I am currently trying to create a macro that enables me ... A: Vish I am not a macro expert, so I cannot help you with a macro to do what you want. Having said ... | |
| File Problem | 10/27/2011 |
| Q: i have created an Excel file with form and coding. when i open that file and keep some time without ... A: ecsuraweera You can change the auto save feature to eliminate it altogether for this workbook or ... | |
| Calculate average in excel | 10/22/2011 |
| Q: for calculate average in excel when we have some undefined cells for example when we want to ... A: Sara The formula =AVERAGE(A1:A10) Will calculate the average for all of the cells that have data in ... | |
| Vlookup | 10/20/2011 |
| Q: I have two files, with data that I need to match a retrieve the value as a result of a vlookup. ... A: Alan Assuming that the same combination of material and variant numbers always equal the same Obj ... | |
| Vlookup | 10/19/2011 |
| Q: I have two files, with data that I need to match a retrieve the value as a result of a vlookup. ... A: Alan I need more information--I.E. what type of result are you looking for in c2, are you only ... | |
| Copying Formula from worksheet to new worksheet | 10/15/2011 |
| Q: I have two excel workbooks, 2010 and 2011, with 12 monthly tabs and a summary sheet. The summary ... A: Andy The best way to do it is the way you have suggested, by copying the existing file and renaming ... | |
| recognize date & time in VBA excel | 10/14/2011 |
| Q: Richard, Got a string as "October 10 2011 1 14 34 pm". Wanna recognize it as full date & time ... A: Dustin Your text string is not set up in such a way that excel can recognize it as a date and time. ... | |
| Turn time calculation | 10/11/2011 |
| Q: I want to calculate turn time,kindly check below mentioned points for the process, 1) Calculation ... A: Kannan First it seems to me that calculation time and turn time are the same. I am not going to ... | |
| excel | 10/9/2011 |
| Q: in Lotus 1-2-3 you can copy a range name without using the clipboard - you just go to where you want ... A: Kathy If I understand your question correctly, I do not know of a way to copy the range represented ... | |
| workout the number of shifts in a day | 10/7/2011 |
| Q: I am trying to work out the number of shifts in a day. I have our EOM date and EOW payment date and ... A: Nikki I am a bit confused you say you are trying to work out the number of shifts in a day, but the ... | |
| Excel | 10/5/2011 |
| Q: Sir, I have a query in excel. for e.g: I am using formulae in cells as follows. A1= ... A: Talha I am not sure what the question is, but the formula you have given me will yield a NUM# error ... | |
| Date Reminders | 10/4/2011 |
| Q: Is there a way that I can receive pop-up reminders (like Outlook Calendar) when a date in an Excel ... A: I am thinking that the easiest way would be to use conditional formatting and use the greater than ... | |
| CELL MODIFICATION DATE UPDATION IN DIFFERRENT LOCATION | 10/1/2011 |
| Q: SIR, WE NEED ONE FORMULA FOR CELL MODIFICATION DATE IN DIFFERENT LOCATION. EXAMPLE: IF I ENTERED ... A: POLARO there is a pretty good explanation of time/date stamping in the help section, try the ... | |
| Compare and pull out the data | 9/30/2011 |
| Q: Currently i am tired to do manual sorting,hope formula can help Please help me on these... H ... A: Rush A couple of suggetions might help. You can isolate the data you want with a formula, for ... | |
| Shared workbook, Macro's | 9/29/2011 |
| Q: Excel 2007 I've made a shared workbook and I would like to load the macro's of another workbook. ... A: TAMARA Sorry I am not a macro expert. I suggest you reask the question of another all experts ... | |
| Excel for consignment shop | 9/28/2011 |
| Q: I noticed a similar question was asked of you in 2006 and I'm hoping some new software options have ... A: Dina You can develop a spreadsheet on which you can keep track of the consignors, the items ... | |
| Vlookup Formula | 9/26/2011 |
| Q: I need to identify the Bonus amount from the Database through vlookup formula. Please help. A: Meenakshi I do not have enough specific information to answer your question. For the details of ... | |
| Remove spaces in cells after some text | 9/25/2011 |
| Q: How can we remove spaces in a cell after some text Ex: "Good Morning " should look "Good ... A: Hari Assuming you have a column of text that has spaces after the text that you want to leave. An ... | |
| how to set formula:choose sheet3 if sheet2 not exist | 9/23/2011 |
| Q: please help me: My answer should be in sheet1, The answer should be refer to sheet2 but if sheet2 ... A: Rashid The following should work for you. ... | |
| Excel 2007 | 9/19/2011 |
| Q: Suppose on sheet no2 I have 45 rows With client name with their 10 properties in different columns. ... A: Aman Usually the way I would handle this would be to create a code based on the options that have ... | |
| How can i reference cells in a particular worksheet depending on the Worksheet names | 9/17/2011 |
| Q: I have 12 sheets in my Excel with the sheet names as Jan'11 to Dec'11 and have the following datas ... A: SWAPNA The formula looks like this =JAN 11'!A1+'FEB 11'!A1+'MAR 11'!A1 of course I have ... | |
| finding the lowest/highest number in a row or column | 9/16/2011 |
| Q: I would like to find the highest or lowest number in a row or column and then use this number ... A: Brian The following will find the smallest or the largest number. to find the largest ... | |
| Balance | 9/15/2011 |
| Q: Sir, I want to ask that: If A2 = 1000, B2 = 1000, C2 = 1000, and D2 = 1000 And E2 = sum of A2 + B2 ... A: MUHAMMAD you have to determine which criteria should be first in order, because some of them are ... | |
| =COUNTIF question | 9/14/2011 |
| Q: I'm trying to utilize a formula to see how many times a specific number is used in a range of cells ... A: Jay Maybe this will work for you Use a formula that references a cell as the criteria. Then copy ... | |
| Excel | 9/9/2011 |
| Q: I have a list of items in rows. In the first column, I number each row. As I insert information in ... A: Gloria I am not exactly sure wht you are doing to fill the column, but here is a formula that will ... | |
| VBA coding!! | 9/8/2011 |
| Q: first of all, thanks for going through my queries.! I encounter a problem on vba coding. I would ... A: you Sorry I am not an expert in VBA coding. I suggest tyou reaskt he question of another ... | |
| Excel - working with half cent formulas | 9/7/2011 |
| Q: I have a formula in a cell for the IRS reimbursement rate for mileage which recently went up to ... A: Noreen When I tell you you are gonna say why didn't I think of that. You enter it as .555. If its ... | |
| How to use macro to fill a cell based on two drop-down selections | 8/25/2011 |
| Q: am a novice when it comes to macros and now finding it difficult to work with them. My question is ... A: SOURABH It does appear that you will need a macro to do what you are asking. Unfortunately I am ... | |
| Auto population of data in MS Excel 2007 | 8/24/2011 |
| Q: I have got a small problem to be solved in MS Excel 2007. I have a fixed content which includes ... A: Vicky Hopefully I am understanding what you need correctly. I will give you a suggestion as a way ... | |
| Please help me in simplifying a function | 8/19/2011 |
| Q: Please help me to write the below function shortly which will be understandable by excel i have 3 ... A: Abdul I do not knwo how your data in the two worksheets is set up, so it is a bit difficult ot give ... | |
| excel | 8/18/2011 |
| Q: how do i bring up a worksheet ? A: Peter With excel open, click on the top left office button then click on new then click on blank ... | |
| Issues using a sub | 8/17/2011 |
| Q: I am incredibly new to VBA (about a few hours) but I have some experience with other languages (C, ... A: Hebron I am def not a VBA expert. I suggest you reask the question of another and ck the resumes ... | |
| How to calculate total hours in different days for different employees? | 8/14/2011 |
| Q: Excel version: 2003.I have an excel sheet where there are many employees that worked different ... A: Sara Its a bit hard to give you a specific formula without knowing what your data looks like. You ... | |
| Counting Text | 8/13/2011 |
| Q: I am having a problem counting some text. I have single cells that contain either: ARH ARHH KW, ARH ... A: Michael I believe you can do what you want with a couple of countif formulas using wildcards, for ... | |
| Separating word from numbers | 8/12/2011 |
| Q: I need to separate words from numbers in one cell into two or more cells. I'm separating people's ... A: Stephen You should be able to do this with the text to columns feature in excel. First paint the ... | |
| Excel data sorting/filtering | 8/11/2011 |
| Q: and thank you for taking my question. I have huge database (10,000 or so rows) with about 20-30 ... A: Farhad You can use the filter feature to isolate the rows in the column that contain the key word. ... | |
| sumifs?? | 8/8/2011 |
| Q: I am not having good luck, you are the 2nd expert I am asking. I share expenses with someone who is ... A: Sheila Perhaps the reason your question was not answered satisfactorily was because it is really ... | |
| How to edit data returned from VLOOKUP and dropdown | 8/4/2011 |
| Q: Excel 2007 My question is a little complicated to explain. I will do my best: I am using Vlookup ... A: Jason I suggest that you put your lookup formula in another column (not column C) and then use ... | |
| to provide only write access for excel sheet | 8/3/2011 |
| Q: Good Day!! I have a excel file in out cental database which is used by 20 users. I want to give ... A: Sanjay I do not know of a way to protect cells from data being deleted while at the same time ... | |
| Max-If Statement with two Conditions | 8/1/2011 |
| Q: I want to find the maximum value for a range that is based on criteria on an adjoining column with ... A: Joe I'm not sure if this is exactly what you are asking but try this formula. ... | |
| adjust text wrap with row spacing | 7/31/2011 |
| Q: Sir, I have long working sheet i used text wrap in it and i inclreasd row height but when i ... A: Sandi You can format all of the cells to what is needed for the wrap text feature by the following ... | |
| conditional formula | 7/30/2011 |
| Q: I have a conditional formula that goes over the limit for an if statement. I believe an array ... A: Mike I can't tell from your formula exactly what you want the formula to do, but maybe this is it. ... | |
| wages formula | 7/27/2011 |
| Q: I have been working with excel for years, but this one has got me baffled. It is a wages calculation ... A: Frank Your formula should work fine, I don't see any real issues with it. You could use a few less ... | |
| wages formula | 7/26/2011 |
| Q: I have been working with excel for years, but this one has got me baffled. It is a wages calculation ... A: Frank I am not sure what is in cell A which is refered to in your formula so its is difficult to ... | |
| If Then Statement then Lookup? | 7/22/2011 |
| Q: Im trying to create a formula that looks at a specific cell and the fills in a range of values from ... A: Brian This formula will work for you. This formula is in cell A6 ... | |
| Excel 2010 | 7/18/2011 |
| Q: I've been working on Excel 2010 for a college class and every time I try to use the AutoSum button ... A: Britany Your cells that you are summing are most likely formatted as text, that would produce a 0. ... | |
| exporting | 7/13/2011 |
| Q: I have a program which lists the time including seconds. When I export the data to excel it does not ... A: JERRY This sounds as though it is just a matter of formatting. Try formatting the time cells using ... | |
| excel function prb | 7/12/2011 |
| Q: i m stucked in a problem here is the detail i have some names in cell A1 with data validations like ... A: Imran I am assuming that you are using a list to pick from for data validation purposes. As part ... | |
| Question on =SUM formula with Variables | 7/8/2011 |
| Q: I have the following Formula on a self-made Excel TIMECARD spreadsheet: On cell D2 I have the ... A: Rob The formula would look like this-- =IF(B2<80,+B2+C2,+A2+C2) The formula says If B2 is less ... | |
| Conditional Formatting | 7/6/2011 |
| Q: hope you are well. Here is my problem, I have two cells (A1 & A2) they both have two dates (5th ... A: Alex Yes you can use conditional formatting to change the cells format based on a condition such as ... | |
| Accounting system set up with Excel | 7/4/2011 |
| Q: Please, How do I set up an accounting system from the scratch with MS Excel. A: Louisa You may not know, but your question is very broad. The term "accounting system" can include ... | |
| CALCULATION OF RETIREMENT AGE | 6/23/2011 |
| Q: I AM WORKING IN MICROSOFT XP (EXCEL). I HAVE CREATED DATABASE OF ALL EMPLOYEES DATE OF BIRTH. NOW ... A: JAGANNATH B S Your formula should look like this =IF(DAY(B3)=1,EOMONTH(B3,719),EOMONTH(B3,720)) ... | |
| Excel formula | 6/22/2011 |
| Q: I am trying to create an Excel 2007 spreadsheet to track sick and vacation time. I need a formula ... A: D The formula is =IF(B11<80,0)+IF(AND(B11>79,B11<152),4)+IF(B11>151,8) The formula refers to ... | |
| Creating Simple Forms for Invoice Tracking | 6/20/2011 |
| Q: I will preface my question with a warning that I am beginner excel user, but I think what I'm trying ... A: Ben What you want to do is not difficult, but--- There are a couple of issues that are slightly ... | |
| autofill multiple worksheets | 6/17/2011 |
| Q: I have a workbook containing in excess of 50 worksheets with 1 of the sheets being a master. On the ... A: Chris "When removing the = sign, the fill function advanced to the next cell within the sheet, not ... | |
| autofill multiple worksheets | 6/16/2011 |
| Q: I have a workbook containing in excess of 50 worksheets with 1 of the sheets being a master. On the ... A: Chris If I am correctly understanding the question, I believe you can handle it this way in your ... | |
| Missing Number | 6/14/2011 |
| Q: Greetings! I need a help. In the Column "A", i have a list of receipt numbers. I want to know, what ... A: Meenakshi I may not full understand the quesion or how your data is arranged, but I will try. ... | |
| Excel | 6/10/2011 |
| Q: is there a way to do "if" conditional formatting? In other words, I have several rows of items. If ... A: Joelle Yes you can use an if formula in the conditional formatting. For example in cell B1 go to ... | |
| If then statements with columns | 6/1/2011 |
| Q: I would like to list numbers in two separate columns. Then looking at an entered value in another ... A: Don If I am following your problem correctly, you need to use a VLOOKUP formula The formula might ... | |
| Excel doubt | 5/31/2011 |
| Q: my question is very basic one. To add many lines in single cell in excel , we use ALT+ Enter . e.g ... A: Viji I don't know of a way to put the line in the middle of a cell unless you use the underline ... | |
| IFFormula | 5/30/2011 |
| Q: My friend and I have a weight competition going on and I'm trying to create our spreadsheet. We ... A: Trisha I will make some assumptions and give you a formula based on those assumptions Assume ... | |
| Excel math | 5/28/2011 |
| Q: Is there a way to use Excel for weighted averages? I can't find an icon for such and I have never ... A: JOE I don't know of a function for weighted average but it is relatively simple to callculate. All ... | |
| Excel | 5/26/2011 |
| Q: I have a inventory report with a list of different part number and a total qty, on the other hand, I ... A: Kenso The VLOOKUP formula will tell you how many you have on hand. I am assuming that your ... | |
| Excel | 5/20/2011 |
| Q: I have a inventory report with a list of different part number and a total qty, on the other hand, I ... A: Kenso You can use a VLOOKUP formula to find the item on your sales order in your inventory list. ... | |
| Hyperlinking in the same workbook in excel | 5/19/2011 |
| Q: How do you hyperlink a single cell on a worksheet to access another whole worksheet in the same ... A: Cindy Can't quite tell from your question if you want the entire worksheet to appear or if you want ... | |
| change the data refresh options to optimize file size | 5/17/2011 |
| Q: how can I change the data refresh options to optimize file size (when I have a connection to other ... A: Clarkson This may be what you are looking for From excel help, otherwise I don't hae any other ... | |
| Excel 2007 Question | 5/16/2011 |
| Q: I am trying to find the earliest date from a list of data that is both numbers and dates. Example ... A: James The simplest way to find the lowest date is to do two sorts of the data, first a sort of the ... | |
| Excel locked cells | 5/13/2011 |
| Q: I am using Excel 2003 on a Vista PC I have a sheet with certain data that has to be entered on a ... A: Jim You can protect the sheet from entry. First, with the workbook open, go to sheet or tab that ... | |
| Cash flow chart | 5/12/2011 |
| Q: Mr. Roberts, I hope you can help me out with this seemingly simple problem: I just want to create a ... A: Mikkel Sorry I am definatly not a chart expert. I seldom create charts unless my children need one ... | |
| Time card in Excel | 5/11/2011 |
| Q: i am trying to create a time card in Excel. So far I have : Colum A time in, Column B Time out to ... A: Helen I don't understand why you need to know 7 hours minus the total hours worked, it seems to me ... | |
| Calculate working hours | 5/9/2011 |
| Q: i have made a excel sheet format to calculate my duty as given below E5: Book Departure(this is the ... A: Deep As I mentioned the format of the cell and the entering of the data is vital to the correct ... | |
| Calculate working hours | 5/8/2011 |
| Q: i have made a excel sheet format to calculate my duty as given below E5: Book Departure(this is the ... A: Deep One of the most important things when you are dealing with time and the time crosses from one ... | |
| Formatting Time on imported data | 5/6/2011 |
| Q: At work I receive an Excel document, and in it is a column of about 6000 time entries, they are ... A: Melanie I cannot duplicate the problem but I suspect that the cells are text, not number formating. ... | |
| Excel | 5/5/2011 |
| Q: if a cell in Excel contains the word "Drill" or "Exercise" I want it to count and add "1" to ... A: You can use a formula such as this =IF(Sheet1!A1="fitness",1,"") In this example if the cell A1 in ... | |
| Dsum() to pick criteria on cell value change | 5/3/2011 |
| Q: I have a work sheet that is used for a financial year data calculation. I have a set of rows that I ... A: Krishna I have to say I do not fully understand wht you are trying to do, but you can use a cell ... | |
| Format cell | 4/18/2011 |
| Q: Good Day I know that this formula =LEFT(A1,LEN(A1)-2) will remove the last 2 letters of the a word ... A: Joshua The formula refers to another cell other than that in which the formula resides. So if you ... | |
| csv files | 4/14/2011 |
| Q: When opening a tab separated file in Excel2007 I get all data in one column. I will have to go ... A: Leif I really do not know if there is an automatic conveerter. I believe that the issue relates to ... | |
| Sum Total Of Different sheets in a workbook | 4/13/2011 |
| Q: Richard, How can i sum up total amount in different sheet in the sme workbook. What i mean is this : ... A: Amonia You can use a formula like this-- This assumes that you have already created sums in each ... | |
| Currency | 4/12/2011 |
| Q: i have a huge issue, maybe a little issue for you, can you help with the following please x column ... A: Maria There is a formula that can tell you what format is being used in a cell. That formula is ... | |
| Changing a formula based on a cell value | 4/11/2011 |
| Q: So I have a formula =IFERROR(INDEX(Yr1!E:E,MATCH(A1,Yr1!A:A,0),1),"na") basically it looks up a ... A: Daniel I assume you are the same Daniel who's quesiton I answered last night, you are welcome, but ... | |
| search for a value then display the value x cells to the right of it. | 4/10/2011 |
| Q: I was wondering if there is anyway to lookup a number then find it in another sheet (in the same ... A: Daniel Yes you can do what you want. First ---do your first lookup, Then reference that result in ... | |
| Converting Excel to CSV | 4/7/2011 |
| Q: I have numbers in two columns. A1 - 1000, B1 - 101.1 A2 - 10001, B2 - 100.01 I used concatenate ... A: Abhishek I can't get the concatenate formula =concatenate(A2,B2)to produce 1,000,101.1 Where A2 ... | |
| return value of the index of column | 4/6/2011 |
| Q: Cell A2:A21 =RANDBETWEEN(10,27), CELL B2:P2 = A,B,C....O respectively, cells B2:O21 ... A: SAHIL I noted that you say cell B2 will contain A and you also say Cell B2 will contain the ... | |
| Conditional formating | 4/2/2011 |
| Q: I need to do a conditional format in a cell, this is what i need. values are scored from 1= red 2= ... A: Andre I am a bit confused with what you are trying to do. I think you have three conditions If the ... | |
| Data Validation - month | 3/28/2011 |
| Q: In column A, I will input date (eg 2011/12/31). In column B, I will input the month I want (eg 31) ... A: clarkson To set up this data validation make the A1 cell active go to ... | |
| personal financial sheet | 3/26/2011 |
| Q: Is there a excel template that I can manage my personal houshold expenses that I can do a pie chart ... A: Patsy Check out this offering I believe it does what you want to do. ... | |
| Automating Data Placement | 3/24/2011 |
| Q: I am trying to prepare data to export into an access database from an excel spreadsheet. I have ... A: Dawn I am prolly not totally understanding the queston, but it sounds like you may be able to use a ... | |
| removing duplicates from excel sheet | 3/23/2011 |
| Q: I read your answer to Renee and tried to follow. However, the cell range given was weird...it wasn't ... A: Judy Sorry I don't remember an answer to Renee and I couldn't find a question from her. So I am a ... | |
| EXCEL FORMULA - NEED HELP!! | 3/22/2011 |
| Q: I have 2 columns in excel, one being balance and the other result. I want the result column to come ... A: Tom A formula such as this will work. =IF(A1>0,"CR","DR") The formula says If cell A1 is greater ... | |
| Find and Replace | 3/21/2011 |
| Q: My question is: occurance of * (asterics) in a cell must begin in a new line within that cell. ... A: Kaiwalya Here is a simple way that I think will work for you. First use the text to columns ... | |
| Sorting content of columns based on check boxes | 3/18/2011 |
| Q: I am trying to create a sheet in excel that will create a random exam paper from a bank of ... A: Jenni You can approach this in a couple of ways 1-- you could use the data/filter/autofilter/ and ... | |
| copy diff range in diff sheets based on cell value | 3/16/2011 |
| Q: May I request your help on below scenerio for excel07 Thanks in advance and with best regards. Sl ... A: Vilas Sorry to be slow with my reply, I did not see your question. What you want can be done with ... | |
| Excel Conditional Formatting (Date Format) | 3/8/2011 |
| Q: I am using Microsoft Excel 2007. I am trying to figure out how to set a conditional format on ... A: Tovey You can do the conditional formatting in cell B1 with the condition being Cell value is ... | |
| Auto sum giving 0 answer | 3/7/2011 |
| Q: We are using excel for statistical purposes and use the same template with its formulas every month ... A: Marile I do not know what might be causing this other than the things you have already checked, but ... | |
| comparing columns on different sheets of workbook in Excel 2007 | 3/6/2011 |
| Q: I maintain a workbook to help me select golf teams from a list of those available for approximately ... A: Ron Being a golfer myself I always like to help out with golf questions. If I am correctly ... | |
| value plus percentage | 3/4/2011 |
| Q: I have a value in A1 (in Rands)and want to add it to 12% in cell B1. How do I go about this? A: Krystle From your question I cannot tell if you want to add 12% of the value in A1 or 12% of some ... | |
| comparing two colums | 3/3/2011 |
| Q: I'd like to ask you a question about comparing two columns. I have a situation where I have one ... A: Sasa You can use the countif formula, something like this =COUNTIF(A$1:A$6000,B1) Where B1 holds ... | |
| Formula | 3/2/2011 |
| Q: I have a a form that includes options for "comply" and "do not comply". I extracted the "do not ... A: JENNIFER I cannot read the image that you included with your question so I can't be specific with ... | |
| HTML code can not delete | 2/28/2011 |
| Q: You answered my question the other day about updating links across workbooks. The answer was "Both ... A: Andy Sorry, If you cannot delete using the normal delete, I do not have another idea of how to do ... | |
| 2 find repeted numbers at 2 defrents sheets | 2/26/2011 |
| Q: i have series of numbers in cell A1 TILL A200 sheet1 & A1 TILL A200 Sheet2 the same file i want to ... A: ashrafyassen You can use a countif formula to count the number of occurences. The formula might ... | |
| Adding cells in a linked worksheet maintaining original link | 2/25/2011 |
| Q: I am using Office2003. I have two workbooks. 'Prices' contains original prices. 'Tours' contains ... A: Andy I am not sure about your question--if you need to add a column as you say, the cell ... | |
| Hyperlink with Vlookup | 2/24/2011 |
| Q: Can I use hyperlink function with vlookup? i.e. column A Column B 1 a 2 ... A: HANIF I am a bit confused with your question, In general yes you can use the hyperlink, but it ... | |
| Question reg range function | 2/23/2011 |
| Q: How to use range function to select specified number of columns ...Suppose i want to apply range ... A: Gaurav I am not exactly sure what your question is, but I will give it a try. You first have to ... | |
| Converting Figures to Words inExcel | 2/21/2011 |
| Q: How to Convert figures to words in Excel by using formulas A: Sumeer Attached is a link to microsoft office that discusses numbers to text conversion. ... | |
| adding th results of multiple formulas | 2/20/2011 |
| Q: I have a weekly attendance sheet for my students. absences are tallied up by excel using the formula ... A: Haneef If I am reading your question correctly, you can use a COUNTIF formula within an IF formula. ... | |
| Counting Items | 2/19/2011 |
| Q: Hey Richard, I have a question which I am sure is very basic in excel, and I am sure I could look it ... A: MIKE You can solve it with a sumif formula. The formula is similar to the countif formula except ... | |
| Excel Date Formats | 2/18/2011 |
| Q: I found a question to you from 2-17-2009 regarding finding the "average" date that something occurs. ... A: KELLEY One way I can think of would be to separate the dates using text to columns and eliminate ... | |
| counting cells | 2/16/2011 |
| Q: I have column A with 7000 rows. The numbers in the column are repeating. I want to count the number ... A: Kiril The simplest way I can think of would be to filtere the list for unique records and then use ... | |
| Excel Gridlines | 2/15/2011 |
| Q: I have Excel 2007 and I noticed about a week ago that there are no gridlines on any of my Excel ... A: Steve I don't know what could be causing that except for the items that you have already checked. ... | |
| conditional copy-paste-delete | 2/14/2011 |
| Q: your help on excel 2007 pls... If sheet1!a1=value v1,copy sheet2!range a1:d3 into sheet3!range ... A: Vilas I believe you need to handle your issue with a Macro, and unfortunately I am not a Macro ... | |
| Pulling data from several closed workbooks | 2/12/2011 |
| Q: So I have several shared, very large workbooks at work. I've come up with an analogy that will ... A: DTT If I am understanding correctly, I believe you can get what you need by using an IF() formula ... | |
| Inventory item codes | 2/9/2011 |
| Q: Using Excel version 2007 Right now our inventory item codes in Quickbooks are a hodge podge. I ... A: Jeff I think the simplest way to handle the problem would be to create divisions of the item code ... | |
| Need your favour plz. | 2/8/2011 |
| Q: Please guide me in this regard. I think it is possible in excell 2007, coze we can use 64 ifs in ... A: Ali In these situations I try to work out a series of formulas (instead of nested IF formulas) that ... | |
| GPA | 2/6/2011 |
| Q: I've been trying to figure out how to convert a percentage to a GPA based on a chart I was given. I ... A: Polo I would use the chart and apply a VLOOKUP formula to look up the GPA based on your percentage. ... | |
| about a function | 2/5/2011 |
| Q: We have more than 90 vehicles which rotate on daily basic from one place to another. I enter the ... A: bwaqasd You can use an IF formula to transfer the data over to the individual vehicle sheet when ... | |
| Excel Military Time | 2/2/2011 |
| Q: I am desperately trying to format a an excel sheet of posts for a hootsuite account. They require ... A: Simon If you have a cell that is formatted as MM/DD/YY HH:MM AM (which is what I assume you have) ... | |
| Excel Military Time | 2/1/2011 |
| Q: I am desperately trying to format a an excel sheet of posts for a hootsuite account. They require ... A: Simon I am not sure what formatting you need excel to show--I checked out the definition of ... | |
| text name of maximum value | 1/31/2011 |
| Q: I have Excel 2007, and need a cell formula that will print the name of the column with maximum ... A: PAUL There may be a better way using the index function, but a quick and easy way would be this ... | |
| Excel | 1/29/2011 |
| Q: I want to change the colour of a cell depending on the data input. I don't want to use conditional ... A: Matt In your example you give three conditions that you want to be met for the formatting to be ... | |
| excel | 1/27/2011 |
| Q: I have multiple worksheets in one workbook that I'd like to link. When I delete an item from a ... A: Gina Of course if you delete the data without deleting the cell in the main data list an error ... | |
| button to run formula result | 1/26/2011 |
| Q: i have a spreadsheet with 3 different fields Field 1 has the persons 1st name Field 2 has the ... A: Marcus The formula calculations should be immediate and automatic without hitting return. This is ... | |
| Excel doubt-Reg. | 1/25/2011 |
| Q: I have problem in excel in preparation of MIS reports in worksheets. i am calculate no. of days b/w ... A: Hari I am not sure I am understanding the question but based on my understanding, you can use a ... | |
| need a formula.. | 1/24/2011 |
| Q: I need your help. I create a database of different vehicles in an excel sheet. We have about 100 ... A: B. You can use an IF formula to bring over only the data pertinent to the particular cars ... | |
| Randomisation | 1/23/2011 |
| Q: i have a spreadsheet with 3 different fields Field 1 has the persons 1st name Field 2 has the ... A: Marcus You can use a vlookup formula to lookup the 2nd and 3rd field that relates to the randomly ... | |
| countif and if statements | 1/21/2011 |
| Q: Iam working to prepare a attendance excel where Iam trying to input formulas with "countif" ... A: Uma If you send me a copy of what you have done, with some more explanation of what you are trying ... | |
| excel | 1/20/2011 |
| Q: I have a spreadsheet in excel 2003 - it has various worksheets. All apart from 1 workshhet has drop ... A: Deb You can use a formula like this. ... | |
| Calculating times in excel 2007 | 1/19/2011 |
| Q: i am trying to get excel to add up times for a working week, every time the number of hours exceeds ... A: KEVIN With time calcualtions it is usually all about the formatting. Check out this short article ... | |
| How to Compare Two Columns | 1/13/2011 |
| Q: Please tell me how can I compare figures in two tables (Table A & B)as given in the below example ... A: Dilshad First I would copy the names of the fruits from one of the sheets to the sheet named table ... | |
| Cummulative Tiered Bonus Structure | 1/11/2011 |
| Q: I've spend the better part of 8 hours trying to figure this out with no luck. Here's what I'm trying ... A: David I couldn't read your excel sheet you transmitted so I couldn't tell what cells contained the ... | |
| 10ths in Excel | 1/6/2011 |
| Q: I am working on a shift calculation for employees. Currently I have this formula ... A: Heidi Something must be going on with your formula or the way you have input the data. I tried the ... | |
| Excel 2000 help? | 1/5/2011 |
| Q: I made an Excel 2000 program that calculates interest and principal on a loan with irregular ... A: Richard You can use a regular subtraction formula to calculate the days based on 365. +A14-A13 ... | |
| 10ths in Excel | 1/4/2011 |
| Q: I am working on a shift calculation for employees. Currently I have this formula ... A: Heidi Assuming that your formula works except for the rounding issue, then applying the ROUNDUP ... | |
| linking multiple cells to a master spreadsheet | 1/3/2011 |
| Q: I am trying to figure out how to link multiple cells in one Excel spreadsheet to a "Master" ... A: Katy Yes it is possible to link the cells and it is fairly easy to do. A linking formula looks like ... | |
| Linking Data in Two sheets corresponding to a specific number | 12/28/2010 |
| Q: This has been a challenge to me and haven't figured out a way to do(no macros pls.) In Sheet1: ... A: Aladin You can do what you want with a VLOOKUP formula. The formula might look like this ... | |
| tiered bonus | 12/27/2010 |
| Q: I am trying to build a formula to calculate a tiered bonus structure but my excel logic skills are ... A: Nisha Sometimes it is easier to put several formulas in adjacent (but not contiguous columns) to ... | |
| Collate printing | 12/21/2010 |
| Q: My office recently converted from Excel 2003 to Excel 2007 (slow, I know, but that's our IT ... A: Randall I am at a clients office where they have 2003 Excel so I can't check the 07 version to see ... | |
| Lock selected range. | 12/20/2010 |
| Q: i want to lock selected cell & selected range of cell which shouldnt edit in later. pls advise how ... A: wasfiathhar It takes a few procedures but this is what I do. First-- go ... | |
| SUMIF and AND | 12/18/2010 |
| Q: I want to know if in the SUMIF function we can use 2 conditions (like an AND within the SUMIF's IF). ... A: Rahul No the sumifand does not work. but you can add the two together for example ... | |
| Vlookup Macro | 12/16/2010 |
| Q: I have 2columns below: Country Countrycode Austria AT USA US unitedkingdom Uk India ... A: Pravee Assume your list of countries and their codes is in sheet2 cells A1 thru B100, with column A ... | |
| Selecting all sheets and then making them visible. | 12/15/2010 |
| Q: I have a work book with multiple sheets within it. Some sheets are hidden we they are not in use. So ... A: Hey Dude Sorry, although I write some macros, I am not a macro expert. I suggest that you reask ... | |
| Match two columns in different tabs | 12/14/2010 |
| Q: I would like to match two set of data in two different tabs so the two tabs are connected and when I ... A: Ignacio I am not sure I undestand what you mean by "match". If you want to make two tabs look ... | |
| need help with currency conversions | 12/13/2010 |
| Q: i am trying to do a spreadsheet with 3 currency: hong kong usa and uk. how can i have these currency ... A: Victoria This isn't to difficult, but you have to have a conversion factor built into your formula. ... | |
| formula regarding m.s.excel | 12/10/2010 |
| Q: A B C D E F 1 EMPLOYEES P.F. CONTRIBUTION ON GROSS WAGES EMPLOYER P.F. CONTRIBUTION ON GROSS ... A: Pamper This looks like exactly the same question that I reeived yesterday from taunkanti Here is ... | |
| m.s.excel formula | 12/9/2010 |
| Q: A B C D E F 1 EMPLOYEES P.F. CONTRIBUTION ON GROSS WAGES EMPLOYER P.F. CONTRIBUTION ON GROSS ... A: tarunkanti It appears that your problem can be solved with an If(AND) formula however I can't give ... | |
| UNDO EXCEL OVERWRITE | 12/7/2010 |
| Q: Is it possible to undo an overwrite in excel after the file has been closed? I am helping my ... A: Lisa Thats a bummer, but we've all done it. Sorry I don't know of a way to undo an excel overwrite ... | |
| Identifying values | 12/6/2010 |
| Q: We have a spreadsheet at our company for orders we received; each order is marked in an Excel ... A: Cass You can write a formula that looks something like this ... | |
| How to print serial numbers on same sheet but repeated printing | 12/1/2010 |
| Q: I have an excel file with only one page as you can download it here : ... A: Andy I do not know of a way to change the number in K15 based on the pages printed. I sugget you ... | |
| excel | 11/29/2010 |
| Q: My name is John, and i would like to ask you how can i find in a worksheet which cells have the ... A: John If you are looking for specific content, one way to find all of the cells simultaneously is to ... | |
| excell work sheet to invoice | 11/28/2010 |
| Q: i have a question about a work sheet , i have made a work sheet, where i have posted all my data of ... A: Shah This is how I would approach your problem. In your invoice sheet I would use a vlookup() ... | |
| Give words value, then calculate averate | 11/24/2010 |
| Q: I'm trying to assign values to words across a row; example, D1 may have a choice of 1 of 3 words, ... A: Gabriel You can use an IF formula to assign the values For example ... | |
| Using Excel 2007 Sorting Colums | 11/23/2010 |
| Q: I have 7 columns and 6 rows and I want to sort by using column C. In Excel 2003, I would just ... A: Donna Sorry I do not have the 07 version, but to to my knowledge there is no difference in the sort ... | |
| Vlookup issue | 11/19/2010 |
| Q: I want to use a vlookup (or other formula) on a master worksheet that looks up data in other ... A: I am probably not understanding the question very well, but is there a reason that you can't use a ... | |
| Formating Dates on Excel | 11/18/2010 |
| Q: I am trying to enter "01/20" as a date on Excel; it kept showing "1/1". I tried to format it as ... A: Sy You can use custom formatting and create a format that will work for you. Pick the cell you ... | |
| Calculating time | 11/17/2010 |
| Q: Roberts, I would be utmost thankful if you could advise me with my problem ? I run a cafe in ... A: Itai I have had questions from all over the world, but I believe you are my first questioner from ... | |
| Reconciling two colums over three sheets. | 11/16/2010 |
| Q: I need a formula maybe INDEX MATCH Mix that will: Take the value from B10 find it in Sheet2 in the ... A: Nathan The following formula should work +=VLOOKUP(B10,Sheet2!B10:D41,3,FALSE) The formula is in ... | |
| xls formula to color code cell | 11/15/2010 |
| Q: I have no problem setting up conditional formatting to do the first 3 conditions below. XLS won't ... A: Linda I am sorry for being late in replying, I did not see your question in the que. Unfortunately ... | |
| Input date/time modified | 11/12/2010 |
| Q: After entering information in 4 columns, I would like the 5th column to display the time at which ... A: Jordan Try this formula +=IF(AND(A1>0,B1>0,C1>0,D1>0),+NOW(),"") Remember that the NOW formula ... | |
| formatting | 11/11/2010 |
| Q: i.e. remove all the dashes. I tried text to columns and then combining the three columns but the ... A: Edith Sorry to be late answering, I did not see your question pending-- Unfortunately I cannot come ... | |
| Sumif(left(A:A;6)="yellow";B:B) | 11/10/2010 |
| Q: 1) how can I count all the numbers in column B, where values in column A begin with "yellow"? ie ... A: Rafovan Your formula needs to look something like this-- +=SUMIF(A1:B100,"yellow"&"*",B1:B100) ... | |
| Sum of a series of IF conditions | 11/8/2010 |
| Q: I am trying to have a formula make the sum of days absent, but only if the days are counted as ... A: Dominique You need to use a SUMIF formula. The formula might look like this ... | |
| Interest rate formula | 11/7/2010 |
| Q: Richard, there are a host of financial formulas in Excel, but I can't seem to find the exact one I ... A: BRETT I don't very often use the excel interest rate calculations. What it seems like you have to ... | |
| Anchoring Headings | 11/4/2010 |
| Q: Have read your previous answers on this but sorry I cannot locate the Window>Freeze panel you are ... A: Kerri It may ahave been someone else, I don't remember answering a question on "freeze panel". I'm ... | |
| Giving cell a value | 11/3/2010 |
| Q: Good morning I am trying to give a cell a value when it will be checked off and then once the chart ... A: Isabelle Here is the way I would handle this. Somewhere on the worksheet create the formula that ... | |
| pagination in Excal 2000 | 10/31/2010 |
| Q: I am using Excel 2000, and have a 20 page sheet. I am trying to print page numbers better. Right ... A: Robert I can't duplicate the problem and I have not experienced it, so it is kinda difficult to ... | |
| Excel formula | 10/29/2010 |
| Q: i make students marks sheet, in the sheet i want write down that formula which give me a result for ... A: Wajid I assume you have a cell with the students grade in it. With that cell as a reference you ... | |
| Merging information from 2 cells into 1 | 10/28/2010 |
| Q: I have a need to merge the information from 2 cells into 1 cell. Example: Column A has the letters ... A: Robert You can use the "&" formula to merge the cells for example In column c you might use the ... | |
| microsoft excel function | 10/27/2010 |
| Q: here is myi have a quadratic graph. can the excel automatically draw the projected y-axis value to ... A: Ngbanfoun I use graphs very litte so I don't have much experience or expertise in graphing. I ... | |
| finding gaps in schedule | 10/26/2010 |
| Q: expert self is working as an assistant, who have to maintain all traveling & meeting schudle of ... A: Vimal You will need to complete the data before you can find gaps, etc. I suggest you create a ... | |
| Import Worksheets into one Master Workbook | 10/25/2010 |
| Q: Would appreciate your help on the following; I've got a workbook located on C:\ drive named "Master ... A: Rudolph I am thinking that the simplest way for you to get the data to the worksheets you want is ... | |
| mean functions | 10/23/2010 |
| Q: I am trying to find the mean rent amount in a list of rentals. Should I use geomean or harmean? (or ... A: Katy I'm thinkin that you want to use the plain old average. If you are not familiar with the ... | |
| Adding date & time in one column | 10/22/2010 |
| Q: the basics of this question have already been answered I know I can add A+B to get date & time in ... A: Phillip I am kinda like the mechanic that can't find the noise the customer is complaining about. ... | |
| Excel 2007 (Drop Down Arrow) | 10/21/2010 |
| Q: I have created a dropdown box for cells in a column on a spreadsheet and would like for the drop ... A: Sam Sorry I do not know of a way to show the drop down arrow without the cell being selected. ... | |
| COUNTIF formula with additional criteria | 10/20/2010 |
| Q: I am trying to build a formula that looks at one range to determine if it should count the second ... A: Erica The counif formula doesn't work very well with multiple criteria, or as a countifand formula. ... | |
| Excel macro | 10/18/2010 |
| Q: I am looking for a macro for excel. I have thousands of cells in one column to populate. See ... A: Cheryl I'm not totally sure of the question but--- I believe you can do what you want with a ... | |
| @ speak cells on enter | 10/16/2010 |
| Q: Sir , i know about the option 'speak cells on enter' But sir i want to ask you that --- on ... A: Prathamesh I do not know a way to cause excel to give you the data about the cell, using the speak ... | |
| Querry. | 10/13/2010 |
| Q: Sir, I am working with a range given below. 92000 92025 92037 92050 92075 92100 92113 92125 92134 ... A: Talha You can use the same method that I mentioned in the first answer. First establish your ... | |
| Querry. | 10/11/2010 |
| Q: Sir, I am working with a range given below. 92000 92025 92037 92050 92075 92100 92113 92125 92134 ... A: Talha To find the numbers that increment by 25 witht he first number being 92000, I would create a ... | |
| rounding off problem in excel | 10/10/2010 |
| Q: before round off after rnd of formula ans correct ans 42.20 40.60 1.60 42 41 2 ... A: Manjunatha If I am understanding the question correctly--it appears that the first three numbers ... | |
| Check Box - Macros - VBA code | 10/7/2010 |
| Q: How can i populate the Shipping address if its same as the mailing Address IN EXCEL using a check ... A: mproenza I'm not sure what your check box looks like, but you can populate the contents by using an ... | |
| Locking Cells | 10/4/2010 |
| Q: I have currently made a spreadsheet to make the invoicing for the company i work for infinately ... A: ROBERT First after you have completed an invoice I suggest you might want to use the copy/paste ... | |
| IF Statements with financial | 10/3/2010 |
| Q: I am making a small accounting sheet and I want to use a IF statement with text and I want it to ... A: RYAN You need to use a sumif formula. The formula might look like this ... | |
| Excel 2007 | 10/1/2010 |
| Q: in colum B we have the rates ie b4=5% b5=5.5% b6=6%, in cell A2 we have the payment of 2000 when ... A: Steve Excel has a great feature which is what they call relative referencing which is the default ... | |
| menus in Excel | 9/30/2010 |
| Q: I am new to excel vba.I've created a MENU and i have added sub menus to this main menu through ... A: Nitin Sorry I am not a VBA expert--I suggest you reask the question of another allexperts person ... | |
| i need your help please! | 9/29/2010 |
| Q: the formula for arranging positions of students according to their averages from the first to last ... A: Dayana To get the positions of students you need to use the rank formula. +=RANK(H2,H$2:H$10,0) The ... | |
| Retention analysis | 9/27/2010 |
| Q: I am trying to conduct some retention analysis and produce a survival curve based on the number (or ... A: Nicole First I suggest you do some manipulation of the data to give you the information needed to ... | |
| excel 2007 | 9/23/2010 |
| Q: I have a question & don't know which function I shoul use. On the infection rate sheet in column c ... A: Sara I can't give you an exact formula since I don't know what your worksheet looks like, but--- In ... | |
| Excel Formula Question | 9/21/2010 |
| Q: I am trying to figure out a formula in Excel. I have a spreadsheet which lists various professors ... A: Jeff I am a bit confused with the question, but you should be able to use the SUMIF() formula to ... | |
| Grid Lines Not Printing | 9/20/2010 |
| Q: I posted this question a couple weeks ago, but the answer that posted had an incorrect assumption. ... A: Julie Sorry--I do not know of any explanation, other than those you have already checked, that ... | |
| Excel functions/formating | 9/17/2010 |
| Q: I am concatenating the min and max functions into a cell to show a range ="("&MIN(B1:B5)&" ... A: Frank Since the formatting is relative to the cell, I don't see a way to format only a piece of a ... | |
| combining text | 9/15/2010 |
| Q: I need to add a text line to about eight thousand other text lines, the eight thousand are differing ... A: If I am understanding your question correctly, you should be able to use the (&) equation to do what ... | |
| rounding & absolutel cell reference | 9/14/2010 |
| Q: i need to calculate a bonus in cell C5, the sales target is set at $3500(B20), if the target is ... A: Mandy I'm confused--if you can give me a bit more detail I'm sure I can help. For example Is the ... | |
| forumula for time keeping` | 9/13/2010 |
| Q: I have entered 17:30(pm)and 06:00(am)into the cells..just the numbers after formatting the cells to ... A: Mike The problem with time is we usually forget to tell excel what we are dealing with. For ... | |
| Using information from different Sheets | 9/10/2010 |
| Q: I got an assignment where I got three lists of prices from three different suppliers (A, B and C). ... A: Mathijs You can do what you need with an IF formula. It might look something like this. Assume ... | |
| Data Validation | 8/20/2010 |
| Q: I am using dependent data validation on excel 2003, to track laybys of bikes in our store. User can ... A: MATT I don't know exactly what your data looks like so I can't be specific,but I believe you maybe ... | |
| Lock certain cells in workbook | 8/18/2010 |
| Q: Can you help with a procedure to unlock all ColorIndex = 36 cells in a workbook, the rest of the ... A: Wikus I can't give you much more information than is in the help section of excel. Which you have ... | |
| Conditional Formatting | 8/17/2010 |
| Q: I have a row which has the data of the Dates if when the Particular Applications was started . I ... A: Sudheera Sorry, I am not an expert in macros. I suggest you reask the question of another ... | |
| Extract data from HTML to Excel Spreadsheet | 8/16/2010 |
| Q: I have a static webpage which is an HTML file and I wanted to extract small amount of data which is ... A: Srini Sorry I am not expert in extraction of data from HTML files. I suggest that you reask the ... | |
| Microsoft excel 2003 | 8/14/2010 |
| Q: i transreded a file from my friends data key to work with, and the formulas in the cells dont seem ... A: Steve When I get this I ck the following-- 1--Go to Toolbar/tools/options/calculation and check ... | |
| populating a list box from a recordset | 8/10/2010 |
| Q: This code is not giving the expected result: Dim vRecords As Variant Dim rs As ADODB.Recordset ... A: Richard I am definately not a VBA expert--so I will not be able to help you. I suggest you reask ... | |
| Creating pop up alert in the cell containing formula | 8/7/2010 |
| Q: I have a cell which has a formula. I need to validate the formula result such that if a user inputs ... A: treeline This is the way I usually handle your situation-- Calculate your acceptable criteria in a ... | |
| Updating one excel document with another | 8/6/2010 |
| Q: I am an admissions counselor for a college in Pennsylvania--and I'm currently trying to update my ... A: Dylan Yes you can use a VLOOKUP formula to locate and then copy the data. I don't know exactly ... | |
| pivot table data | 8/5/2010 |
| Q: I am setting up a pivot table that will be run monthly to report unit sales of 10 different items. ... A: GEOFF I am not a pivot table expert, so I prolly won't be much help, but I can give you a couple ... | |
| Vlookup within a Perimeter | 8/4/2010 |
| Q: Morning, What I’m trying to do is a vlookup and return from ‘Route’ column, depending on ... A: Gov Your problem is a bit difficult to work out with a VLOOKUP formula. Your issue gets a little ... | |
| Add values for each name in different columns | 8/2/2010 |
| Q: I already submited this question to another expert but they weren't able to figure how to solve this ... A: Joao We can make it easier for you to write your formula by making reference to a cell with the ... | |
| Formula | 7/27/2010 |
| Q: Good afternoon.I hope that my question makes sense. This is the info that I have. Name ... A: Jordon I don't have quite enough info to give you an exact formula but I will suggest what you may ... | |
| Drop Down List | 7/26/2010 |
| Q: I have created a drop down list for the user to select from, what I want is : once the user selects ... A: Seba If the formula is in a cell that you want the user to see then you can't hide it. but you can ... | |
| Drop Down List | 7/23/2010 |
| Q: I have created a drop down list for the user to select from, what I want is : once the user selects ... A: Seba Sorry to be late in answering I must have missed your question-- I'n not sure if this ... | |
| If Statement | 7/22/2010 |
| Q: I am struggling to get an if statement to work, basically I have 3 criteria the first is anything ... A: Stsven Try this =+IF(F18<80%,"Poor",+IF(F18>=85%,"Good",+IF(AND(F18>80%,F18<85%),"Average",""))) ... | |
| Summary of overdue invoices | 7/20/2010 |
| Q: I'm writing a set of sheets for weekly invoices summary such as client, date, amount etc (each sheet ... A: Mike Here is the way I would approach it. First use the copy/paste to copy the data to the front ... | |
| Help | 7/19/2010 |
| Q: I need help with pivot. I have a workbook with more than 5 tabs.. Each tab has list of people ... A: Rajesh As per my resume, I am not an expert in pivot tables. I suggest that you reask the question ... | |
| Tracker | 7/18/2010 |
| Q: I need an Excel tracker to record attendance (2 or more codes in a day) and paid time off including ... A: Mandy I am not exactly sure what your question is but it sounds as though you need a method to ... | |
| Excel | 7/16/2010 |
| Q: I am looking for a formula which would help me to do the following sorting: Cell A2:A20 contains the ... A: Raj I would handle your issue by using an IF formula. I do not believe that I completely ... | |
| Row Data copying | 7/15/2010 |
| Q: I have a spreadsheet that keeps records of all the contractors I deal with. There are approx. 1580 ... A: Dave I would handle your problem this way. First I would use a formula to identify those records ... | |
| how to provide security for single worksheet in excel | 7/14/2010 |
| Q: i want to devolop an appication with excel so that if there are 10 worksheets, each containing data ... A: Chandu There are multiple ways to protect and secure workbooks, worksheets, cells, etc. I suggest ... | |
| Excel in VBA - Find and Replace | 7/13/2010 |
| Q: I want to replace string i value to k value, but i got type mismatch error i unable to find the ... A: Sivakumar Sorry I am not a VBA expert--I suggest you reask the question of another allexperts ... | |
| Custom Rounding if 3rd decimal <= 5 | 7/12/2010 |
| Q: I need a formula/ function which can perform the following steps: 1. Take a number (which can ... A: Mark You were correct it was a bit more difficult than it appears at first glance, but this formula ... | |
| Tushar not helpful AT ALL | 7/10/2010 |
| Q: Richard, sure hope you are smarter than your co worker! Tushar said his expertise was formulae but I ... A: Sandy Yes the answer is putting two of the formulas together, for example. ... | |
| macro password | 7/9/2010 |
| Q: I need to protect my macro written in xl 2007 so that no body can read the content. Please provide ... A: Deepty Sorry I do not know of a method to achieve what you want short of protecting the workbook ... | |
| excel | 7/8/2010 |
| Q: I am trying to solve the min for this function 8x^2+352/x^2-6x+6350 when I enter this function ... A: Angela Sorry--I do not use the solver function, so I have had little or no experience with it. I ... | |
| Countif for multiple cells | 7/7/2010 |
| Q: I want to do a countif function for different cells in the same row but different columns. Example. ... A: Instead of using the countif formula you will need to use a formula that looks like this ... | |
| Excel fill down ? | 7/6/2010 |
| Q: I have a "master sheet" in my spreadsheet and I need to do a fill down. Problem is I need it to goto ... A: Jerry I am a bit confused with the question. "I need it to goto a different sheet for the ... | |
| Indirect worksheet function with closed workbook | 7/5/2010 |
| Q: As indirect worksheet function cannot display the linked cell from closed workbook, is there any ... A: Edward The chances are your reference in the link does not describe the complete path to the linked ... | |
| Find cell in a matrix | 7/2/2010 |
| Q: suppose I have a matrix of values that look similar to this A B C D E F 1 A1 B1 C1 ... A: Enrique I am going to refer you to the excel help. Look up the word INDEX and HLOOKUP. These ... | |
| diff two cells | 6/29/2010 |
| Q: I have a spreadsheet which compares the total sales (in dollars) for each sales territory for the ... A: John Can you give me more information, I.E. what is in each of the cells that are represented in ... | |
| Excel - getting data from a closed workbook | 6/28/2010 |
| Q: I saw you answer to the question below and it is almost what I am looking for but not quite so I ... A: Mandy I can think of a way to do what you want, but it is way to complicated. I am sure there is ... | |
| sum in a collumn | 6/23/2010 |
| Q: i am quite new in vba so i am pleading for your patience..:) i have the budget for each month for ... A: GEO I am going to attempt to send you a two worksheets that will show you how to approach the ... | |
| formulae excel | 6/21/2010 |
| Q: if in a row i have 11 students if within these students some missed class what formula can i use to ... A: wellington You must have some identifier that indicates that a student missed class. You can then ... | |
| xk advise | 6/11/2010 |
| Q: sorry I am very unfamiliar with this website and am probably directing this question to the wrong ... A: Garry I am not sure what all is going on with the VBA code, but it sounds as though the invoice is ... | |
| Payback formula for excell | 6/10/2010 |
| Q: Hey I have a question what formula do I use to get the payback for something I purchased. The item ... A: Kevin You need some more information What does the term payback mean--is that payment per year, per ... | |
| Pivot Table Alignment | 6/9/2010 |
| Q: I have created a pivot table (Excel 2007) and wanted merge and center (vertically) the labels. Went ... A: David Sorry I can't help you with that, I almost never use pivot tables so don't have much ... | |
| Currency Converter formula | 6/8/2010 |
| Q: I am creating a spreadsheet that will be used daily by my employees. I am wanting to have a formula ... A: Brad Your formula may look like this =IF(A1="AU",B1*C1,+IF(A1="NZ",B1*D1,"")) Where A1 is the ... | |
| Toggle Button Hide Blank Columns | 6/3/2010 |
| Q: I would like to use a toggle button to hide and unhide blank columns. The criteria is however I only ... A: Stuart I believe you can do what you want with a macro--however I am not a macro expert, so do not ... | |
| Activating Cell values when selecting from a list | 6/2/2010 |
| Q: I am using Excel 2007 and have a file where I manually enter values for money received daily AND at ... A: Hugo There are a couple of ways I can think of to do what you want. First you can use an IF() ... | |
| copy/pasting formulas | 6/1/2010 |
| Q: I am using Microsoft Excel 2007. I wrote a formula to keep track of totals on an order form. When ... A: Therese I am thinking that you have the calculation feature set on manual. Go to ... | |
| Calculating employee scheduled hours | 5/27/2010 |
| Q: Richard, I am creating a schedule for my spouse to use at her place of business with excel 2007; ... A: Ken I didn't get your attached excel file, so I will try to answer without the benefit of that. ... | |
| excel left function can it return numerical values | 5/26/2010 |
| Q: text string 12345 NW11 6PQ would like to return 12345 as a number not text, currently i have to ... A: Dan I am not sure if all of you numbers are similar to your example, I.E. 5 numbers on the left end ... | |
| Excel | 5/24/2010 |
| Q: I am trying to make "made by" look like "director" on the picture I am sending. Where it says ... A: Lesya If I understand your question, you should be able to use the merge cells feature to ... | |
| Excel formula | 5/20/2010 |
| Q: I have a formula with a negative constant number, how do I get excel to recognize it. Ex: ... A: Jim You just need another parenthesis in your formula-- For example ... | |
| two questions, Reverse, variables. | 5/19/2010 |
| Q: i was the guy last time about variables, here is a fast resume of it: Hello there, thanks for the ... A: Simon I'm sure I don't fully understand your question, but from what I am reading it appears to me ... | |
| Dragging formula but add 7 to the formula | 5/17/2010 |
| Q: OK...I have a rather large spreadsheet and on one tab called data by day I have daily information ... A: Manda Maybe a little more complicated that you wanted, but here is what I would do. First Next to ... | |
| Excel cell changed to percentage | 5/16/2010 |
| Q: I have a range of cells, all in number format, and I need to change them to percentages. Here is the ... A: Rahki I don't know what you have tried regarding the use of formatting, but the first answer is to ... | |
| Nested IFs / conditions | 5/15/2010 |
| Q: Is it possible to have a formula that includes the following? 1. If J19 = 10, return 8 2. If J19 > ... A: ANDREA Here is the formula =IF(J19=10,8)+IF(J19>10,0)+IF(AND(J19<7,H19>0.08,W19<5),8,0) You ... | |
| excel | 5/13/2010 |
| Q: im wanting to know if there's a simply way to find out if on an excel spreadsheet with a list of ... A: Mandy There is more than one way to do what you want but to keep it simple, here is what I would ... | |
| How to rename cell names in many tabs using VBA and Macro? | 5/7/2010 |
| Q: I am trying to rename many cells in 5 different tabs. For example A1 is currently = TEST and I want ... A: Sara An easy way to do it is to make all of the sheets active then type in TESTALL in cell A1 and ... | |
| Expiry Date | 5/5/2010 |
| Q: Is it possible to add an expiry date to an XL workbook or put one within a marco to stop it running ... A: David One possibility is to make formulas not work when a certain date passes. For example ... | |
| Selecting | 5/3/2010 |
| Q: I used to be able to select large chunks of my cells by pressing Control + Up and then a ... A: Matthew Apparently you want to select the cell range without actually going to the end of the cell ... | |
| Excel VBA | 4/30/2010 |
| Q: My question may seem very simple to u. I am new to VBA. Hope i'll get help from you.I have a table ... A: Ashwini I don't think you need a macro to accomplish what you want, I believe you can find your ... | |
| font color reference formula | 4/29/2010 |
| Q: I want to ask about how if I make some cell value "font color" same with reference other cell (font ... A: Umar Because you can do virtually anything with VBA, I believe your are correct "it must be VBA ... | |
| font color reference formula | 4/28/2010 |
| Q: I want to ask about how if I make some cell value "font color" same with reference other cell (font ... A: Umar If you copy and paste the cell to another location the new cell will contain the formatting of ... | |
| find the common entries | 4/22/2010 |
| Q: I have two sheets with names and street addresses I need to find out who is on both list. I put the ... A: William There are a few thing in your quesiton that I am unsure of, but unless I am reading it ... | |
| Finding the last value in a column of numbers | 4/21/2010 |
| Q: I am preparing a spreadsheet that is a crude inventory tracker. I need to find the last value in a ... A: Larry I am not sure whether you are looking for the largest value in the column or the last entry ... | |
| unable to creat check box | 4/20/2010 |
| Q: i am working in excel 2007 i want that when i click in any cell from entire H column Tick mark ... A: Saikat I believe that will require a macro to make work and I am not a macro expert. I suggest you ... | |
| Two Column Lookup | 4/19/2010 |
| Q: I want to do a lookup but need to search by two columns. I have two books that suggest using the ... A: Andrew Sorry I am not familiar with your formula, but in looking at it I don't see what is ... | |
| separete words | 4/17/2010 |
| Q: i have entered full name of a person in one cell but i want to separate the name and last name . ... A: Apurva You may be able to use the text to column feature. With this you can separate any data in a ... | |
| Conditional Formating | 4/15/2010 |
| Q: I need to format a cell that will accept 2 values with decimals, and separated by a coma. The value ... A: Donna I don't know of a way to keep excel from recognizing your entry as text I.E. when you put ... | |
| Conditional Formating | 4/14/2010 |
| Q: I need to format a cell that will accept 2 values with decimals, and separated by a coma. The value ... A: Donna I don't understand--do you mean you want two values to appear within the same cell with the ... | |
| Unique Validation List | 4/13/2010 |
| Q: I need some help with the validation & drop down list. Say I have 20 names and 20 unique value(say ... A: Sri Multiple validation lists Create a validation list for each name on your list. For example the ... | |
| Unique Validation List | 4/12/2010 |
| Q: I need some help with the validation & drop down list. Say I have 20 names and 20 unique value(say ... A: Sri You can make your validation list dependent on the items that have not been selected. So the ... | |
| formatting paste links | 4/11/2010 |
| Q: Ihave a summary page with links to cells in about 30 different sheets. Since I am using Excel 97 I ... A: David I was suggesting that you set up a macro that will do the copy paste special from each of the ... | |
| formatting paste links | 4/10/2010 |
| Q: Ihave a summary page with links to cells in about 30 different sheets. Since I am using Excel 97 I ... A: David I haven't dealt with the need to do this so I don't have a good suggestion for you, but one ... | |
| RE: Excel Formula | 4/9/2010 |
| Q: Richard! I am not very good at excel, and I need your help to calculate regular and overtime hours ... A: Dina Sorry I thought I answered your question several days ago, but it has popped up again in my ... | |
| integer constant | 4/8/2010 |
| Q: when i write ten numbers in cell excel write it same and when i write 12 numbers in cell excel write ... A: javid Sorry I thought I had answered your question several days ago, but it has popped up again as ... | |
| Values in Negative | 4/6/2010 |
| Q: How are you? Richard I am having problem with formulas column H ... A: Zafar Since I can't reproduce the results you are getting I suggest you rewrite the formula and ... | |
| Values in Negative | 4/5/2010 |
| Q: How are you? Richard I am having problem with formulas column H ... A: Zafar I still can't reproduce your problem--I copied and pasted all of the formulas including the ... | |
| Values in Negative | 4/4/2010 |
| Q: How are you? Richard I am having problem with formulas column H ... A: Zafar I can't reproduce your problem--the formulas as you have given them to me work fine. I copied ... | |
| multipal time counting in exal | 4/1/2010 |
| Q: how to count monthly total working hours in exal A: Nirdesh As you may realize there are many ways to set up an excel sheet and the related data within ... | |
| Excel | 3/30/2010 |
| Q: Is this possible to hide or make invisible all sheets in an excel Thanks, Nitesh A: Nitish Sorry to be late in answering, but I have been away from the computer. I don't know a way ... | |
| creating a vlookup formula table_array address using a drop down box | 3/27/2010 |
| Q: I am trying to create a vlookup formula that would allow me to change the table_array details ... A: KEVIN If I am understanding correctly, the formula might look something like this. ... | |
| IF else VBA | 3/25/2010 |
| Q: I am trying to make a simple if else statement in VBA. I just want to select a cell and if the cell ... A: Jeff Sorry I am not a VBA expert so I can't really help you with your question. Your code looks ... | |
| Repeating formula? | 3/19/2010 |
| Q: I was taking a test today, and had a question which I was able to answer, but know I didn't use the ... A: Dave I'm sure there are many ways, but here is one formula +(10950-SUM(1+2+3+4+5+6+7+8+9)*150)/10 ... | |
| formula | 3/18/2010 |
| Q: In column A I have a list of numbers. In column B I would like a specific code to appear based on ... A: Chris Try this formula =IF(AND(A1>=9,A1<=16),"3H","") The formula says If cell A1 is greater ... | |
| Excel Macro Help | 3/17/2010 |
| Q: Roberts, I am creating a spreadsheet which shows spreads between various numbers between months. ... A: Freddie Sorry to be late getitng back to you, but I just got back to my computer. You can do what ... | |
| Helper Cells | 3/16/2010 |
| Q: I currently have a spreadsheet that is build predominantly using Sumproducts. It is fully ... A: Daniel I don't see anything in your formula that is a particular issue n terms of speed, If the ... | |
| titles | 3/13/2010 |
| Q: in excel 2010. I like to set a title in the row 1 and the columns a+b+c+d please give me a litle ... A: bas I am sorry, I don't understand the question. I do not have the 2010 version perhaps there is ... | |
| Search String in one Column & Return Diff String in Another column | 3/11/2010 |
| Q: This is my Sample Data: A B Alerts R1 Share R2 Server ... A: SAMRAT I am not totally sure of your data and how it is set up but I believe you can use the ... | |
| Rounding within Excel | 3/9/2010 |
| Q: I have the following formula: =(DAY(D40*3)&" Days "&(D40*3-DAY(D40*3))*8&" Hours "&MINUTE(D40)&" ... A: Ruljr Try this formula =+(DAY(D40*3)&" Days "&+ROUND((D40*3-DAY(D40*3))*8,1)&" Hours ... | |
| finding cell character count for a whole worksheet | 3/8/2010 |
| Q: I hope you can help as I've reached the limit of my excel 2003 knowledge. My problem is that I have ... A: Gerry I believe you will be able to get what you want by using the LEN or LENB formula and then ... | |
| Alegebra Formulas | 3/7/2010 |
| Q: I have to come up with the federal taxes on a spreadsheet for school and can't figure out how to put ... A: Leon I am condused with exactly what we are supposed to be doing and of course it makes a big ... | |
| Remove words in a cell | 3/6/2010 |
| Q: Contents of cell A1 = Po Box 678876 Springfield Contents of A2 = 156 Main Road Neverland Cell ... A: Nola Sorry I do not know of an easy way to separate the text into what you need. What I usually do ... | |
| VB code for selected area in sheet | 3/5/2010 |
| Q: Please check attached image for my question. In my sheet there is 5 students named A,B,C,D,E. They ... A: Eran Here is hwo I would approach the problem First I would create a total of all the marks for ... | |
| Excel Function for spliting a single word | 3/4/2010 |
| Q: How to split a word in excel to different cells. For ex. "VisitorsCenter" as "Visitors Center". ... A: Isha There are a couple of ways to split words or phrases, etc. You can use the text to columns ... | |
| Performing searches in multiple sheets | 3/3/2010 |
| Q: I have two excel workbooks that I am trying to perform a search on for like data, i.e - finding like ... A: Troy If I am reading you right, I believe you will be able to use the vlookup function with links ... | |
| Incremental Vol calculation | 3/1/2010 |
| Q: I am trying to calculate the incremental vol for my products, i am not able to figure out the ... A: Baher I am not sure of your definition of vol, but I am assuming it means volume and that the ... | |
| question | 2/28/2010 |
| Q: i have an excel workbook like the file in previous mail and I want my drop down list to have links ... A: Farah Sorry for being late answering, but I've been away from my computer. You can create a macro ... | |
| ROunding of cents | 2/23/2010 |
| Q: I have created a payroll system using Mircosoft excel. I am having a problem of rounding figures to ... A: INIA Here is the formula ... | |
| excel formula | 2/21/2010 |
| Q: i have to calculate the number of hours an employee has worked overtime in the company.The company ... A: Solay I would take me several hours to work out all of the possibilites that you have given me. ... | |
| about excel... | 2/20/2010 |
| Q: First of all i am really thankful to you for answer of my last question and how can i rate you for ... A: B It will be easier to create and maintain if you can use the method that I suggest. Remember you ... | |
| Excel | 2/19/2010 |
| Q: I have a column which has numbers in it 3.1.1, 3.1.2 etc - is there a way of getting the numbers to ... A: Esme I am not sure that I fully understand the question--do you mean reproduce in the same column ... | |
| about excel... | 2/18/2010 |
| Q: First of all i am really thankful to you for answer of my last question and how can i rate you for ... A: B Here is the way I usually handle this type of vlookup problem. First each city and weight is ... | |
| about excel... | 2/17/2010 |
| Q: First of all i am really thankful to you for answer of my last question and how can i rate you for ... A: B. You are welcome for the answer. You cannot rate me because I have removed the rating ability ... | |
| Dividing negative numbers in excel | 2/14/2010 |
| Q: My question is this: What would my proper formula be to divide two negative numbers? Specifically, I ... A: Assume A1 is the 12010 and B11 is the 11126 If they are both negative +B1/A1 will result in .92 If ... | |
| Span of numbers | 2/13/2010 |
| Q: I have columns of Number (say e3:a3000) that change weekly and I want a formula that extracts the 10 ... A: Ray Usually I use a comparison of the old numbers with the new numbers to determine which are new, ... | |
| Span of numbers | 2/12/2010 |
| Q: I have columns of Number (say e3:a3000) that change weekly and I want a formula that extracts the 10 ... A: Ray If the numbers that you want to work with are static I.E. cells A3 to A53 are always the ones ... | |
| display cell value. | 2/10/2010 |
| Q: Perhaps a very simple question, but I can't find the solution.. There is a value in my Cell S2, its ... A: Robert Sorry, I don't understand the question. The part I don't understand is "I want to display ... | |
| about excel... | 2/8/2010 |
| Q: i m facing a problem in excel. i want to copy the row of one sheet to another sheet on which vlookup ... A: B This is what the excel help says aboout the #REF! error--- "Correct a #REF! error Occurs ... | |
| Calculating hours | 2/6/2010 |
| Q: Is there any possibility in Excel to calculate within a timelapse, how many hours are before and ... A: How about this--if A1 contains 13:00 and A2 contains 19:00 and C1 contains 17:00 The the formula ... | |
| EXCEL INVENTORY DATABASE | 2/4/2010 |
| Q: Richard Greetings Hope you will be fine. I m running a store in which i sell different type of ... A: Usman Sorry I don't have an example of an inventory system that I have created, but there are some ... | |
| about excel... | 2/2/2010 |
| Q: i m facing a problem in excel. i want to copy the row of one sheet to another sheet on which vlookup ... A: B Wagas I cannot duplicate the problem you are having, which makes it a bit difficult to resolve. ... | |
| Excel Formula/Functions | 2/1/2010 |
| Q: I am trying to remove an unspecified number of characters from a text string i.e. John Smith I ... A: Emma Hopefully there is some type of delimiter in the name that you can use to separete them, ... | |
| excel | 1/31/2010 |
| Q: i have 2 sheets and i want to add sheet 1 cell e34 with sheet 2 cell 34 please give me a simple ... A: Ainaa If the formula is in sheet1, the formula looks like this. =E34+Sheet2!E34 If the formula is ... | |
| Excel Date Range Formulas | 1/29/2010 |
| Q: How do I populate/fill 1-week date ranges (respective to the 2010 calendar weeks) into adjacent ... A: Yvette There may be an essier way, but the way I would do it is-- It will take several steps to do ... | |
| Excel Mulitple Column Compare | 1/28/2010 |
| Q: I have two excel worksheets, each containing four columns. They contain the following columns: A: ... A: Gabe I assume that the data isn't on the same rows in worksheet2 as in worksheet1. If it is you ... | |
| Embedding tiff file in an Excel footer | 1/27/2010 |
| Q: I am an art director designing an Excel document (on a Mac) for a client of ours (who is on a PC). ... A: David I'm sorry I haven't had much experience or need to create and imbedded tiff file so I am not ... | |
| Delete Rows in multiple sheets | 1/25/2010 |
| Q: I have a spreadsheet with multiple sheets and the A1 would be constant in all the sheets. The data ... A: Arvind Here is a amacro that deletes data that has already been recorded--as you can see the first ... | |
| Excel | 1/23/2010 |
| Q: Can you give me all fomula abriviation like sum what the meaning of that A: Amet I am not sure exactly what your question is but-- There are many many formulas or functions ... | |
| copy word docs to excel | 1/21/2010 |
| Q: I want to select one doc file from the folder using excel macro & save it in excel sheet. then ... A: Ashish Sorry, I am not a macro expert, so I do not know how to write the code for your macro. I ... | |
| Help with INDEX | 1/19/2010 |
| Q: Could you please help me out.If I'm getting error "#VALUE" by using the formula ' ... A: Sidarth Whenever you are getting any error message as the result of a formula, you can use the ... | |
| Excel Vacation Bid workbook question | 1/18/2010 |
| Q: I have been tasked with handling vacation bidding for 40 reps at my work and I have created a ... A: Jesse I sounds like the VLOOKUP formula will work for you. You could use the Vlookup to find a ... | |
| Excel macro to loop through a particular column | 1/17/2010 |
| Q: can you please help me in figuring out the solution for my problem. My problem is to loop through ... A: Reva Sorry I am not a macro expert and I have no idea how to include your need in a macro. I ... | |
| Excel question | 1/16/2010 |
| Q: I have a formula in Excel that uses a fixed rate in one of its parts. But when I drag it to the rest ... A: I am not sure that I fully understand the question, but-- If you want the reference in a formula to ... | |
| Logic Statement | 1/15/2010 |
| Q: Having trouble with how to write this formula. In Sheet1 Cell B16 = Empty then Sheet2 Cell E6 = ... A: John The formula in cell E6 of sheet 2 would look like this-- ... | |
| Function Needed | 1/14/2010 |
| Q: Mr. Roberts, I've got a summary tab that sums the same cell from corresponding tabs. If I keep ... A: Tom I don't know of a function that will do what you want, but there may be one and I suggest you ... | |
| Locating a worksheet using find in a macro | 1/11/2010 |
| Q: Can you help me with this? I would like to find a way to scan a barcode and have it then locate ... A: Marc Sorry -- I haven't had any experience with this issue before, so I haven't had to solve the ... | |
| auto link of data | 1/10/2010 |
| Q: I have created a shop stock database in excel on a worksheet. on a seperate worksheet i wish to ... A: Paul It is pretty easy for you to create a vlookup formula to look up your item number, and load ... | |
| combination of numbers from that set will sum to the total | 1/8/2010 |
| Q: it is possible for VBA/formula do the calculation ? Assume Given a set of random numbers and a ... A: Kenny I am guessing that VBA can solve the problem for you, but I am not a VBA expert. I suggest ... | |
| Excel formatting for stock control | 1/7/2010 |
| Q: I have created a stock list in Excel 2007. I have a quantity column and a min level column. How do i ... A: Richard You can also use the conditional formatting to format the rest of the cells. It will be ... | |
| Counting fill color cells by specific color | 1/5/2010 |
| Q: I have created an excel worksheet to track my patients and the criteria necessary to complete their ... A: Linda It will be easier for you to count the cells based on the same criteria that you used for the ... | |
| Auto Increment | 1/4/2010 |
| Q: I am Using Formula =IF(A1=0,"","Rel-2010/001") showing Results "Rel-2010/001" in a particular cell. ... A: HANIF If you make your formula refer to a cell that has the "Rel-2010/001" in it then you can copy ... | |
| Excel Worksheet Help | 1/3/2010 |
| Q: I got your reference from one of the blog site and have an understanding about your expertise ... A: Ajay I am not an expert in Macro/VBA--I have been able to answer some questions with my limited ... | |
| Visual Basic for a Command Button | 1/2/2010 |
| Q: I'm trying to create a command button that will reset certain cells to their original data and have ... A: Dan Here is a real simple way that might work for you. If you copy the original data to another ... | |
| Strange number in Excel to convert to date | 12/31/2009 |
| Q: In Excel i can't convert 280509 to 28-May-09 Can you provide solution??? Thanks regards, Victor ... A: Victor Sorry I do not know of a way to do your conversion. If you input the date as 05/28/09 and ... | |
| EXCEL TAB LABEL INTO CELL | 12/30/2009 |
| Q: How can I get the Sheet Tab to auto enter itself into any cell in the worksheet itself. Also, the ... A: Simon Sorry I can't make your day--I do not know of any way you can automatically make the name ... | |
| excel 2003 | 12/28/2009 |
| Q: I have 3 columns Titles PASS FAIL Minor Surface Repair 4 Major Surface ... A: David I don't fully understand your data, It looks like the pass/fail numbers represent the number ... | |
| excel | 12/27/2009 |
| Q: i have set validation rule on a1 cell that the value in a1 cell should be less than cell b1. when i ... A: Asif The validation comparison is made at the time of the entry in cell A1 since there is no value ... | |
| auto numbering in Userform | 12/22/2009 |
| Q: I still a neophyte on making codes in VBA and have this concern. I have been poundering my head in ... A: Frederick Sorry I have no real expertise with VBA except with the simplest of problems, so I won't ... | |
| Excel 2007 Macro assigned to a button | 12/21/2009 |
| Q: I have a workbook with a number of Macros assigned to buttons located on a single sheet. When I run ... A: Margaret I haven't had the experience of the macros changing references, so I haven't had to solve ... | |
| Urgent!!!! | 12/20/2009 |
| Q: i want created a combobox in an excel sheet. my quest: how can i set a background color to the ... A: SOPHIE Not sure exactly what you mean by a combo box, but usually what is meant is the use of a ... | |
| how to count hours and mins | 12/19/2009 |
| Q: would you please tell me how i can count hour and mins thankx A: Amin I am not sure how your data is entered or if you have any data entered, but excel can count ... | |
| Excel Financial | 12/16/2009 |
| Q: I have made investments non periodic say on 20 Jan 2007 $2500, 15 Sept 2007 $3000, 15 Feb 2008 $ ... A: Cheni Sometimes excel makes these calculations more difficult thatn they should be so for your ... | |
| Help! PLEASE! | 12/15/2009 |
| Q: I am new to Excel so I am sure I will look stupid, but here goes. I need to create a spreadsheet ... A: Meghann I'm not sure exactly what the question is, but If it is about the formatting--excel will ... | |
| Vlookup formula | 12/13/2009 |
| Q: A B C D 12 NC1 45 NC4 34 NC2 34 NC2 3 NC3 12 NC1 45 NC4 3 NC3 2 NC5 2 NC5 In ... A: Richard I am not sure that I understand your question-- The formula in column C should yield the ... | |
| Auto Values with Referece of Other Cell | 12/11/2009 |
| Q: A B 1 Bob AB-356 2 Alvin If someone type anything i.e.name or number in ... A: Hanif This is the formula that you need in cell B1 =IF(A1<>0,"AB-356","") In Cell B2 the formula ... | |
| Excel with Work Schedule | 12/10/2009 |
| Q: Mr. Roberts, I am trying to create a work schedule that allows me to track a few things. I want to ... A: Mike I hope I am reading your question corectly--if so here is my suggestion. I am assuming that ... | |
| insert cell in a specific column | 12/9/2009 |
| Q: I have some column as following:- NAME Class No. Rakesh vi 20 Rupesh vii ... A: Rakesh I do not know of a way to insert the cells with a single command. It is possible to ... | |
| insert cell in a specific column | 12/8/2009 |
| Q: I have some column as following:- NAME Class No. Rakesh vi 20 Rupesh vii ... A: Rakesh To insert a cell---make active the cell where you want the insert to be, right click, select ... | |
| SUMIF | 12/6/2009 |
| Q: Kindly help me out. I've named a column on Sheet 2 as Sum_2002.This is column A of Sheet2.I've 1's ... A: siddharth The name Sum 2002 isn't a valid name, it should not have a space in it. The name of the ... | |
| seeking guidance on building a Dynamic Graph | 12/5/2009 |
| Q: I'm stuck in creating Dynamic Chart.I've done some work on this.I've linked three cells together ... A: Siddarth Sorry I am definitely not a chart expert so I can't be much help on this one. I suggest ... | |
| vlookup & if both formula in same time | 12/4/2009 |
| Q: I have 4 column in 2 sheet. In first sheet, I have (first column : name, second column: station, ... A: RAKESH It appears that you want to bring the number over only if all conditions are met. The ... | |
| vlookup & if both formula in same time | 12/3/2009 |
| Q: I have 4 column in 2 sheet. In first sheet, I have (first column : name, second column: station, ... A: Rakesh You need a multiple condition IF formula--it might look like this ... | |
| Large files | 12/1/2009 |
| Q: Richard, we've created a rather large workbook and are wondering if we should bring down the size. ... A: Rea Sorry I didn't get back to you with a really quick and great answer, but that's because I don't ... | |
| Looping in Macro | 11/23/2009 |
| Q: can the macro look in a set of folders for a specific name based on a specific cell value and copy ... A: Khaled I am definatly not a expert in macros--but I do believe you can do what you want--I suggest ... | |
| Count/Countif | 11/22/2009 |
| Q: ... I am trying to do a input sheet for a questionnaire. Currently having trouble trying to get a ... A: Matthew It sounds as though you need the countif() formula, where the formula only counts the cells ... | |
| Linking cells or mirroring worksheets | 11/20/2009 |
| Q: I would like to have what I do in the first worksheet appear in the next 6 worksheets. I linked the ... A: Arturo Place your cursor at the bottom of the worksheet where the sheet tabs are and right ... | |
| 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 200 | |