How do I get Excel to generate a random list of names without repeating?
Q. I want to make a simple Excel program that will randomly place employees in different areas of a job sight and not repeat names, for example, there are 5 different areas that they can work, and I get complaints of favoritism when placing them. If I can get Excel to do it randomly they can t complain.
Asked by Michael K - Fri Oct 10 15:55:24 2008 - - 1 Answers - 0 Comments

A. List the names in Column A. In Column B, use the RAND() funtion to generate a random number next to each name... In Column C, List the Job sites. Highlight the date in Columns A and B, leaving Column C untouched. Sort A&B on Column B's values... this will 'assign' people into the job sites in Column C.
Answered by pckiesel - Sat Oct 11 11:33:04 2008

How can I get Outlook or Excel to automatically email a copy of the same Excel file everyday?
Q. Hi I use Outlook 2003 and Excel 2003 on my work PC. I would like to set up a way of auto emailing the same (updated) Excel file at the same time everyday to the same email address. I am limited by my companies IT department who are very reluctant to let us download any third party software so ideally I need a way using the existing capabilities of the programs. Thanks in-advance!
Asked by Guy# - Tue Feb 24 23:05:30 2009 - - 1 Answers - 0 Comments

A. Try to use this one It is an automated email sender from a list You can easy modify it to do your request, may be: - Add this code to your workbook object in VBE Private Sub Workbook_Open() Application.OnTime Now()+0.005, "SendEmail" End Sub This will run the "SendEmail" subroutine after 8 minutes of opening the file Good luck and check out the links below VBAXLMan
Answered by VBAXLMan - Wed Feb 25 13:24:43 2009

What is the easiest way to make an Excel based listing of names and addresses off a list on the Internet?
Q. Am I going to have to type it all out to get it on excel...or is there some software or tool that I can use to read it off the web and put it into an Excel spreadsheet. I want to make a list of the names and addresses of all the state politicians and then use it in Excel to print mailing labels.
Asked by MightyB - Wed Apr 29 19:37:57 2009 - - 3 Answers - 0 Comments

A. Depending on how the list is formatted on the web site, you may be able to copy the text and then paste it in Excel and then use Data\Text To Columns to separate the data into separate cells. This may be difficult because addresses are widely variable in their formatting. You might also try using... Data\Import External Data\New Web Query ...to import the data from the web site. .
Answered by Cozmosis - Wed Apr 29 23:01:11 2009

What is the difference between excel 2000 and excel 2003?
Q. I just saw this free course on excel 2000 but the version that I have on my computer is 2003. Should I take the course anyways? Or will it be confusing for me? Thank you very much for your help, this is very important for me.
Asked by Adriana S - Fri Jul 17 12:13:21 2009 - - 1 Answers - 0 Comments

A. for the most part, there isn't that much difference. 2003 added some new features and enchanced some existing ones. But from a learning standpoint, if you take a course on excel 2000, you won't be confused. The menu options, etc. are pretty much the same . Since it's a free course, what do you have to lose.
Answered by jmorge - Fri Jul 17 12:30:20 2009

How can I format an excel document to look like a word document report?
Q. The software I use to generate reports kicks them out in an excel format. I need to turn the report into a word document that is more visually pleasing to view the information from the bland excel report. Any suggestions or ideas how I can accomplish this?
Asked by TomandShannan - Tue Oct 3 10:31:05 2006 - - 3 Answers - 0 Comments

A. Go to tools, select options, click gridlines.
Answered by iRiu [ ] ss a K - Tue Oct 3 10:43:02 2006

How to get Excel to tell you certain information?
Q. I have information from 2,166 people. There is a sex column with either a 1 (male) or 2 (female) for each one. There is other information like age, BMI, etc. I need to find the average, median, and standard deviation of all the males and all the females separately. How do I get excel to give me the mean of all the ages for just males when males and females are included on the spreadsheet?
Asked by nygirl5589 - Sun Feb 8 20:37:02 2009 - - 2 Answers - 0 Comments

