Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » General (RSS)

Browse Forum Posts by Tags

Showing related tags and posts for the General forum. See all tags in the site
  • Re: Files

    Hi, Do you mean you open two windows of the same file? If so go to Window and un-tick file 2. Then close and save your file, then when you open it again only one will open
    Posted to General (Forum) by oldchippy on Mon, Sep 13 2010
  • Re: How to create a game schedule

    There is a general approach to this for odd and even numbers of teams. I have a spreadsheet that does this and calculates schedules in a couple of different ways. However it is open office and may be a little different from Excel (see http://templates.services.openoffice.org/en/node/4035 ). There is...
    Posted to General (Forum) by Ian_T on Thu, Sep 9 2010
  • Long numbers converts from texts to scientific when copied from 2007 to 2003

    Our shop is in transition from excel 2003 to 2007. When we copy long numeric values from Excel 2007 into 2003 the data displays fine at first but when we format the data to text it displays as scientific. How can I convert the data in 2003 to text and have it not display the scientific format?
    Posted to General (Forum) by Susan Lugent on Fri, Aug 13 2010
  • Find common records between multiple data sets

    Hi, I would like to find common or duplicate records between 8 data sets (each one has different number of records). I have found this formula =IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1) which works great between two data sets. How can I modify it to include all 8 sets? Or do I need a different...
    Posted to General (Forum) by Patricia Wu on Wed, Jun 30 2010
  • How to stop users moving a cell by accident

    Hi All I have a protected worksheet where all but a dozen cells are locked. The unlocked cells are in A1:A12. Occasionally, instead of entering data into A1:A12, the user will drag one of those cells onto another one unintentionally. Often they have no idea that they have moved a cell. Formulas in columns...
    Posted to General (Forum) by keghead on Sun, Nov 15 2009
  • Combining Two Sets of Data

    Hi, I have put this in the general section as I don't know if I need VBA or if I can do this with a look up. Basically I have two sets of data; Set 1 eg. Promo Code Detail Creative Offer Expense Date Live XF2 PPC Promotion Jan 09 N/A 10% Off $2000 1/1/09 GGH Geographic Magazine Jun 09 Red 15% Off...
    Posted to General (Forum) by rebsbails on Wed, Oct 7 2009
  • How to create a game schedule

    I am not an expert at Excel (casual use for a few years making simple reports) but I've taken on a task of creating a spreadsheet showing the game schedule for teams in our club. This spreadsheet is a tab in a workbook that keeps track of scores and stats. I'll describe the best I can. We have...
    Posted to General (Forum) by Ross Armstrong on Mon, Aug 31 2009
  • Odd cell behavior: formula replaced with formula value

    I have a spreadsheet that has begun behaving badly. The behavior: Certain cells are supposed to hold formulas, but upon recalculation, the formula is often replaced with the value of the formula. The affected cells are ones that at one time contained custom functions. Other than that, the behavior seems...
    Posted to General (Forum) by mayo99 on Tue, Nov 25 2008
  • Nesting "RIGHT", "MID", and "FIND" in a formula

    I am trying to get the correct formula to extract the last word in a string. Data Correct Answer John Doe Doe John A. Downer Downer John A. and Jane Smithhaven Smithhaven If anyone can give me the correct fomula for extracting this data I would greatly appreciate it.
    Posted to General (Forum) by Gary2m on Thu, May 29 2008
  • Re: Trying to understand Object Heirarchy

    Thanks to you both for your help. The suggestion works perfectly and the methodology is beginning to gel (I hope!).
    Posted to General (Forum) by ajandco on Fri, May 23 2008
Page 1 of 3 (25 items) 1 2 3 Next >
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.