|
|
|
April 27th, 2005 05:51 PM
by zackb
|
4 |
177 |
|
|
V Lookup 2nd Occurrence by
Rodney
I was offered a solution to the above, and I think
my son has loaded a copy of DragonBallZ over the file on a floppy.
Apologies to the helpful person who...
|
|
8 |
146 |
|
|
format of cell by
Scudo
I am trying to type in 2-26 in a cell, I have the cell as `general` format
but it keeps jumping back to custom and giving 46413.
Is there something else I...
|
April 27th, 2005 04:13 PM
by
|
4 |
136 |
|
|
Couple more questions... by
Poor microsoft user
ok, I'm cutting and pasting a column of numbers from a mainframe session and
dropping them into excel. But, the numbers all change when I do it! I have
to...
|
April 27th, 2005 03:20 PM
by
|
1 |
99 |
|
|
How do I display the RESULT of a formula by
Poor microsoft user
I enter "=1+1" in a cell. Instead of displaying 2, what is displayed is
"=1+1" (without the quotes). I go into microsoft help, do a search on
"display...
|
April 27th, 2005 03:18 PM
by
|
3 |
259 |
|
|
Converting dates to a number by
Kathy
What formula could I use to convert a date of birth into an age?, e.g.,
06/25/71, 33.
Yes, I know I can just subtract but is there a formula that can do...
|
|
3 |
126 |
|
|
Blank Cells, by
Issam LAdki
Thanks for your previous invaluable help, and it seems I need it again.
I have the following formula in a spreadsheet in Cell...
|
|
6 |
142 |
|
|
How to enter dates? by
dreidman
I am new to excel. I have been tasked with creating a work schedule for 20
people on a previously established excel spread sheet/ schedule. However, it
was for...
|
|
2 |
131 |
|
|
|
|
1 |
303 |
|
|
|
|
4 |
92 |
|
|
|
April 26th, 2005 10:59 PM
by zackb
|
5 |
231 |
|
|
The recalcitrant active cell. by
Rodney
I am way over in column EO, reconnoitring data,
when I need assistance of a "what if",
I activate the auto filter, and the active cell jumps back to A1.
any...
|
|
3 |
118 |
|
|
|
|
1 |
100 |
|
|
linking worksheet1 to worksheet1 by
Bed
Hello:
I need to link two worksheets in seperate files together. The problem is the
tabname on the first worksheet changes everyday. Is there a keyword I can...
|
|
2 |
93 |
|
|
|
|
1 |
379 |
|
|
Count by
Heather
I have two problems:
1) I need to count a row of 6 (AA4:AF4) -- but if it has zero for a
quantity, I need "Count" not to include these in total. How do I...
|
April 26th, 2005 12:19 PM
by JulieD
|
2 |
135 |
|
|
Importing multiple html tables into XL? by
RedFox
Greetings XL experts.
I have about 20 html tables with about 100 rows and 5 columns. I want to set
them up in Excel and apply simple formulas to do some...
|
April 26th, 2005 06:44 AM
by RedFox
|
2 |
168 |
|
|
tab problems by
JulieGirl
When I press tab to move from a cell to the one next to it, instead I am
moved to the first cell to the right of what is showing on the screen. For
example,...
|
April 26th, 2005 06:32 AM
by RagDyeR
|
2 |
101 |
|
|
Control Box Data Question by
camerons
I am using a control box list to drop down the various part numbers that we
use. I then use that number as part of a VLOOKUP function to return
corresponding...
|
|
2 |
118 |
|
|
|
|
2 |
268 |