| Subject | Date Asked |
|
| 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: ...
|
