You are here:
Excel/Questions Answered by Expert Philip Buckley
| Subject | Date Asked |
| extraxt specified data from a sheet | 10/8/2009 |
| Q: i have a sheet in excel contain two column and several rows. column 1 mark as student name and ... A: Nima, Take the following steps: 1. Add a column labeled "Counter" next to the two other columns ... | |
| Excel | 10/4/2009 |
| Q: I have a column of dates (Month, Day and Year) and want to have excel tell me how many of dates ... A: 1. For the column with the dates, make sure the column has a header labeled "Date" in cell "A1" with ... | |
| If Then Statement in excel 2003 with more than 7 functions | 9/25/2009 |
| Q: Hey there! I am trying to make a long if then statement for a spread sheet I am creating. I have ... A: Ben, Assume that you want to put your solution in cell "A1". You can break up your if statement ... | |
| Formula | 9/16/2009 |
| Q: I have one excel sheet. In that sheet I have entered 10 heading in column wise like B1 is Company ... A: Joseph, The best way to handle such data is using a PivotTable. To use this do the following: 1. ... | |
| Excel 2007 version - backup workbook | 9/6/2009 |
| Q: I am fairly new to Excel. I have information that I want to backup to make sure it does not get ... A: Wynneth, How to make a backup file. 1. Open the file you want to have a backup of. 2. Select ... | |
| sorting out e- mails | 8/12/2009 |
| Q: I have a huge list of clients (names, adress, phone e- mail etc) and i need to sort out all the e- ... A: There are several options: A. Use the sort option (Each Column of Data must have a header) 1. Click ... | |
| Lookup Date Range | 8/3/2009 |
| Q: I have a worksheet (named "master") with a lot rows of data regarding system errors. The first ... A: 1. Add a column to your data labeled "Month" 2. type in this column in each row the following ... | |
| Create a Button in Excel | 7/29/2009 |
| Q: I AM vaibhav from India. I want create a button in excel on which i click it will go on that ... A: 1. Click on the spreadsheet anywhere but on "Sheet 7". 2. Select the "Tools" dropdown menu 3. Select ... | |
| filtering by date | 7/16/2009 |
| Q: I am trying to filter my sales by date. in the date sold column, I have the date formatted as ... A: Before doing this make sure you have a title for each column 1. Click on the database in the date ... | |
| How to find unique value count through Vlookup or by other method | 7/14/2009 |
| Q: I have an Excel 2003 spread sheet. We have one worksheet (Sheet 1 ) that has thousands of rows. ... A: 1. Click somewhere on the data 2. Select the "Data" dropdown menu 3. Select "PivotTable and ... | |
| looking up data dependent on one field | 7/9/2009 |
| Q: I have a table which has: - Name - Gender - Achieved December - Achieved April - Achieved July ... A: This can be done using a "PivotTable" To start a PivotTable take the following steps: 1. For your ... | |
| Excel Time Stamp button | 7/7/2009 |
| Q: I would like to create a button on a spread sheet that when I click it, it will enter the current ... A: The following code in a macro will do this: ActiveCell.FormulaR1C1 = "=NOW()" ... | |
| Sorting Data into Groups (If, then) | 7/5/2009 |
| Q: My question is as follows: I have a language school and would like to organize the data of ... A: For my answer, I put the "Target Level" numbers in column "D" starting in row one. In column "E" ... | |
| Excel 2003 table | 6/25/2009 |
| Q: I have a spreadsheet containing feedback information from training courses that we have run. This ... A: This can be done with a PivotTable as follows: 1. Each column must has a unique header name. Right ... | |
| Nested IF Statements | 6/24/2009 |
| Q: I am trying to find the percentage change between two numbers. I want to throw out all the nonsense ... A: Because of the way QuickBooks works on the "if" "then" order, the best solution I can give you is to ... | |
| Basic Macros involving multiple workbooks | 6/22/2009 |
| Q: I am trying to record a macro that requires several steps in a main workbook where the macro is ... A: Merge all of the files into one file. 1. Open up all of the files 2. Select the "Window" drop down ... | |
| SELECT MULTIPLE LARGE RANGES OF CELLS | 6/20/2009 |
| Q: How do I select all of the following cells: H10-H1000 and L10-L1000 AND P10-P1000 AND T10-T1000 i ... A: 1. Move to the first cell you want to highlight and click on it. 2. Keep your mouse button held down ... | |
| writing to txt file using vba at specific location | 6/16/2009 |
| Q: i need to write some data in an excel file to a text file. I've a macro for this. But the ... A: You can have the data in three columns as follows: 1. Highlight data to be broken out 2. Select the ... | |
| Excel functions | 6/16/2009 |
| Q: I want to create a summary page in excel. So, what i need is, I have 8 columns, column B =customer ... A: 1. Highlight the data 2. Select the "Data" drop down menu 3. Select "DataTable and DataChart ... | |
| Split Cells | 6/12/2009 |
| Q: In Excel 2007 how do I split cells on a spreadsheet. Thank you in advance Barbara A: 1. Select the "Data" drop down menu 2. Select "Text to Columns..." This will bring up the "Convert ... | |
| More than 7 Nested if Statements. | 6/11/2009 |
| Q: The following formula has 7 nested if statements, which works, but I need to keep going with the ... A: Below is how it can be done by breaking up the if statment into several cells. In cell "A1" I ... | |
| Excel find and Replace | 6/11/2009 |
| Q: I need to find and replace all double spaces in a column with single space- e.g. "RU8 4SF" needs ... A: Andy, 1. Highlight the cells you want to change 2. Select the "Edit" drop down menu 3. Select ... | |
| multiple reference | 6/10/2009 |
| Q: any help you could give me would be much appreciated. I'm trying to count or sum based on multiple ... A: This can be done with a Data Table: 1. Select the "Data" drop down menu 2. Select "PivotTable and ... | |
| best regards | 6/10/2009 |
| Q: Greetings, after My question is how to use (if rule) to calculate more than 7 times of (if rule) ? ... A: Break the if statement up into two cells. A simple sample is shown below to show the principle: In ... | |
| Conditional formatting | 6/9/2009 |
| Q: How do I get cells A1,B1,C1 to change colors on a specific date listed in cell E1 and then again in ... A: First the cells in "A1" "B1" and "C1" must be formatted. To do this take the following steps: 1. ... | |
| Reading data from one excel to aanother througha macro | 6/8/2009 |
| Q: I am new to this excel world, i have a question, i need to access two columns in excel file A by ... A: 1. Have both "file A" and "file B" open 2. Select "file B" 3. Start a new macro as follows: - ... | |
| Macro | 6/5/2009 |
| Q: I am trying to record a macro where a formula fills in for all rows in a given column on the sheet, ... A: Jackie, If your data has no gaps you can add the following steps to your macro. 1. Select the ... | |
| Counting the number of occurances, based on 2 criteria | 6/4/2009 |
| Q: Good morning. I realize this is probably a very BASIC question, the solution has been plaguing me ... A: Albert, First you need to add two columns to your spreadsheet. Label one "Month" and the other ... | |
| pivot table | 6/3/2009 |
| Q: I have a pivot table, regarding donor information, arranged by name, dates of gifts, and gift amts. ... A: Sarah, Ok, How about this. 1. Go the the tab with all of the data 2. Make sure you have a title ... | |
| multiple tables | 6/3/2009 |
| Q: I have a set of four tables, each contains 4 coloums and 10 rows. The row are the names of the ... A: This is simple but involves many steps. 1. Add a column called "PRODUCTS" then change the name of ... | |
| pivot table | 6/3/2009 |
| Q: I have a pivot table, regarding donor information, arranged by name, dates of gifts, and gift amts. ... A: Yes as follows: 1. Highlight the column (or row) in the pivot table that has the dates 2. Select ... | |
| Excel 2007 - how to add up only specific fields in an excel spreadsheet | 6/2/2009 |
| Q: My spreadsheet contains columns of mixed data which I then need to subtotal: Currency fields (e.g. ... A: Sally, 1. Add a column labeled "TYPE" 2. In this column for each row that has pounds in it type ... | |
| Date // Q | 6/1/2009 |
| Q: How do you format a cell so you only have to type in the number of a date? I have seen where a cell ... A: 1. Select the cells you want to format 2. Select the "Format" drop down menu 3. Select "Cells" This ... | |
| Cummulative sales | 5/30/2009 |
| Q: i want formula for if i am expecting sales ist year 20% 2nd year 30% 3rd year 30% and last year ... A: There are several ways to do this. To me the easiest is to "pull it apart" and let Excle do the ... | |
| What If analysis with multiple sheets | 5/29/2009 |
| Q: Is it possible do a what if analysis where de data, formula and variable are in one sheet and the ... A: Luiz, There are two ways in Excel off the top of my head to do this. 1. Use the "vlookup" ... | |
| Copy rows based on Column value | 5/28/2009 |
| Q: I am trying to figure out how to copy several rows based on specific values (A, P, M or L) in Column ... A: To do this with a pivot table first make sure you have a heading for each column, otherwise Excel ... | |
| Converting text to number format | 5/28/2009 |
| Q: Thnak you for your time! I have a userform with multiple textboxes which will allow the user to ... A: James, I don't know how exactly you formatted to currency so first try this. 1. Select the cell ... | |
| paste value without macro | 5/28/2009 |
| Q: i used sum function like =sum(a1:a23) if the answer of this question is 1000, now i want to get this ... A: 1. Select the cell with the value of 1000 2. Select the "Edit" drop down menu 3. Select "Copy" 4. ... | |
| Copy rows based on Column value | 5/28/2009 |
| Q: I am trying to figure out how to copy several rows based on specific values (A, P, M or L) in Column ... A: Jason, There are many ways to accomplish this. I'm going to give you the simplest which involves ... | |
| expiration date formula | 5/27/2009 |
| Q: We have a spreadsheet with data that is entered on date X and on X+10 days, the user needs to be ... A: Stephanie, The auto date is simple as was in your original quesiton. If the date is in cell A2, ... | |
| sorting multiple rows | 5/27/2009 |
| Q: i am trying to sort multiple rows in a spreadsheet. i have tried to merge cells to make blocks and ... A: Tabitha, The easiest way is to convert the data to a flat file where each part number has its own ... | |
| Work schedule | 5/27/2009 |
| Q: .. i'm trying to make at work schedule for an employee. I want to be able to write start time an ... A: Sine, Set up your worksheet as follows: Monday Tuesday Start ... | |
| VLOOKUP Function | 5/27/2009 |
| Q: I've a small query for you. I'm really in need of your help! I want to pull up data with keyword ... A: Mohammed, A vlookup will only bring up the first line that matches this criteria. If you create a ... | |
| expiration date formula | 5/26/2009 |
| Q: We have a spreadsheet with data that is entered on date X and on X+10 days, the user needs to be ... A: Stephanie, Is your data input into a flat file format? By that I mean every individual data item ... | |
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
Answers by Expert:
- Nathan Head
- Chad Welch
- Philip Buckley
- Tushar Sakhalkar
- Bhaskar
- Amal
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bob Umlas
- Edward H. Mori
- Jessica L.
- Jan Karel Pieterse
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- Craig
- Adelaide carvalho
- Miguel Zapico
- JP
- Douglas M. Smith
- Richard Rost
- Ken Marron
- Victor Lan
- Bill
- Anne Troy
- Claire Blinman
Philip Buckley
Top Expert on this page
Expertise
In Excel 2003 I can handle all basic questions such as how to copy and paste, all medium type questions such as pivot tables, and also am proficient in basic macros. I am also quickly learning 2007 where everything is pretty much the same but all in different places. Please be as detailed in writing your question as possible as that goes a long way in my ability to give the best answer possible.
Experience
I have 20 years of business experience, mostly in the area of finance and business consulting. Currently I am a Senior Business Consultant with a small business consulting firm. As part of my daily activities, I regularly use Excel to help make small businesses more efficient.
Education/Credentials
MBA from the Crummer Graduate School of Business at Rollins College.
©2009 About.com, a part of The New York Times Company. All rights reserved.