A. If column A is the Male/Female (1 or 2) column... Average of column B of males only =SUMIF(A:A,1,B:B)/COUNTIF (A:A,1) *Median of B1:B2166 of males only (Array Formula) =MEDIAN(IF(A1:A2166=1,B1: B2166)) *Standard Deviation of B1:B2166 of Males (Array Formula) =STDEV(IF(A1:A2166=1,B1:B 2166)) *Formulas designated with an asterisk are array formulas. You have to enter array formulas with Ctrl+Shift+Enter. When you do, Excel will automatically put {braces} around the formula. You can't type in the braces. You have to use the Ctrl+Shift+Enter method.
Answered by Cozmosis - Sun Feb 8 21:11:18 2009

What is the excel formula to calculate the percentage to my goal?
Q. I need excel help...I need to figure out a percentage forumla where it will show me how close I am to reaching my goal. Here's what I have now: goal for 2009 current web traffic what formula can I create that will determine how close I am to reaching that goal? (ie 75% acheived, etc). Any ideas?
Asked by justsaytheword03 - Wed Jan 14 17:45:07 2009 - - 2 Answers - 0 Comments

A. hey ho yeah i can see if i can help you :) My goal for 2009 figuer in MY spreadsheet is in A2 but change this to the cell it is in for you My current web traffic in MY spreadsheet is in B2 but change this to the cell it is in for you ok so go to the cell which you would be entering the percentage answer into and type " =a2/b2" (again change the cells to accomidate you) all we are doing is a basic division between these 2 cells which has the current web traffic and the goal for 2009 after you have done the division this will give you a basic number what you now have to do is right click that cell > go to format cells > go down to percentage > change decimal places if you want and click ok This will give you the current acheived … [cont.]
Answered by cha_o_mac2001 - Thu Jan 15 12:11:41 2009

How to enable auto save in excel 2002 and test the same for working?
Q. I want to apply auto save in my excel 2002 like i have in my excel 2000 machine.
Asked by guru - Mon May 11 03:06:03 2009 - - 3 Answers - 0 Comments

A. Go to the menu option of TOOLS and select OPTIONS... Then go to the SAVE tab. You should be able to apply your changes there. Then just make a change to an existing MS-Excel workbook and wait for the allotted time. The change should be automatically saved.
Answered by unknown - Mon May 11 03:26:54 2009

How to perform Excel function to get unique numbered pairs?
Q. I need to pair up 20 people in sequence for a workshop, so I number the people and can rotate 1-10 with 11-20 easy enough, but when it gets to pairing 1-10 together in pairs and 11-20 in pairs, I am struggling to minimise movement! Is there a formula I could use in Excel to work out the pairing for me?
Asked by Wicked Way - Thu Aug 14 06:17:53 2008 - - 1 Answers - 1 Comments

A. This is not a formula but a graphical solution. Make a table with 11rows and columns. In the header row and column put 1 to 10.. Blank off all cels above and including the diagonal. The 45 cells below the diagonal defines by row and column header the pairs of persons e.g. 1 &2 etc. You can now pick the ones that suit you best.
Answered by wvl - Mon Aug 18 00:14:33 2008

How do I use excel to create a spreadsheet from multiple websites that use different formats for data?
Q. I am trying to create a spread sheet that pulls data from multiple websites, some of the sites use excel some are just web based listings. I would also like to be able to get the spreadsheet updated as the websites are refreshed.
Asked by Nicole T - Wed Jun 17 15:39:48 2009 - - 1 Answers - 1 Comments

A. Personally, I would probably do this in MS-Access, because I could import the data into Tables and compare the new data against the already existing data. And it would make the manipulation of the various formats much easier. Either way (Excel or Access), to have this automatically update your data, based upon changes at those various websites, will take a lot of VBA coding and interfacing. And that means a major project!!! If you want to do more of the basic manual data-manipulation yourself, then it will not take as much programming and design. But it will be a lot of daily work.
Answered by unknown - Thu Jun 18 05:58:39 2009

