Search Results

Search found 4901 results on 197 pages for 'excel macros'.

Page 32/197 | < Previous Page | 28 29 30 31 32 33 34 35 36 37 38 39  | Next Page >

• Generate 300 lists of 12 numbers between 1 and 33 without repeats in excel

  - by Greg

  I am conducting a study in which each of the 300 participants are rating 12 prototypes each. We have 33 prototypes in total. How would I generate 300 lists each containing 12 random prototypes from the 33 in excel ensuring that no list contains a duplicate and all prototypes appear at least 100 times? Thanks

  Read the article

• Subnet calculator for MS Excel

  - by Martin

  I quite often use the handy subnet calculator here: http://www.subnet-calculator.com/ Which I find very useful. However, does anyone have details/a link for a version of this that offers similar functionality but is in an excel spreadsheet. I could then include it in a worksheet and I wouldn't have to keep visiting the website. Also handy if I don't have internet access - which can often be the case when I need it. Many thanks

  Read the article

• Scientific notation in Excel

  - by Vojtech R.

  Hi, I need make Number Format like scientific notation, but without E nor e. Just classic like this: (In latex its 2.3\times10^3) Maybe excel doesn't support this format. (I have on mind Number Format - for hundreds numbers - not in math formula)

  Read the article

• Microsoft Excel 2010

  - by Bruce

  I've one "master" sheet in the Excel 2010 file with all my outstanding orders detail and also reflecting how many days the orders have been outstanding. I've 4 other sheets, I'd like to extract the orders from the "master" sheet to to each of these sheets grouping them into these criteria. The 4 sheets need to reflect as follows <60 Days 60 Days <90 Days 90 Days <120 Days 120 Days Can someone assist?

  Read the article

• Ms. Excel: Update a value in a named range

  - by Vinzz

  Hi, I've got some cells in an Excel doc populated from a named range (data/validation/list source=MyNamedRange) My problem is the following: I'd like to change a value in the named range, then see this value updated in my whole doc. It might be performed through a macro, but I don't know how to code this. Any hints please? Thanks,

  Read the article

• Excel Table lookup with indexes in multiple columns

  - by Matthew Scouten

  I have a Table in Excel the looks about like this: Test1 100 test2 200 Test3 110 test4 210 Test5 120 test6 220 I want a function that, given test 1 as input, will return 100 AND given test 2 will return 200 LOOKUP, (V/H)LOOKUP, and INDEX all insist on a single contiguous array for the index column.

  Read the article

• Excel 2007 shortcut ?

  - by ldigas

  Is there a shortcut in Excel 2007 (or a simple way to define one) to paste all copied values, but without formatting ? I'm entering some data in tables, and it would really save my life, that one.

  Read the article

• Excel price function not working despite adding the analysis tool pack

  - by Kaiser Advisor

  Hi Everyone, I am trying to price bonds using the Excel function, PRICE(..), but the function isn't working. The intelisense doesn't come up, and I get the #NAME? error. The help file says to install the analysis tool pack, but this doesn't resolve the problem. I have Office 2003 for XP. thanks!

  Read the article

• Down down list in excel

  - by Sandra Soares

  I am creating a table in excel to capture metadata and I want to allow a user to select options from a drop down list(1=yes,2=no,999=missing).

  Read the article

• How to antialias trendline in Excel?

  - by user23122

  I have created a couple of line charts in Excel 2011 for Mac. The actual data line looks good and is antialiased in a nice way but when I then add a trendline it is jagged and ugly: I have tried "all" options available under Format Trendline, to no avail. There is an option "Soft Edges" but it doesn't seem to work as expected: when I increase the value there the trend line gets more and more narrow until it disappears.

  Read the article

• Excel 2007 | Remove blank fields from pivot tables

  - by answertips

  Every time I create a pivot table (available for all Excel versions) I get one or several blank fields. How can I get rid of them? One workaround I used was to select the blank field, right click | Filter | Hide Selected Items. This can solve my problem but I need to do it manually... Is there a way to automatically hide/exclude the blanks?

  Read the article

• Excel pivot table reading from xml

  - by jwarzech

  Can Excel 2007 use an external xml file as the connection for a pivot table? I am able to filter the dialog by xml when specifying a type of data however I get an error saying that it is not a valid datasource.

  Read the article

• Excel 2007 user warning when opening xls files

  - by J Angwenyi

  I am getting the following error warning when opening an xls file generated using 'CarlosAg.ExcelXmlWriter.dll' using Excel 2007 The file you are trying to open,'', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? Any idea how to resolve?

  Read the article

