General

Sort messes up pictures
I have an Excel spreadsheet with pictures inserted in one of the columns. When I sorted the spread sheet, about half of the pictures did not move with their cells, and many got overlaid on top of pictures that did not move. What will prevent that? ... 23 Mar 2010 09:00

Copy Data
Good day; First of all, I would like to thank you. You helped so many times. Example;;; Sheet-1, Cell A1 = Milk Sheet-2, Cell B1 = Can I copy the Cell [Sheet-1, Cell A1],? The word (Milk) will appear'! ... 23 Mar 2010 09:00

How can i auto hide and display row or collum for zero value
... 23 Mar 2010 09:00

Sports team assignment
I am trying to determine how to do the following: I need to assign players to teams in a flag football league. The number of teams will depend on the number of players. The skill level of players must be taken into account to insure that teams are all equally talented as best we can. In order to measure skill le... 23 Mar 2010 00:09

calculate back dates
Hi is there a way to figure out a date 9 months previous to a date? eg. I have an install date of 12/02/10, is there a way or a formula that can count back 9 months from that install date? (they need to be weekdays) thanks very much ... 23 Mar 2010 12:30

Formulas in a criteria area
Can a formula be used in a criteria area when extracting data from a table in Excel 2007? ... 22 Mar 2010 23:02

Selection copy and insert to other sheet
Any body help me please......... I have selected two cells from a row from sheet1 Is there any way to copy those cells go to Sheet2 and insert a blank row in A1 and paste those infor on B3 tks in advance ... 23 Mar 2010 13:40

How do I change the comment default format to include date?
In Excel 2007, I want to change the default format for comments, so that the date the comment was added is included in the comment as well as the name of the user who added the comment. ... 23 Mar 2010 11:20

Screen Refreshing Anomaly
We are using Excel 2003 SP3 on a network. Observed behavior: In an apparently random manner, Excel flashes quickly through numerous "broken images" and flickers, showing pieces and parts of other worksheets that are open, in no particular pattern, before ultimately stopping and displaying a broken image. At ... 23 Mar 2010 13:40

Looking up a returned value defining a named range
A formula return the word Two. =IF(ISBLANK('Lane Entry'!A17),0,IF('Lane Entry'!R17=0,'Lane Entry'!S17,'Lane Entry'!R17)). I then try to use the cell (AD15) which =Two in a vlookup statement. The text word Two is a named range. =VLOOKUP(D15,AD15,AE1,FALSE) D15 = EDMONTONABSASKATOONSK AD15 = Two AE1 = (colu... 23 Mar 2010 11:20