How can I use Excel to calculate Cpk values without buying a separate software?
Q. I need to calculate the Cpk value of a certain batch of numbers. how do I program this in Excel?
Asked by ovi.schi - Fri Sep 25 16:06:46 2009 - - 2 Answers - 0 Comments

A. Write your own using Visual Basic for Applications which is built into Excel. The calculations are not that complex.
Answered by Nick T - Fri Sep 25 16:22:14 2009

How do you use excel to find the volume of a solid with known cross sections using Riemann summs?
Q. My cross sections are semi-circles. My two equations are: .25e^(x-1) ln(x)+3 i don't need it solved, i just need to know how to use excel!
Asked by Jacquelyn C - Fri May 22 03:04:08 2009 - - 1 Answers - 0 Comments

A. If you need to use exponential, use EXP function for example "=EXP(2)" If you need to use ln , use LN function (inverse of EXP function) for example "=LN(86)"
Answered by vijay - Mon May 25 00:53:10 2009

How can you open Excel games in Excel without there being a problem?
Q. I have a few Excel games and when I open them into Office 2007 on my computer, Excel repairs them or something and I can play I just see the game but I cant press or play the game. Thanks Scott! I cant sorry. I said can. It says Apple Shooter [Read Only] [Repaired] [Compatability Mode]
Asked by Scott H - Fri Jan 30 13:48:11 2009 - - 1 Answers - 0 Comments

A. Not sure what type of game you can play in Excel but it probably uses a Macro. At the tope of the page (but below the Ribbon of Excel 2007) there should be a message bar letting you know that Macros have been disabled. There shuold be a button that allows you to turn on Macros for that file. Make sure it is a file you trust because Excel macros *can* be just like a virus if the intent is to be a virus.
Answered by JamesLeeH - Fri Jan 30 13:56:21 2009

How do I subtotal in excel and leave out zero totals?
Q. I am subtotaling a spreadsheet in excel. Most of the balances are zero, but I am only concerned with the balances that are not. I need to keep the detail. What is the easiest, least manual way to seperate those subtotals with balances from those with zeros?
Asked by katy c - Tue Dec 30 10:47:45 2008 - - 4 Answers - 0 Comments

A. namesalary john 112000 john 218000 john 324000 john 43000 john 536000 john 642000 john 748000 john 80 john 90 john 100 subtotal=SUBTOTAL(9,B2:B1 1) sumif=SUMIF(B2:B11,">0") The 9 in SUMIF is a argument type for sum. The subtotal command also works well if you use it on a filtered list. Works for all versions of Excel. You might want to consider the DSuM function as well
Answered by johncaulfield100 - Fri Jan 2 20:30:40 2009

How do I make Microsoft Excel number a line of cells down one side in ascending order?
Q. I need to have Excel make a list of numbers in ascending order down the side of my spreadsheet, any ideas?
Asked by moonyfruit - Sun Sep 21 13:24:10 2008 - - 5 Answers - 0 Comments

A. If you want to create a column of numbers in ascending order: Enter '1' in the first cell, '2' in the second cell, and '3' in the third cell. Then, highlight all three cells. Place your mouse over the bottom right corner of the bottom cell until you see a '+'. Right click and drag down as far as you want the series to go. Release and select 'Fill Series'.
Answered by garbo7441 - Sun Sep 21 13:35:39 2008

Is it possible to export data from MS Excel to MS word to generate a report?
Q. My data is currently saved in Excel and I need to generate printable reports which would show only the data needed. I would like to know if there is a way to create reports in Excel or maybe export the required data into Word (maybe using a macro?). The Word document could then be printed and submitted as a report. Does anyone has any suggestions?
Asked by PGtips - Mon Oct 6 12:14:04 2008 - - 7 Answers - 0 Comments

