You are here:
Excel/Questions Answered by Expert Anne Troy
| Subject | Date Asked |
| Sort by date | 11/23/2011 |
| Q: I have an excel sheet with 20,000 rows including date information. I need to sort these rows by ... A: I assume that the dates are not dates but text. You will need to convert them to dates. First, try ... | |
| Excel 2007 Changes to existing sheet with data | 1/1/2010 |
| Q: I have made changes in a existing monthly worksheet, added colums and formulas. I now would like to ... A: It's my experience that it would be easiest to copy the entire worksheet, then copy your data from ... | |
| Month and Day extraction into 1 cell. | 1/28/2009 |
| Q: I am interested in extracting the month and day from a date into ONE cell. For example, if A1="Aug ... A: Try this, Philip: =TEXT(A1,"mmm")&" "&TEXT(A1,"dd") If that doesn't work, please get back to me ... | |
| Populating weekly and monthly totals in Excel 2003 | 1/27/2009 |
| Q: I am trying to figure out how to set up a work book where I can enter daily labor costs and material ... A: Dan. Make a worksheet for each week or month. Number them 1 through 52. Then use the formula ... | |
| Problem rounding to the Nearest Number | 1/27/2009 |
| Q: Problem rounding to the nearest number An enduser has stumped me on this excel issue. She has a ... A: I don't know the true value of G1, so I can't swear it'll round to 83 cents, BUT... You could do ... | |
| conditional format using formulas | 1/27/2009 |
| Q: I need help please. Using Excel 2007, I'm trying to figure out the best way (or any way at this ... A: Try the examples here, Allison. If they don't work, please email a sample workbook to anne at office ... | |
| Excle Conditional Formatting | 1/24/2009 |
| Q: I would like to format a column based on whether each cell value is greater or less than the value ... A: Sorry! ANSWER: Okay. Suppose 210 is in cell A2. You select cells A3 through A6. From the HOME tab, ... | |
| Excle Conditional Formatting | 1/24/2009 |
| Q: I would like to format a column based on whether each cell value is greater or less than the value ... A: Okay. Suppose 210 is in cell A2. You select cells A3 through A6. Format-->Conditional formatting. ... | |
| Matching data in two worksheets | 1/23/2009 |
| Q: I have to match 2 worksheets, A and B. Worksheet A has 500 rows and Worksheet B has a thousand rows. ... A: Liz! Forget everything you've ever learned about lookup, and read my article: ... | |
| Conditional Formating | 1/22/2009 |
| Q: I know how to add a conditional formatting to a cell that I want to make be a certain color when the ... A: I understand your question, Bre, and it works exactly the same way. Select your cells--the ones you ... | |
| Counting text in Excel | 1/22/2009 |
| Q: I really hope you can help. As you will see by the picture there are lots of cells that will be ... A: Isabelle. Text is counted using COUNTA. :) So, if you want to count X's in a column, one of these ... | |
| Word and Excel interaction | 1/22/2009 |
| Q: Good morning. I'm trying to clean up a report created in a 3rd app. I bring it into Word to put the ... A: It made perfect sense, Pat. :) If you have a tab-separated line in Word for each record, then you ... | |
| Formatting text | 1/22/2009 |
| Q: Anne, I have a spreadsheet doing some stats etc and at the bottom I have merged a heap of cells to ... A: Allan, I hope you'll take this kindly...'cause that's how I mean it. Don't try to get Excel to ... | |
| Column headings in Excel | 1/22/2009 |
| Q: I need to make a list in excel with approx 6 columns, and I would like to have the name/header of ... A: When you sort, does it take the heading with it? That's what it sounds like is happening for you. ... | |
| excel printing duplicate copies | 1/21/2009 |
| Q: a few days ago excel began automatically printing two uncollated copies of any spreadsheet i ... A: I'm not sure if I can help, Lorielle. One thing I can suggest is making sure you didn't actually ... | |
| Deleting all objects from all sheets in workbook | 1/21/2009 |
| Q: I have several spreadsheets in a workbook and want to delete all objects from each sheet at the same ... A: If you are talking about true Excel "objects", then you should be able to Edit-->Go ... | |
| Conditional Formarting | 1/20/2009 |
| Q: Anne, I am trying to perform a conditional formating based on values in my cells i.e I7 3 - Medium, ... A: Yes, the limit is 3 conditional formats. I do not do VBA, but I am aware of this article here: ... | |
| Shorter the wide of a column | 1/19/2009 |
| Q: When I open each tables in Excel, there is a column that always shows pretty wider than other ... A: Use the format painter, Bruce. ... | |
| excel functions | 1/16/2009 |
| Q: I am using excel to track time of my technicians and need to take a Work Order number from column A, ... A: Use Data-->Subtotals. Or pivot tables (which I personally hate). But that's what those features are ... | |
| order by a column | 1/16/2009 |
| Q: I did indent to order a sheet by a column . The message : all the cells need to have the same wide ... A: Willy: You can't change the width of only SOME rows in a column. The entire column width must be ... | |
| Copy cells to different worksheet IF meet criteria | 1/13/2009 |
| Q: I am currently working in two separate worksheets and would like to copy some info from one to the ... A: Sorry. I chose it's "outside my expertise", but didn't mention, you'd really need to use VBA to do ... | |
| vlookup help... | 1/7/2009 |
| Q: I'm trying to do a vlookup function but I seem to be having problems because some of the ... A: James. Sorry for the delay in responding. I think the problem with your lookup is that you're ... | |
| EXCEL question | 1/7/2009 |
| Q: i would like to compare 2 columns in excel. both columns are filled with list of products.i would ... A: Try something like this, Balaji: =IF(COUNTIF(Sheet4!A:A,E1),TRUE,FALSE) Sheet4!A:A means it's ... | |
| IF statement formula with too many ifs | 1/7/2009 |
| Q: In my formula the B5 refers to the cell with the rank and the AI column is the percentage trigger. ... A: Bill! Use a VLOOKUP, please. Create a table, for instance on another worksheet: 50 100 51 200 ... | |
| countif | 1/7/2009 |
| Q: I have a countif formula that counts a range, outputting how many 'a', 's' or 'c' etc there are. (a, ... A: Sorry. Countif isn't going to work if you literally have "a,s & c" in a cell unless you are ... | |
| Sumation of an ongoing column on another sheet. | 1/6/2009 |
| Q: I have a "transaction" sheet which resembles a check register, but with a column for "code" used for ... A: Perhaps it's the way you're asking, John. I cannot make out what you mean by "sums for each month ... | |
| Time calculations | 1/6/2009 |
| Q: This should be an easy one but I'm a novice here. I have two cells with date and time entries ... A: Select the cell, Dennis. Then hit Format-->Cell and choose date and time format, and choose the one ... | |
| excel if statement | 1/6/2009 |
| Q: "What I'm trying to do seems simple but it's been so long I can't remember the formula ... A: =if(d25<=8,d25*62.5,(d25*62.5)+((d25-8)*50)) If that doesn't help, can you please be more specific? ... | |
| hyperlink to cell in spreadsheet | 1/6/2009 |
| Q: I would like to create a menu that allows me to hyperlink down to the first instance in a list. ... A: There are issues for me with this. While I totally suck at the INDEX and MATCH functions, I ... | |
| replacing values | 1/6/2009 |
| Q: i'm having a problem replacing values in excel. i input sss numbers in excel but the database to ... A: Enrico. I'm sorry I don't know what an sss number is... However, I can tell you that 08-123456-9 is ... | |
| hyperlink to cell in spreadsheet | 1/5/2009 |
| Q: I would like to create a menu that allows me to hyperlink down to the first instance in a list. ... A: I'm not sure I can help, Andrea. I need more information. For instance, is your list static? If yes, ... | |
| Excel | 1/4/2009 |
| Q: How do you copy down a formula that adds up to 25 worksheet cells in the same workbook, where the ... A: Marg! Suppose your formula is =A1*B1 Suppose you want to copy that and each time it increases the ... | |
| Average time in Excel | 2/29/2008 |
| Q: Ann: I hope you can help me. I have a monthly spreadsheet where "last production run" time is ... A: Unfortunately, it looks like you'd be talking about: 1. Almost 10 PM. 2. 20 minutes to 1 AM. 3. ... | |
| Office 2007 | 12/24/2007 |
| Q: I am getting ready to make the plunge to MS Office 2007 from 2000. Will I be able to convert all of ... A: I cannot answer your questions definitively, however: 1. I have had NO problems opening older ... | |
| Date/Time Stamp | 12/24/2007 |
| Q: Good afternoon, I am using Excel 97, and would like a way of inserting the current date into a cell ... A: Record a macro that: 1. Type =NOW() into the cell and hit Enter. 2. Hit the Up arrow to go back to ... | |
| WANT TO KNOW WHAT FORMULA I HAVE TO APPLY | 12/14/2007 |
| Q: I AM WORKING IN EXCEL 2003 FOR XP, I AM FACING PROBLEMS TO MANAGE MY OFFICE WORK. PLEASE GUIDE ME ... A: Akber. :) Two things. One: Trying to do this with a formula is not efficient. Instead, do it with ... | |
| Evaluate Dates between what season? | 12/14/2007 |
| Q: I have a list of dates, and I need to find out which season each one falls in. From all of the date ... A: Try this, Courtney: http://www.officearticles.com/allexperts/courtney.xls Unfortunately, Excel DOES ... | |
| Matching records in Excel | 12/11/2007 |
| Q: I have two separate Excel table files that consist of "address book" type information (name, ... A: Sure. Use vlookup. You'll first have to make absolutely sure that the format of both cells is the ... | |
| Cell Values from another worksheet. | 12/10/2007 |
| Q: In one work book I have a list of all my suppliers, and on another sheet I have all my FAA Approved ... A: vlookup does NOT need to be sorted. :) Try using the forth argument: ... | |
| Incrementing a cell reference | 12/10/2007 |
| Q: I have 100 data points in Col_A. I only want to output every 4th data point into Col_B. (I.E. in B1 ... A: I think so, Chris. I'll let you test it instead of me. :) Put A1 in B2, A5 in B3, A9 in B4. Select ... | |
| reference cell | 12/10/2007 |
| Q: I'm trying to set up a cell which jump to a particular Worksheet in another Excel file, but even if ... A: The EASIEST way to hyperlink to another cell in another workbook: Select workbook2 cell and hit ... | |
| IF function help | 12/8/2007 |
| Q: I need some help with the following pension calculation: If amount in column B is equal to or less ... A: Eileen! That's my daughter's middle name. She's 24. As you can imagine, she hates the name. :) I ... | |
| If Statement | 12/7/2007 |
| Q: I need an If statment that will pick up the highest number in a row of numbers. Example if the ... A: Why not just use the MAX function? :) Check it out. If that won't work... ... | |
| Need help with IF statement | 12/6/2007 |
| Q: Please tell me what is wrong with the below statement: ... A: Sorry...I stepped away for the afternoon. Here we go: IF B4 does not equal B3 I want the number to ... | |
| Need help with IF statement | 12/6/2007 |
| Q: Please tell me what is wrong with the below statement: ... A: I can't tell what you're trying to do. The best thing is to tell me EXACTLY in English what you want ... | |
| Sum if frequency match problem | 12/6/2007 |
| Q: I have a formula that is working fine =SUM(IF(FREQUENCY(H:H,H:H)>0,1)) However, I'd like to add an ... A: I need more information, Patti. Column O's value...it will ALWAYS be a specific value? Or when ... | |
| Excel Charts | 11/30/2007 |
| Q: I am trying to create a chart of election data over the past two presidential elections. What I am ... A: Jean, I think you have your data weird, perhaps? I would have TWO columns: 2000, 2004. Then I'd have ... | |
| excel | 11/29/2007 |
| Q: I opened a spreadsheetand changed a number in cell a8 and it did change.But in cell a10 having the ... A: It sounds like your Excel has been changed to "manual calculation". Turn it to Automatic under ... | |
| Mail Merge | 11/29/2007 |
| Q: I've formatted a date column in Excel to display as "November-08" rather than "11/29/2008." When I ... A: Michael! The format doesn't carry over. This article explains exactly what you need to do: ... | |
| Incerting dates into file names | 11/28/2007 |
| Q: I have a worksheet where I have to change the name of a file/sheet reference as the date changes. ... A: Frans. Using a macro is the best way, probably. Check this one out: ... | |
| How can i take this list and put the email in column a and the name in column b in excel? | 11/27/2007 |
| Q: How can i take this list and put the email in column a and the name in column b in excel? ... A: Here is what I would do... 1. Copy all. 2. Paste to Word 3. Hit Ctrl+H a. In Find What, put ), ... | |
| Help!! | 11/27/2007 |
| Q: I need help with excel. I just developed a quiz, in this quiz if you enter a correct answer in ... A: Masego. Sorry. I think I'm going to need to see the formulas in F column. If your formula is using ... | |
| Counting in separate columns | 11/26/2007 |
| Q: I have a file for my company that determines the number of times a student eats lunch. In one ... A: =SUM((C$2:C$28="L")*($B$2:$B$28=A))/COUNT($B$2:$B$28) You should be able to copy this formula to ... | |
| little job | 11/25/2007 |
| Q: JUST NEED TO COUNT THE NUMBER OF "Y" IN ONE COLUMN, "IF" IT CORRESPONDS TO THE CRITERIA IN ANOTHER ... A: Felicia. Email your workbook to anne at office articles dot com and I'll take a look. You could also ... | |
| formula excel 2003 | 11/22/2007 |
| Q: I have a spread sheet where I want to show how many people are related in a sample. For example, I ... A: I don't need your file, Theo...or at least I don't think so. But, I will say, I'd be changing those ... | |
| Linking Combo Boxes in Excel | 11/21/2007 |
| Q: I'm having BIG problems with a school project using excel. we have to use combo boxes to choose a ... A: Rachel. Who says you have to use a combo box? Why not a dropdown? See: ... | |
| Excel: Drop-Down List label | 11/21/2007 |
| Q: I have several drop-down lists in a form I created via validation and combo box. I would like to ... A: 1. a dropdown is NOT a combo box. 2. I don't think a combo box has a "label" like that. BUT If you ... | |
| excel | 11/20/2007 |
| Q: If for eg, i had 1000 rows of info and i needed to put a blank row between each one, is there a ... A: Brian. Sorry to answer a question with a question, but any Excel expert is going to say: Why in the ... | |
| Excel | 11/19/2007 |
| Q: I have a list of customers with credit card numbers that I would like to relate to our customer ... A: Dianne. I presume you have a list of names, credit card numbers, and account numbers. I also presume ... | |
| Counting Pending Dates | 11/19/2007 |
| Q: I have a spreadsheet that I need to count how many items are pending between two submission dates. ... A: Tina. I ***think*** you can do this with a sumif between 2 days. I have an article here: ... | |
| Expanding Cells in Excel | 11/19/2007 |
| Q: I would like to understand how to expand the row height as data is entered into it. The cell is ... A: Deb. There's always been issues with merged cells and autofitting height. Sorry about the popups, ... | |
| Excel 2003 | 11/19/2007 |
| Q: I am trying to create a form where a drop down, data validation list, will automatically populate ... A: What other cells? Suppose you have a dropdown in cell B2. When you choose from that, you'd like the ... | |
| Budget Table | 11/19/2007 |
| Q: I am trying to create a Budget table to show a break down of expenses. I want to use the data from a ... A: Yes, but switch your columns around so desc is in column B and expense in C. Then use ... | |
| xls to txt | 11/19/2007 |
| Q: I'm trying to build a spreadsheet where values can be input into different cells and imported into a ... A: Brian. It's called "fixed width". I think you need a macro. Excel never did accomplish this. I'm not ... | |
| 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: I am unable to work anything out. Go over to www.vbaexpress.com and join and ask. It's ... | |
| 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: OH! Okay. You are trying to open a hyperlink. That is not a command... The EASIEST way is to create ... | |
| 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, send me your file. We will get this done today. No sweat. Email to anne at office articles ... | |
| Excel formula | 11/17/2007 |
| Q: I'm trying to make a type of program kind of thing, more of a self-calculating worksheet. I have A1 ... A: Jen: I don't understand the question, I don't think. But, suppose you had a price list of all the ... | |
| How to do this | 11/16/2007 |
| Q: ""Hi anne i am using and excel sheet name casestudy1. In that workbook what i want is it should show ... A: Jothi! My Doctor's name is Jothyi Veera. :) 1. You need an "event procedure" (macro that runs on ... | |
| Macro Functionality | 11/14/2007 |
| Q: I have a user that is trying to use a macro created in office 2003 on a computer that has office ... A: Have him open the file. Hit Alt+F11. Go to Tools-->References (I think?), then he'll have one that's ... | |
| currency conversion | 11/14/2007 |
| Q: very simple - basic question. What is formula for converting us dollars to canadian currency. my ... A: Joanne. Using this site: ... | |
| How can i convert the text 'million' to its number format | 11/14/2007 |
| Q: I have an excel file in which cell contains 10 million 4.43 million How can i convert these cells to ... A: Kevin! I would think that the easiest solution would be: Hit Ctrl+H Type a space and then the word ... | |
| Duplicating data | 11/13/2007 |
| Q: Anne. I one worksheet that shows information on scheduling for our projects, i.e., in-hands date, ... A: That would be really bad form for an Excel file, Linda. Excel would much rather you use its features ... | |
| calculating elapsed days from 3 values | 11/12/2007 |
| Q: I have a very sticky problem. I'm trying to calculate the number of days elapsed from a start date ... A: Sam! Okay. What I need to know is...which of the two different columns do you want for the end ... | |
| hello--Help needed | 11/12/2007 |
| Q: I have a problem in excel, i try to link two excel sheets. The first is a list of product ... A: Chris. Try this: ... | |
| conditional formatting excel | 11/10/2007 |
| Q: Anne, I have more than 3 conditional formats. What formula do i need to put that says: If the text ... A: I'm so sorry, Sarah. I don't program either. Me and programming do NOT mix and I know there's tons ... | |
| Conditional formatting | 11/9/2007 |
| Q: I am trying to have excel relate to real time with a relationship from a input date lapsing and a ... A: This will require conditional formatting using a formula. Please see my article: ... | |
| data extraction | 11/9/2007 |
| Q: I'm trying to automate extracting data from a text file. I want to paste the text data into excel, ... A: Did you try finding "pivot-point observed :"? Perhaps you could then delete that text? Or perhaps ... | |
| Excel: How to Autopopulate aftter selection from drop-down menu | 11/8/2007 |
| Q: How does one autopopulate a cell with a price after a user has selected a product from a drop-down ... A: Rachel! I have the perfect example of a workbook like this as a tutorial. It's here: ... | |
| Excel Help | 11/8/2007 |
| Q: I am currently creating a budgeting spreadsheet to calculate monthly bills, due dates, dates paid, ... A: Chad! You simply need to use conditional formatting using a formula. See my article: ... | |
| no less than zero | 11/7/2007 |
| Q: what do I add to my formula so that the answers come back as "no less than zero" I don't want to see ... A: Select all the OTHER columns. Hit Insert-->Name-->Define and give it some one-word name, say ... | |
| Count Question | 11/7/2007 |
| Q: I tried and tried and tried before I bothered you with this question, however, I need help. The ... A: Tina! If you could send me a sample spreadsheet to anne at office articles dot com, I will get you ... | |
| Reconciling Spreadsheets | 11/7/2007 |
| Q: I download 2 excel spreadsheets from 2 different systems. I want to compare certain fields and ... A: Again, Matt...I need more information. You want to compare a column of data from workbook A (or is ... | |
| Making labels out of certain Excel entries | 11/6/2007 |
| Q: My question is: is it possible to go through an Excel spreadsheet and choose certain entries and ... A: Dawn! I am so sorry for the delay in my response. I was over a thousand miles away from my PC. :) ... | |
| Excel option | 11/6/2007 |
| Q: I only know the very basic of Excel. I took a new job and the training is long. Here's the ... A: Cindy! I am so sorry for the delay in my response. I was over a thousand miles away from my PC. :) ... | |
| Help with organizing lists | 11/6/2007 |
| Q: I am an event planner who plans a variety of different types of events. I am creating a supply box ... A: Crystal! I am so sorry for the delay in my response. I was over a thousand miles away from my PC. ... | |
| Copying a Drop-down list | 11/6/2007 |
| Q: So I've made a drop-down list and referenced it to a field (say a1:a18). I wasn to copy this DDL and ... A: Barrett! I've never heard of that. However, try changing your dropdown list to a named range, such ... | |
| calculating due dates | 11/5/2007 |
| Q: I am running excel 2003. I have a start date in my first cell and wish to have a due date in the ... A: Scott! I am so sorry for the delay in my response. I was over a thousand miles away from my PC. :) ... | |
| Autofill of other worksheets from master | 11/4/2007 |
| Q: I think you may have helped me with this in the past. I have a monthly report which I generate from ... A: Patrick! I am so sorry for the delay in my response. I was over a thousand miles away from my PC. ... | |
| Logic function | 11/2/2007 |
| Q: . . I'm trying to write a function in a cell that will test conditions in 3 columns and display the ... A: Lee! I am so sorry for the delay in my response. I was over a thousand miles away from my PC. :) I ... | |
| excel data coming from company reporting system | 11/1/2007 |
| Q: data is presented into excel as: a1 = title of first product b1 = department using product b2 = ... A: David! I am so sorry for the delay in my response. I was over a thousand miles away from my PC. :) ... | |
| Excel hyperlink problems | 10/29/2007 |
| Q: I have a spreadsheet with approximately 12,000 entries. All entries are hyperlinked to .pdf files. ... A: Linda. I would definitely have to see the file to understand the exact differences. I am leaving in ... | |
| Overtime formula | 10/25/2007 |
| Q: I am creating a timecard spreadsheet for my employees and within this spreadsheet I have an area on ... A: Steve. This is Chip's site index, which you might want to bookmark: ... | |
| Simple (I hope) excel question | 10/25/2007 |
| Q: I have a worksheet (ALPHA)with Column A names, linked to a different worksheet (ZEBRA). The ... A: Sometimes, I have to create a worksheet to get the answer, so I've loaded them up here to give you a ... | |
| Copy/paste macro | 10/25/2007 |
| Q: Here is my problem. I have about 31 columns [representing days] and about 20 thousand records ... A: Rick: This is NOT a good way to do what you want. You should use Access, which is much better at ... | |
| Copy/paste macro | 10/24/2007 |
| Q: Here is my problem. I have about 31 columns [representing days] and about 20 thousand records ... A: That's a VERY bad idea, Rick. Try the following features before you decide to do it your way: ... | |
| Text macro/ function question | 10/24/2007 |
| Q: I have a customer email list of over 2600 emails I keep in Excel. It has 4 columns, with email ... A: Jeff. In Cell E2 (which should be blank?), try this: =if(right(a2,14)="@bellsouth.net","NO","") ... | |
| Excel copy1 paste10 | 10/23/2007 |
| Q: There is probably a simple solution to this problem that I am not seeing right now. I would like to ... A: Not sure I understand. Why not have this in B: =A1 =A1 =A1 (ten times all the way to cell B10) =A2 ... | |
| combine vlookup and if statment | 10/23/2007 |
| Q: I have a "master tab" that will feed data into other tabs. On the other tabs i'm looking to do a ... A: Melissa: Excel is not designed to do this--it requires VBA to do it "perfectly". If you want to view ... | |
| Excel acting up | 10/23/2007 |
| Q: Good Afternoon Anne. I have what I think is a basic question. I developed an excel spreadsheet ... A: Is this occurring in ONLY this workbook? Or in every workbook? If every workbook: ... | |
| Excel formula | 10/22/2007 |
| Q: I an excel file that lists a number of students from various universities that are part of an ... A: Several ways: One is to use SUMIF. See this article: ... | |
| Date | 10/18/2007 |
| Q: Anne - I have a spreadsheet set up with a Formula that will automatically enter today's date. ... A: I tried to help by providing a link. No such animal appears to exist. So, here goes. What you need ... | |
| help | 10/17/2007 |
| Q: Good morning, i need a "if" statement that will return a "0" instead of #VALUE!. Here is my formula ... A: You can learn how to do this with my article and the ISERROR formula. :) ... | |
| Excel Linking | 10/12/2007 |
| Q: I have two excel worksheets. Sheet 1 is a list broken down by Salesperson/Company. Each Salesperson ... A: Jess: Any Excel expert will tell you that having the same data twice in a workbook is totally bad ... | |
| Data Layout for printing | 10/10/2007 |
| Q: I have a list with 3 columns and would like to the printout to show 2 horizontal sets of these 3 ... A: The absolute best way is to copy it into Word and Format-->Columns and choose 2 columns. I don't ... | |
| Retrieving desired numbers combinations | 10/8/2007 |
| Q: I need to join few colums:with the following info: e.g each cells in excel with their respective ... A: Try this, Michelle: =text(A2,"00")&"."&text(B2,"0000")&"."&text(C2,"00") This will work only if ... | |
| Excel Help | 10/8/2007 |
| Q: In one of my Cells, I want to display this 10/06/07 thru 10/09/07. What I'm trying to do is on a ... A: Try this, Ryan. Select the cell that contains your Arrival Date. Hit Insert-->Name-->Define, and ... | |
| COUNTIF | 10/7/2007 |
| Q: I'm doing a fast track course in ICT so I'm only in year 10 and basically a beginner in Excel. I was ... A: Right here, Noor: http://www.officearticles.com/excel/index.htm I'm not sure if you need to COUNT ... | |
| DCOUNT Formula | 10/3/2007 |
| Q: This is my dilemma. I have a spreadsheet where I need to know how many items were submitted between ... A: If it was me, I would put the two dates in two columns, then hide those columns. :) Yes...you need ... | |
| Concatenate | 10/3/2007 |
| Q: -). Right now we are manually entering the colors for each date, but I am trying to automate the ... A: Okay, but WHAT determines red or black? If you can determine it and format it manually, we can ... | |
| Concatenate | 10/1/2007 |
| Q: Is there a way to include colored font in concatenate functions? For example I'm working with dates ... A: Functions don't color fonts, only formatting does. However, you can try conditional formatting using ... | |
| Excel 2004 | 10/1/2007 |
| Q: Hey, Right, firstly i'm sorry for asking what is almost certainly an incredibly basic question, ... A: Sounds like you have scroll locking on? On my Windows keyboard, it's a key much like NumLock or ... | |
| Tax % | 10/1/2007 |
| Q: I asked Craig for some help but he is unavailable for follow up questions. I hope you can help me ... A: Brian: I think I can help with this, but I probably would not approach it in the same manner, and I ... | |
| Protecting worksheet formulas -flexible formating | 10/1/2007 |
| Q: I wish to protect some formulas in a number of worksheets but allow users to insert/ delete cells( ... A: To my knowledge, you must create macros (you can put buttons for them on a toolbar) that will: ... | |
| Excel formula | 8/10/2007 |
| Q: I am rather new to formulas. Here's what I need to do: "If <5.0% then 8, if 5.0% to 6.4% then 12, ... A: Problems: First of all, 5.0% is not a value but a calculation. But .05 *is* 5 percent and it's also ... | |
| 98 version to 2003 version | 8/10/2007 |
| Q: How are you doing? I have a question regarding the MS Excel versions 98,200, and 2003. I'm working ... A: That's a loaded question, Ken. There are many differences. The best thing to do is to develop in the ... | |
| Check for multiple entries within a column | 8/9/2007 |
| Q: You were so helpful with my last question, I was hoping to get a little more assistance from you... ... A: Try this, Karen. If nothing else, you'll learn a cool feature of Excel. :) Data-->Subtotals. For ... | |
| Excel Formula | 8/7/2007 |
| Q: I am trying to write a conditional formula where a certain number is tested to be in one of two date ... A: I can never get these to work either, Chris. I always end up putting the dates in cells, then ... | |
| Average formula coming out wrong | 8/6/2007 |
| Q: I havea database that has a button that when pushed opens up an template (excel template) and fills ... A: Why doesn't =AVERAGE(A2:A12) work for you? This should not count empty cells. Anyway, try this... ... | |
| IF statements | 8/4/2007 |
| Q: I am using a formula to tell me who, B1,B2, ect. that has a total of less than 16, ... A: You might want to instead use conditional formatting using a formula. Then you can SEE who has not ... | |
| percentage | 8/3/2007 |
| Q: I tried =IF(ISERROR(C74/C43),"",C74/C43) as well as =IF((C74/C43),"",C74/C43) to find the ... A: Okay, Judy. Maybe it's the way you're saying it (or I'm saying it), but: If GROCERY is in A2 and ... | |
| Worksheet Arrangement | 8/3/2007 |
| Q: Is there a way to arrange only the worksheets within one workbook? I want to tile worksheets ... A: Here's a little exercise to teach you how: Open a new, blank workbook. Hit Window-->Arrange, Tiled. ... | |
| Rounding numbers to NEAREST 100 | 7/8/2007 |
| Q: I am helping a co-worker with this. We need to round whole numbers (currency) in a single column to ... A: I hope you've found your answer by now and apologize (profusely!) for the delay in responding. Just ... | |
| LOOKUP function | 7/7/2007 |
| Q: I have a sheet of data that contains unique numbers in column A, several identifying sets of data in ... A: Jeff. I hope you got your solution by now, and I'm really sorry I'm so late in responding. I moved, ... | |
| time | 7/6/2007 |
| Q: I am currently working on a spreadsheet that calculates elapsed time for a mill. my hope is that ... A: Nick: I'm so sorry for a late reply. I hope you got an answer by now, but just in case... You MUST ... | |
| Conditional formatting | 7/6/2007 |
| Q: Anne I have a row of cells (c8:m8) which i want to conditionally format red for the max values, ... A: No apologies! I'm sorry to be so late responding! I moved and forgot to put myself on ... | |
| consolidation/combining worksheets | 7/5/2007 |
| Q: I have four little worksheets that all have the same data, but just for different sales rep. I want ... A: Don't put them all on different sheets. Instead, put them on one worksheet. You'll probably have to ... | |
| Help with Excel formula | 7/5/2007 |
| Q: I am using Microsoft Office Excel 2003 I need a formula that will count if people in a column are ... A: You'll have to change the referenced cells, but try this: =SUM((A2:A10="F")*(LEFT(B2:B10,1)="5")) ... | |
| Exporting Labels to Word | 7/4/2007 |
| Q: I’m trying to compile a mail merge from Excel exported to Word to print mailing labels. I’ve read ... A: 1: See: http://www.officearticles.com/word/mail_merge_labels_in_microsoft_word.htm What it sounds ... | |
| Help with Excel formula | 7/4/2007 |
| Q: I am using Microsoft Office Excel 2003 I need a formula that will count if people in a column are ... A: You can't really use asterisks in formulas like that. Please give me a *real* sample of some data so ... | |
| Excel | 7/4/2007 |
| Q: I was sent information on an Excel spreadsheet that used Excel 2003, via email. I have Windows XP ... A: >>>How do I do this? You must purchase the program. Microsoft Excel is not free. You can download ... | |
| Find Last Date Occurrence | 7/3/2007 |
| Q: I am working on a checkbook application. I am looking for a formula that will find the last ... A: Yep. I don't know how to do it without VBA, Thomas. And I don't really do VBA, but it has to do with ... | |
| Excel Data Entry | 7/2/2007 |
| Q: Anne: Is it possible to create a form in Excel and require the user to complete certain fields ... A: This should get you on your way, Christopher. You'll likely need to alter it a bit, so you might ... | |
| Moving Row(s) Of Data | 7/2/2007 |
| Q: Newbie here! My wife and I (just recently decided) would like to keep track of where our money goes ... A: Robert: If you could send me even a sample of your workbook, I can probably help you a great deal. ... | |
| format excel column | 7/2/2007 |
| Q: I keep a coin catalog on excel. Some of the dates includes letters in addition to the numbers. ... A: I understand the problem...used to sell coins on eBay. :) As soon as you enter a letter, Excel sees ... | |
| execl time rounding | 6/29/2007 |
| Q: Now that I have Time formula B1-A1=C1 (Clock out 10:33 PM - Clock In 1:05 PM)=24*B1-A1 (9.417) How ... A: Try the MROUND function, Joe. You'll need to turn on the analysis toolpak to make it available for ... | |
| 2 Range comparisons | 6/28/2007 |
| Q: Another expert answered a problem very similar to mine and i will link it here for you to quickly ... A: So, Yakov, I would say that it would be best to first make a table, like this: Col A Col B YJC ... | |
| Generating a Random Sample | 6/26/2007 |
| Q: I was wondering if you could provide some information on random samples. I would like to use Excel ... A: Lesley: I think you need to see Tushar Mehta's RANDOM page: ... | |
| Two conditions in IF formula | 6/26/2007 |
| Q: Would it be possible to have 2 conditions in an IF Formula? I'm currently working on scorecards for ... A: Nat! You don't want an IF statement, tho you CAN use one that has up to 7 NESTED (or 8 total) IF ... | |
| formatting | 6/26/2007 |
| Q: I would like to add a conditional format that changes the name, county, and current year in cell b7 ... A: First, I'm not sure if name, county and current year in cell b7 is ALL that exists in B7. You can't ... | |
| a summary of all the functions in Excel 03 | 6/26/2007 |
| Q: I just inquiring is there anywhere I can get a summary of all the functions in Excel 03. A: Sure. First, make sure you are viewing the formula bar. Then hit the fx symbol on the formula bar, ... | |
| Formula to find numbers within a cell containing text, numbers and spaces. | 6/25/2007 |
| Q: Ms. Troy, I need a formula that will locate only numbers within a text/number cell (i.e. HSS 3x2 ... A: This would create a HORRIBLE formula, Rose, if it can be done at all. Two suggestions: 1. Split ... | |
| 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: Why do you have to do it manually? When are the sales figures in column C entered? Can you put a ... | |
| Copying to other sheets by date range | 6/24/2007 |
| Q: Anne, I have a list of persons as row names, each person seperated by about 10 rows to allow entry ... A: >>>That makes it difficult to have all visits to to one doctor in one row No...you would want ... | |
| Copying to other sheets by date range | 6/23/2007 |
| Q: Anne, I have a list of persons as row names, each person seperated by about 10 rows to allow entry ... A: That's a bad layout to be able to properly use Excel's features. You need to have all records have ... | |
| copying in excel | 6/22/2007 |
| Q: We have already copied several sheets in a workbook, I would like to add one more thing to each ... A: As long as you want to add information to the same cells in all the sheets, go to the first sheet, ... | |
| excel 2000 or xp | 6/21/2007 |
| Q: I would like to know if this is possible. I have one excel spreadsheet which is a master list that ... A: I'd rather see your workbook (or a real close example) before I answer further. You can send to anne ... | |
| payroll s/s in excel | 6/19/2007 |
| Q: ok, i have set up a payroll spreadsheet. boss wants one sheet for each day, plus a total sheet. ... A: Bridgette. Virtually every payroll worksheet question is already answered at Chip Pearson's site: ... | |
| excel auto fill in | 6/19/2007 |
| Q: online I found a form with your name in the properties (it was called Order Form). In this form, you ... A: Melinda! My tutorials are here: http://www.officearticles.com/tutorials/ The one that goes with ... | |
| Microsoft Excel - Linking of worksheets | 6/16/2007 |
| Q: I need to know, how I can link multiple workbooks in following way: A master file consists of ... A: Copy from A01's individual workbook. Go to the master workbook. Hit Edit-->Paste special-->Paste ... | |
| linking worksheets | 6/12/2007 |
| Q: I have a spreadsheet which has about 15 columns. There are roughly ten sorts I have to do every ... A: >>How would I link the various worksheets to the master sheet or table? Is this the best way to go? ... | |
| Printing a range on each page of data | 6/11/2007 |
| Q: I need to sub-divide and print the data across multiple pages. That is the easy part. The part I'm ... A: Corinne, I'd really have to see the document to answer completely and accurately, but consider ... | |
| "Date" format not working on the cells | 6/11/2007 |
| Q: In my excel workbook, I've a column with dates in DD/MM/YYYY format. Even though I formatted this ... A: I need to see your workbook to know for sure. You can send it to anne at office articles dot com. It ... | |
| Roundup function in Excel 2000 Professional | 6/8/2007 |
| Q: I have tried to use the roundup function, and no matter how I format the value...it does not work ... A: Create a brand new workbook. In cell A1, type the following: =ROUNDUP(32.44,0) and hit enter. The ... | |
| excel | 6/7/2007 |
| Q: i have a question regarding excel I have a spreadsheet that displays the project names is it ... A: It seems to me that you just need to learn a couple of features of Excel. They are: Autofilter: ... | |
| Combine multiple lists | 6/7/2007 |
| Q: Each week I get a summary of usernames and the number of broken links they are responsible for on ... A: Yeah...I understood what you wanted. Sorry. I kind of ignored it because your way is NOT how I'd do ... | |
| Combine multiple lists | 6/6/2007 |
| Q: Each week I get a summary of usernames and the number of broken links they are responsible for on ... A: Yuck. I don't see any FAST way to do this, unless you can record macros. Please read my entire ... | |
| Data Entry Form | 6/5/2007 |
| Q: Greetings. I am somewhat familiar with Excel. I work for NYS, which means that much of my exhaustive ... A: 1) Tools-->Macro-->Security. Set it to Low. 2) Hit Alt+F11. Double-click ThisWorkbook on the left. ... | |
| Data Entry Form | 6/5/2007 |
| Q: Greetings. I am somewhat familiar with Excel. I work for NYS, which means that much of my exhaustive ... A: Ooohhh, bad form on your layout, Patrick. No skipping rows or columns! :) Use row height instead or ... | |
| Data Entry Form | 6/4/2007 |
| Q: Greetings. I am somewhat familiar with Excel. I work for NYS, which means that much of my exhaustive ... A: Okay, try this: Open your workbook. Hit Alt+F11. On the left-hand side, double-click ... | |
| drop down list | 6/3/2007 |
| Q: I have a list of farms name (drop down)in my form and i want to be able to get the address for each ... A: You said you'd like " a small instruction". The instructions are at this link (which I gave before): ... | |
| Calculating number of weekdays between two dates | 5/30/2007 |
| Q: I am looking for a way to calculate the number of weekdays between two dates. We have to report ... A: You need the NETWORKDAYS formula. Don't think of it as NETWORK DAYS, but as NET WORKDAYS. :) For ... | |
| onclick of a cell in excel to run a lookup | 5/30/2007 |
| Q: I am putting together a workbook that contains input from a usability card-sorting exercise. The ... A: It's called a worksheet change event. Here's Chip Pearson's change event to change entered data to ... | |
| Conditional formatting question | 5/30/2007 |
| Q: I wanted to ask you a quick question related to conditional formatting. If I have the following row ... A: Hm. I thought that it would be easy, but I see your frustration. I'm using =MIN($B$2:$F$2) as a ... | |
| Excel formula | 5/27/2007 |
| Q: I'm trying to find if a formula can only be executate one time and once a save is made on the sheet ... A: Is it always the same five cells, i.e., A5:A10? Or does it change? If it's ALWAYS the same five ... | |
| Excel highlight box | 5/25/2007 |
| Q: Someone at the company changed the black outline of the highlight box marking the cell with the ... A: Okay, I've gone and asked. Here's the answers I got. __________________ Tim Critchley: It's a new ... | |
| Excel 2003 email links | 5/25/2007 |
| Q: I have a list which contains email addresses in one column of the spreadsheet. Each time I click a ... A: Two solutions. 1. HOLD your mouse pointer down after clicking to keep it from following the ... | |
| colors in excel | 5/24/2007 |
| Q: i have a workbook with dates PROJECTED and ACTUAL in columns side by side.. with different steps to ... A: >>>Is this even possible to do with an entire worksheet without having to enter the conditional ... | |
| Excel 2003 data series problem | 5/22/2007 |
| Q: my question is about the "format data series" window that pops up with you double-click on a "data ... A: The only thing I can suggest is that you run Excel troubleshooting while logged in as the user. See: ... | |
| Excel | 5/15/2007 |
| Q: I would like to format a cell to look at another cell that has length and width in inches and then ... A: Sorry to take so long. GOT IT!! It's VERY cool. Open your workbook, save a copy. Hit Alt+F11 to ... | |
| Macro help with excel 2003 | 5/15/2007 |
| Q: I have a pretty large spreadsheet of sampling vegetation. Each Row has formulas built into various ... A: From our other AllExperts Expert, Tom Ogilvey, try this: ... | |
| Excel | 5/14/2007 |
| Q: I would like to format a cell to look at another cell that has length and width in inches and then ... A: Jo. That would NOT be a format, that would be a calculation. I suspect you may have a cell that says ... | |
| Excel Formula | 5/11/2007 |
| Q: I have question for vlookup formula with conditional formatting.Vlookup formula works in sheet but ... A: Vlookup would not work with conditional formatting. vlookup is not an IF statement, it returns a ... | |
| is there a way to link a cell to a different worksheet? | 5/11/2007 |
| Q: Good Morning Anne. I am trying to create a way of clicking on information contained in one cell and ... A: It most certainly DOES apply. I have a beautiful 24-year-old daughter. Thanks! I believe that the ... | |
| is there a way to link a cell to a different worksheet? | 5/10/2007 |
| Q: Good Morning Anne. I am trying to create a way of clicking on information contained in one cell and ... A: Anaeli: Assuming your sheet names are named for each person, try an automatic "table of contents", ... | |
| Excel Clipboard | 5/9/2007 |
| Q: I'll bet this is an easy question for you. Hope so. When I'm working in Excel and do several copy ... A: Carl. I hate the Office clipboard as well. And I get rid of it for good... Please ALWAYS provide ... | |
| Linking data from one worksheet to another | 5/9/2007 |
| Q: I would like to get data from one worksheet and put it in another worksheet using the "IF(AND(" ... A: Right. You cannot return multiple values in multiple cells using a formula in ONE cells. You CAN put ... | |
| Colors in Excel | 5/9/2007 |
| Q: I cannot get the colors I designate for certain cells to hold. I double-click on the cell, click on ... A: Susan: Make SURE you don't have some kind of conditional formatting on those cells, first, okay? ... | |
| Changing the color | 5/9/2007 |
| Q: Good morning, I am trying to use the conditional formatting tool to change the color in a given set ... A: Sarah, this is tough to do without cell references and values as an example, but I'll try. :) ... | |
| Excel lookups | 5/4/2007 |
| Q: I'm looking for a method/shortcut to lookup amounts that have to be combined from other amounts ... A: Hendrik. This is no easy task in Excel...or any application for that matter. The closest I have ever ... | |
| auto entry of date | 5/3/2007 |
| Q: i have a simple spreadsheet of 5 columns. it is an inventory of real estate lock boxes. col A is the ... A: Marc! Knowing this is a worksheet change event (I just happen to know that), I looked that up. Then ... | |
| Excel Date Problem | 5/3/2007 |
| Q: I would like to enter a date in a cell but when I enter 5/3/07 the cell shows =5/3/7 no matter what ... A: So...are you going to email it? I don't care about the links. Just give me (in the email) a few of ... | |
| Excel Date Problem | 5/3/2007 |
| Q: I would like to enter a date in a cell but when I enter 5/3/07 the cell shows =5/3/7 no matter what ... A: I do not know why it would do that, Rick. You say "no matter what I do", but that doesn't tell me ... | |
| FORMULA | 5/2/2007 |
| Q: Do you have an Excel formula that would calculate how many months, between 2 dates, there are as ... A: I'm not sure what you're asking, Mario. Could you tell me what is in a cell (and the cell it's in) ... | |
| cell references in VLOOKUP applications | 5/1/2007 |
| Q: I am hoping you may be able to help me with 2 problems I am having. I have a table with the first ... A: First question is handled by the 4th argument in a VLOOKUP. I explain it here (see the graphic): ... | |
| Excel 2000 | 4/27/2007 |
| Q: Looking to key into a cell a certain code or filename that automatically inserts a graphic. I would ... A: I hate to choose the "beyond my expertise..." for a question like this, but it IS. However, I like ... | |
| Conditional Formatting | 4/25/2007 |
| Q: How are you doing. I hope you can answer my question. Please refer to ... A: Roy, I'm sooooo sorry to take soooo long answering your question. My mother is dreadfully ill and I ... | |
| Excel Macro | 4/18/2007 |
| Q: I worked in a production company. We have lists of our products in Column A, then price and other ... A: How much protection do you want? See: ... | |
| Using AND with Dates | 4/17/2007 |
| Q: How do I use AND with Date functions? I am using MS Excel 2000. In one cell, F8 I have entered a ... A: The problem is this... Unless you enter an actual DATE into a cell, Excel cannot determine the ... | |
| Macro code for next row | 4/16/2007 |
| Q: Kindly check belwo mentioned macro and kindly advise how i can add eachtime the data to next blank ... A: Ganesh. I believe this will do what you need, though I removed some extra things like your ... | |
| Figure Time Left for Assigned Tasks | 4/15/2007 |
| Q: I am making a workbook for record keeping, which includes a worksheet for "Assigned Tasks" for ... A: Paul. See my sample file called tasklist.xls here: http://www.officearticles.com/excel/samples/ ... | |
| 0's in a general column | 4/13/2007 |
| Q: I have an excel document with a column that I am entering four-digit numbers into that all start ... A: They need to be entered as text. The best way to do that? Select the column you're entering these ... | |
| Assign value | 4/13/2007 |
| Q: col headers and data look like this Categoy 1 Caterogy 2 Caterogy 3 Total Score High ... A: Assuming your Category 1, 2, and 3 columns are Columns A, B, and C, try this: ... | |
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
Excel
Answers by Expert:
- Mary A. Lindsey
- Nathan Head
- Raj Narayan Banerjee
- Chad Welch
- Ken Cowen
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bill Hermanson
- Jerry Beaucaire
- Michelle Howell
- Isaac
- Edward H. Mori
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- JP
- Richard Rost
- Victor Lan
- Tushar Sakhalkar
- Philip Buckley
- David W. Cofer
- Amal
- Bob Umlas
- Jessica L.
- Shahid
- Jan Karel Pieterse
- Craig
- Adelaide carvalho
- Sixthsense
- Bill
- Anne Troy
Anne Troy
Top Expert on this page
Expertise
Virtually all common questions about Microsoft Excel, including all versions. Help with formulas, functions, optimum data layout, and application management. Please: No VBA or macro questions.
Experience
I taught Advanced Microsoft Excel to the senior accountants at the Environmental Protection Agency. Let's hope they were listening.
Publications
Dreamboat on Word
Office VBA: Macros You Can Use Today
Education/Credentials
Self-taught and worked with the best in Microsoft Office applications.
Awards and Honors
Microsoft Word MVP 2008
©2012 About.com, a part of The New York Times Company. All rights reserved.