|
|
|
|
6 |
123 |
|
|
|
|
3 |
163 |
|
|
|
|
3 |
193 |
|
|
Substituting TODAY() for DATE(a,b,c) by
Bad_Shot[_2_]
{=MEDIAN(IF(B25:B1023=(DATE(B2,B3,B4)-180),IF(B25:B1023=(DATE(B2,B3,B4)-365),D25:D1023)))}
This works for my data. But requires me to put the date in...
|
January 15th, 2009 11:26 PM
by Max
|
3 |
187 |
|
|
A unexpected behavior by
Marsh
In Excel 2003, a collegue has a file with a nuber of Merged cells. For a
reason that escapes our explanation, some rows, not necessarily with merged
cells,...
|
|
9 |
297 |
|
|
|
January 15th, 2009 02:29 PM
by John
|
1 |
126 |
|
|
Removing select text from a cell by
Tim Millar[_2_]
I have a cell formatted for Text with the following information;
006-0527-5475
I want to remove just the huphens so it looks like this;
00605275475
Does...
|
January 15th, 2009 02:28 PM
by John
|
1 |
112 |
|
|
automatic total of selected cells by
MarlboroughT&C[_2_]
Usually if I select a column or row of cells, I can see the total at the
bottom of the worksheet - this seems to have disappeared. How do I get it
back? I...
|
|
6 |
151 |
|
|
Consecutive dates using two cells at a time. by
B.G. - Canada
I want cells a1 and a2 to have a date of Jan. 1/09 then have cells a3 and a4
to be Jan.2/09 etc.. in this consecutive pattern for the entire year. Is
there...
|
|
3 |
148 |
|
|
|
January 14th, 2009 04:02 AM
by Max
|
3 |
165 |
|
|
Find by
Connie in Vegas[_2_]
When selecting a column and using the Find command, it is hard to see where
the cell is. The color of the cell and the highlight of selecting the column
are...
|
|
3 |
179 |
|
|
pausing a macro to input cell contents by
blipityblap
My first macro using XP, Excel 2003.
During the Recording of a macro, what syntax/keystroke is required to
'pause' a macro so as to allow input of data into...
|
|
3 |
173 |
|
|
|
January 13th, 2009 10:16 PM
by Puk
|
2 |
87 |
|
|
copiando planilhas com gráficos by
INDUSTRIAL
Como faço para copiar planilhas sem que o gráfico carregue os vÃ*nculos da
planilha original e sim vÃ*ncule-se Ã* cópia, já que tratam-se de duas...
|
|
0 |
110 |
|
|
Import / export data by
Levi
Hi, I am working on a label system and would like to link data from a cell in
spreadsheet 1 to a cell in spread sheet 2.
Is this possible?
The thing is the...
|
|
2 |
107 |
|
|
option buttons in excel by
GKinSC
I am trying to make a form with single option buttons that need to just fill
when you click it and unfill when you click it again. All option buttions are...
|
|
1 |
131 |
|
|
excel 2007 by
Connie in Vegas
When I open an existing file in Excel, Excel opens with no worksheets
showing. I click the Red X to close Excel. Excel closes and behind it is
the file I...
( 1 2)
|
|
10 |
139 |
|
|
|
|
4 |
172 |
|
|
****DAMMMMN I CANT DO IT**** by
j.t
Hello
can I PLEASE get some help- I have a list of inventory:
Item qty
apples *formula
oranges * same
Pears ...
|
|
1 |
124 |
|
|
Importing XML by
Bing
I have an XML file with several tables. I need to export into an existing
excel 2003 spreadsheet. Also be able to select a different sheet within the...
|
January 12th, 2009 09:10 PM
by Bing
|
0 |
97 |