A. There are many ways of doing this. I'll outline 3 of them and the good news there is no need for macros! 1. Open spreadsheet>>highlight data>>copy (ctrl+c)>>Open word>>Paste (ctrl+v). Basically what this method does is copy the data from excel. When pasted into word the data is converted into a ordinary Word table. 2. Use the Paste Special command: #Open your Word document. #Open your Excel spreadsheet. # Within Excel, select the cells you want to copy into Word. # From the Edit menu, click Copy. # Switch back to your Word document. # Place the insertion point where you want the data placed. # From the Edit menu, click Paste Special. # Select Microsoft Excel Worksheet Object. # Click OK. This basically produces the same result as 1.… [cont.]
Answered by michael g - Mon Oct 6 12:25:37 2008

How to link between two excel files without opening the source file?
Q. I have 50 source spreadsheets that are imported crystal reports. I have a summary spreadsheet that links to all 50 source spreadsheets multiple times. Excel will not refresh my links w/o opening the source spreadsheets. I need the summary sheet to open and automatically update every link. How can I achieve this? Thanks.
Asked by btownridgerunner - Thu Oct 30 15:35:49 2008 - - 1 Answers - 0 Comments

A. in excel 2003, when you have links to other sheets the sheet will normally prompt you if you want to update the links when you first open the file. If you're not getting this prompt, go to Tools > Options and select the Edit tab. There's an option called "Ask to update links". Check this box. You can also manually force the sheet to update the values from linked files by going to Edit > Links. Select the linked "source" files and then click the Update Values button. in excel 2007...I'm sure the same options are available but I don't know where MS moved them to. Press F1 for help and search for how to update linked files.
Answered by jmorge - Thu Oct 30 15:52:12 2008

I want to learn microsoft excel ,what version should I start with and what workbook should I get?
Q. I am a beginner and I want to learn the basics of microsoft excel. Where should I start? I would like a workbook so I can learn quickly.
Asked by tasha - Wed Aug 27 10:51:09 2008 - - 3 Answers - 0 Comments

A. Most companies currently use Excel 2003. So right now that may be the version you want to learn. Excel 2007 is the newest version. It is laid out a lot differently than the normal layout of Excel has been in the past. However, I think most people will find after using Excel 2007 that the layout change of Excel 2007 is a very large improvement over the previous versions. The problem is that if you are used to the previous versions it takes a bit to get used to. If you are going to learn Excel 2007, then I recommend Microsoft's Excel 2007 Plain & Simple book. The Plain & Simple series of books from Microsoft is laid out very well with a lot of graphic representations that make it easy to understand. You can find them in most any… [cont.]
Answered by devilishblueyes - Wed Aug 27 14:44:53 2008

How can I make excel recognize the number is a measurement?
Q. I need help with making excel read a formula. For example I have 4' 5" typed in one cell. i want excel to recognize that as "ft" "in". And this is important because i have an sumif scenerio that is suppose to subtract according to a scenerio. Is there a way for excel to recognize the entry as measurement? If so, how can i make it recognize it?
Asked by Toe Knee - Thu May 28 13:38:33 2009 - - 2 Answers - 1 Comments

A. First of all, there is nothing in the standard MS-Excel application to handle these types of measurements. But there are Add-Ins available which could be used (a search using Google will show you these). But there are other ways of handling this: One way is to put the Feet in one column (right justified) and the Inches in the next column (left justified). Then you can use another column to do a calculation using these two columns to show the decimal equivalent of feet/inches, which would allow other easy calculations. Another is to convert the values to Metric using the Analysis Toolpak Add-In which comes with MS-Excel (see TOOLS menu under Add-Ins...). And working with Metric values for calculations is like any other decimal… [cont.]
Answered by unknown - Sun May 31 01:24:14 2009

How do i make my excel spreadsheet formulate a letter anytime that i put a number 60 and higher into a cell?
Q. I have an excel spreadsheet for our apartment community and anytime that I input onto the spreadsheet that someone is 60 or older I must put a capital 'Y' into a cell on the same spreadsheet three columns over that will indicate that that resident is a senior. Is there a formula or something that I need to use? Or can it even be done?
Asked by David N - Fri May 23 13:01:01 2008 - - 2 Answers - 0 Comments

A. if the age is in column A, put the following in column D: =IF(A1 >= 60,"Y","")
Answered by five v - Fri May 23 13:26:50 2008