You are here:
Excel/Questions
| Subject | Date Asked | Expert |
| Conditional formula to return a "Yes" or a "No" | 2/8/2012 | Tom Ogilvy |
| Q: I think this might actually be two separate questions. Hopefully I am not making this too ... A: Jess =IF(COUNTIF(Sheet2!$A$1:$A$5,A2),"YES","NO") if the value is not there countif returns a ... | ||
| Consolidating hours tracked over several projects | 2/8/2012 | Tom Ogilvy |
| Q: Tom, I am trying to consolidate some data in Excel which is being used to track coverage over ... A: Neal, assume your project names can be in A2:A12 and there there will be no empty rows in that ... | ||
| combine excel generated macro code with other VBA code | 2/8/2012 | Shahid |
| Q: Shahid, Tahnk you for all your earlier help, and your fast responses. I am still having trouble. ... A: You need to do two things before anything else... first figure out where the user wants the data to ... | ||
| Userform Cell Fill | 2/8/2012 | Tom Ogilvy |
| Q: I have created a button that unhides several rows and opens a user form which allows the user to ... A: Keegan, If I can depend on column C to be able to tell me the next place to put the data Private ... | ||
| Excel Custom Lists | 2/8/2012 | Isaac |
| Q: We run a SQL query which produces a list of many company names. I filter it in Excel. The filter ... A: * I understand you're not a programmer (I'd hardly call myself one, just discovered that excel vba ... | ||
| Excel Custom Lists | 2/8/2012 | Isaac |
| Q: We run a SQL query which produces a list of many company names. I filter it in Excel. The filter ... A: * You can use VBA to accomplish this. there are many ways to accomplish the same thing, but this ... | ||
| Excel - Hide #N/A | 2/8/2012 | Aidan Heritage |
| Q: When using the index function if no result is found the cell shows #N/A. Is there any way to hide ... A: I can think of a couple of ways - one is to use conditional formatting to simply hide cells in the ... | ||
| Excel Help | 2/8/2012 | Richard Roberts |
| Q: I have a short list of question for you. Hope you can clear my doubt. 1) Is it possible to ... A: Chan I am not sure what you mean by your first question. Second question--If you make your list ... | ||
| Excel Help | 2/8/2012 | Shahid |
| Q: I need your help regarding some questions How to formate my spreedsheet in a way that a message box ... A: Data Validation, as the name suggests is just that... validate data as per the given condition. In ... | ||
| Macro copy values from page A to page B | 2/8/2012 | Shahid |
| Q: Shahid, I use an older system. I use XP and Excel version 2002. Up until now it has more than met ... A: Your code is very confusing for me to follow. Please reply back again with your desired action post ... | ||
| Formula for contain? | 2/8/2012 | Jerry Beaucaire |
| Q: just want to ask, Is there a formula for contain? For example, I extract the data from my system, ... A: <i>"How to I make the cell return a False if the cell does not contain these words or word?"</i> ... | ||
| Excel Help | 2/8/2012 | Shahid |
| Q: I need your help regarding some questions How to formate my spreedsheet in a way that a message box ... A: Have you tried data validation? In recent Excel version, this is under the Data menu. You can ... | ||
| Number to Words | 2/8/2012 | Bob Umlas |
| Q: I have a macro query. if I type 123 in A1, it should automatically Display "ONE TWO THREE" in B1. it ... A: Right-click the sheet tab, select View Code, enter this: Private Sub Worksheet_Change(ByVal Target ... | ||
| Need a macro to close file without saving | 2/8/2012 | Tom Ogilvy |
| Q: Now I'm using this coding "ActiveWindow.Close" to close the file. So whenever I run the Macro there ... A: Jayendran Activeworkbook.Close Savechanges:=False as the last command should not elicit a prompt. ... | ||
| Sum of total within date? | 2/8/2012 | Tom Ogilvy |
| Q: I have a list of data, example as below 01/01/2011 $50 01/01/2011 $60 02/02/2011 $70 03/02/2011 ... A: Chan, Sumif is the best function from my perspective =Sumif(A:A,">="&C1,B:B)-Sumif(A:A,">"&D1,B:B) ... | ||
| replace data entered with.... | 2/7/2012 | Jerry Beaucaire |
| Q: I'd like to format cells (assuming I have to format them not use a formula) so when I enter in data, ... A: In your row 3 "matching table" I see "D" listed twice. Shouldn't one of those be "B"? Assuming ... | ||
| Macro to sort columns | 2/7/2012 | Bob Umlas |
| Q: I am in need of a macro that will select several columns in one sheet, create a new sheet and copy ... A: Sub Shawn() Range("A:C,F:F,J:K").Copy Worksheets.Add.Name="ENTER NEW NAME HERE" '<====answer ... | ||
| how to calculate time | 2/7/2012 | Michelle Howell |
| Q: I have sent up a simple work sheet to calculate time/hours worked from our subcontractor, it was ... A: Not sure why this is happening. Are you trying to copy cells or copying the whole Excel tab? When I ... | ||
| Macro copy values from page A to page B | 2/7/2012 | Shahid |
| Q: Shahid, I use an older system. I use XP and Excel version 2002. Up until now it has more than met ... A: You data can be manipulated just as you would manipulate normally. I learnt using the "Record Macro" ... | ||
| Index formula using cell value for sheet reference | 2/7/2012 | Aidan Heritage |
| Q: I am having major problems with naming macros and editing them. The macro name will disapear then ... A: Sorry, mistyped the brackets - I've done it in excel rather than trying to type it this time - try ... | ||
| Conditional Format | 2/7/2012 | Bob Umlas |
| Q: Have you any ideas how this could be done? A: Can easily be done with conditional formatting. If you don't know how to do that, it's pretty hard ... | ||
| Macro to sort columns | 2/7/2012 | Bob Umlas |
| Q: I am in need of a macro that will select several columns in one sheet, create a new sheet and copy ... A: This macro assumes you want to copu columns A:C,F,J:K -- adjust to suit. It will put them together, ... | ||
| Macro copy values from page A to page B | 2/7/2012 | Shahid |
| Q: Shahid, I use an older system. I use XP and Excel version 2002. Up until now it has more than met ... A: I assume you know some vba basics for macros. The code you need is as below... Range.Copy [Dest ... | ||
| replace data entered with.... | 2/7/2012 | Jerry Beaucaire |
| Q: I'd like to format cells (assuming I have to format them not use a formula) so when I enter in data, ... A: It would you to install a macro into your workbook for it to change your typing in a specific column ... | ||
| counting colored cells in a spreadsheet | 2/6/2012 | Aidan Heritage |
| Q: how are you? I want to count the number of colored cells in a spreadsheet.By googling, I quickly ... A: my email is aidan.heritage@virgin.net - just in case that helps (a means of getting a file to me for ... | ||
| excel macro | 2/6/2012 | Tom Ogilvy |
| Q: I need to write a line of code in vba, that would perform a certain action in a row, where the cell ... A: Kuba, You can use this to get the last cell in a column that is not blank Dim r as Range With ... | ||
| military time spread sheet | 2/5/2012 | Richard Roberts |
| Q: I am trying to extract emergency department times to certain events--- ie admission to ... A: Laura Time is always tricky to work with because of the hours days, etc are not easy for us to ... | ||
| Using End(xlDown) to select a range | 2/5/2012 | Tom Ogilvy |
| Q: I have this macro which selects data beginning in range A1 of each worksheet in CurrentWB and copies ... A: Carry, Sorry - I wasn't focused on anything but the question at hand. ... | ||
| Top 20 Data Return | 2/5/2012 | Tom Ogilvy |
| Q: I have a range of data, which has people's scores for competitions, for the overall competition i ... A: david Dates in A1:A5000 ID's in B1:B5000 Scores in C1:C5000 ... | ||
| Using End(xlDown) to select a range | 2/5/2012 | Tom Ogilvy |
| Q: I have this macro which selects data beginning in range A1 of each worksheet in CurrentWB and copies ... A: Carry, Unless copying an entire column or even a blank entire column is causing a problem, then I ... | ||
| Top 20 Data Return | 2/5/2012 | Tom Ogilvy |
| Q: I have a range of data, which has people's scores for competitions, for the overall competition i ... A: david, Assume names are in A1:A5000 and scores are in B1:B5000 next to the corresponding name. ... | ||
| Nested formula in Excel | 2/4/2012 | Ken Cowen |
| Q: Sir,600 peoples are working under me.I put all the members in 600 raws by column A for serial no. ... A: Md. Ferdous You need to look into using the VLOOKUP function. Basically, if your data is in ... | ||
| find and replace | 2/4/2012 | Jerry Beaucaire |
| Q: ...hope you fine.. suppose my excelsheet contains 500 rows of data... i want to find multiple words ... A: Yes, you can turn on the AUTOFILTER and filter any column doing a CUSTOM filter for "contains: dog" ... | ||
| find and replace | 2/4/2012 | Ken Cowen |
| Q: ...hope you fine.. suppose my excelsheet contains 500 rows of data... i want to find multiple words ... A: Murali You could write a VBA code that looped through a list of words and searched for them. The ... | ||
| Copy values from non-adjacent cells to a new workbook | 2/4/2012 | Bob Umlas |
| Q: I’m trying to copy (only the values) of a number of non-adjacent cells to another workbook. At ... A: Sub MyVersion() For each x in Array("A1","B2","C3","D4","E5") ... | ||
| Excel Problem | 2/4/2012 | Stuart Resnick |
| Q: my first problem is n the excel sheet, if there is 2 in Column B3,8 in Column C3, 10 in Column D3, ... A: Please ask only one question at a time. I don't understand your first question, so I'll answer the ... | ||
| Excel Problem | 2/4/2012 | Richard Roberts |
| Q: my first problem is n the excel sheet, if there is 2 in Column B3,8 in Column C3, 10 in Column D3, ... A: Pravin In your first question I am not sure if you want the numbers to be horizontal or verticle ... | ||
| Copy row | 2/3/2012 | Tom Ogilvy |
| Q: We have below macro which is copying the row if Column H has any cell colored in ... A: Dev, Probably something like this: Sub ABC() Dim sh As Worksheet, sh1 As Worksheet Dim r As Range, ... | ||
| ListBox not performing as expected/required, Excell 2000 | 2/3/2012 | Jerry Beaucaire |
| Q: I appreciate your time. I have placed a ListBox (from the control toolbox) onto my spreadsheet. I ... A: When crossposting always provide links to the other threads so any one can search the other threads ... | ||
| If Then | 2/3/2012 | Raj Narayan Banerjee |
| Q: I need a basic formula for the following Column 1 has a N or Y in it and I want to have a seperate ... A: Lets say in cell A1 you have either Y or N and in cell A2 you want to convert it to either 1 or 2. ... | ||
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
Tom Ogilvy
Top Expert on this page
Expertise
Selected as an Excel MVP by Microsoft since 1999. Answering Excel questions in Allexperts since its inception in 2001. Able to answer questions on almost all aspects of Excel's internal capabilities. If seeking a VBA solution, please specify that in your question itself so I give you the answer you want. [Excel has weak protection - if you are distributing an application, I don't answer questions on how to protect your project from your users.]
Experience
Extensive experience.
Education/Credentials
Master of Science (MS) degree Operations Research (ORSA)
Awards and Honors
Microsoft MVP in Excel.
©2012 About.com, a part of The New York Times Company. All rights reserved.