• Remove password on Excel 2007 VBA project

  - by MJ

  Is there an application that can remove the password on an Excel 2007 VBA project? Or is this something that I can fix within the program itself?

  Read the article

• Freeware tool to crack excel password

  - by SuperFurryToad

  I have an Excel document that is password protected Are there any freeware tools out there to crack the password to open a document? I've seen a lot of commercial tools available, but no freeware ones.

  Read the article

• saving excel files to file paths or directories with special characters

  - by benhc911

  I am unable to get excel 2010 beta to save to a directory which contains square brackets. I have to save elsewhere and copy in. Is there any workaround? Was this a problem with older versions? I realize that I could manually change the directory names, but I didn't want to forgo a long standing organization scheme for the sake of one program if possible to avoid the problem.

  Read the article

• Excel 2007 - "The Document Information Panel was unable to load"

  - by Ruffles

  In Excel 2007, if I go to Office button - Prepare - Properties instead of showing document properties, I get a message "The Document Information Panel was unable to load." I have come across a number of posts suggesting I copy ipedintl.dll from C:\Program Files\Microsoft Web Designer Tools\Office12\1033 to C:\Program Files\Microsoft Office\Office12\1033, however I have tried this, and the problem is still occurring. Does anyone have any other ideas of what this might be? Thanks.

  Read the article

• excel - generate a username from a full name field

  - by mheavers

  I'm trying to generate a username using a single name field in excel which has the person's first name and last name. I'm open to what the username would be, as long as its intuitive for the user. The name fields can be tricky, as the data looks like this: Albert Abongo (2 names) Stephen Michael Essuah Ackah (4 names) Alhaji Iddrisu Abdul-KArim (3 names) I guess my ideal usernames for these people would be aabongo sackah aabdul-karim

  Read the article

• EXCEL: How can you FORMAT a serial number into a MONTH ( Jan, Feb)

  - by Mike

  I extract the Month() number out of my date. I now want to change that number into a recognisable string Jan, Feb, Mar, etc. In Access you can use FORMAT, but what can we use in Excel? E.g. Date----------Formula---------Result-----What I want! 01/03/2010---Month(Date)--------3----------MAR Thanks Mike

  Read the article

• Excel Issues macro may be needed

  - by user124643

  I trying to compare lists in excel. There are two lists, one list just has one column and the other has two columns, and what I am trying to do is when column A matches column C than take the value in column D and use that to replace column A. For example: Column A Column B Column C Column D Blue Blue Shirt Blue Red Pants Red Green Shoes Red Green Green Purple So the completed list should look like: Column A Column B Column C Column D Shirt Blue Shirt Shirt Red Pants Pants Green Shoes Pants Shoes Shoes Purple

  Read the article

• Statically Display Excel drop-down boxes

  - by Chris Gunner

  I'm looking to present an Excel questionnaire I have written to the board, via either paper or presentation slides. It uses a lot of drop-down boxes, and so I'm looking for any ideas on how one might go about showing the options for each response (from the drop-down boxes), without having to manually print screen a bunch of times and pasting the results into Visio. Has anyone come across a nie easy, fast method of doing this?

  Read the article

• How to control Excel VBE Find Dialog window position

  - by Herb

  In the Excel VBE, the Find Dialog box (CTRL-F) pops up half off screen at the bottom of screen. How do I control the Find window so it positions itself higher up on the screen ?

  Read the article

• Using Paste Special - Values with the HYPERLINK function in Excel

  - by Pete

  I have a long list of data in Excel. Using the Hyperlink function =HYPERLINK(C2,A2) i've added individual links to them all. Now i want to get rid of the function and just leave the data with the link. So i do Paste Special -- Values Which does the job but then the link is removed. How can i paste the values and keep the hyperlink?

  Read the article

• Specify formatting information in Excel forumla

  - by jay

  Is there a way to specify the formatting in an excel formula? =IF(A1="Large","This is BIG","This is small") Where "BIG" is of a font size larger than the text for "small"? (I'm aware of conditional formatting. That's not what I'm after.)

  Read the article

• ms excel find and replace @ symbol results in broken formula

  - by Loopo

  I'm trying to search and replace in excel, the column is formatted as 'Text'. Find: [@ replace with: @ Whenever this finds a match at the start of a cell i.e the cell contents start with [@ and tries to replace that with @ the result is an error 'This function is not valid' I guess that since the @ operator is for references, this is causing the cell to be interpreted differently (not as text anymore) How do I make this replacement work? Copy/paste into another program is not a good option because some of the cells contain line-breaks.

  Read the article

< Previous Page | 28 29 30 31 32 33 34 35 36 37 38 39  | Next Page >