|
|
|
|
1 |
237 |
|
|
how to automatically populate a cell? by
RW[_4_]
Say I have a 20 column wide spread sheet- columns 'A' ~ 'T'.
When I enter data into the cell at row 1 / column 'A', is there a way to
have that data...
|
|
1 |
183 |
|
|
|
|
2 |
128 |
|
|
|
|
4 |
140 |
|
|
adding columns by
Munro
I am trying to find the formula for adding totals of columns at the bottom of
the paue !!!
|
|
3 |
116 |
|
|
keyboard shortcut by
Bumblejeep
hi
is there any keyboard shortcuts for pasting values only to a certain cell
and to fill with color a cell,row or column?
thanks and regards
--
AABG
|
|
2 |
109 |
|
|
Adding Text by
Xman
Is there a way to add text to the portion of the spreadsheet outside the
letter or numbers. For instance, I have a column grouped, and I want to put
text...
|
|
3 |
124 |
|
|
|
|
2 |
92 |
|
|
Outlook 2000 Address Book by
Dave
Just configured new computer with outlook 2000 and I can not find the
address book nor can I send messeges - I get "an error occurred while
attempting to...
|
|
1 |
148 |
|
|
Calculating Duplicate Entries by
Bad_Shot[_2_]
I use Excel 2003.
I pulled good info off this forum and off other sites referenced within.
I can do what I’m trying to do with filters, formulas and...
( 1 2)
|
January 30th, 2009 12:28 AM
by Max
|
14 |
237 |
|
|
|
January 29th, 2009 01:23 PM
by John
|
1 |
84 |
|
|
Converting Dates after Import by
Still learning@work[_2_]
I have imported employee data from an AS400. The text for dates import as
"1012008" for 01/01/08 or 12012008 for 12/01/08. Is it possible to write a...
|
|
6 |
140 |
|
|
Using the wildcard with IF by
DamienO
Hi all,
I'm trying to set up a message that will generate from an IF formula. At the
moment I'm at:
=IF(E3="*C3","","Please check that you have chosen")...
|
|
5 |
101 |
|
|
|
|
2 |
134 |
|
|
Calculate Value on new cell based on List by
Ranjit S Hans
Hi Excel Gurus,
How do I calculate a value on a new cell based on what the user selects from
a List.
For Example :
If I have a dropdown List of 5 items -...
|
|
5 |
179 |
|
|
Time format as hh:mm:ss by
Dennis
When inputing time as above, Excel is thinking it is a Time as AM or PM, but
actually it is a lapsed time. How do I get it to do just hh:mm:ss? Without...
|
|
2 |
130 |
|
|
Formatting cells by
Doug Mc
I copied some cells from a sheet to a new sheet.
The cells I copied contained some numbers and dates.
Some of the numbers had a dollar sign on them. I wanted...
|
|
7 |
121 |
|
|
I need to carry over text to the next row. by
Ken Bulldawg Busler
I have Excel 2003 and I have figured everything else out except for how to
carry text over to the next row when I reach the end of the previous row. And
at...
|
|
6 |
144 |
|
|
Changing Formulas by
B.G. - Canada[_2_]
Right now I have the following
A1 =DATA!A3
B1 =DATA!B3
C1 =IF(DATA!C8=""."".DATA!C8)
D1 =IF(DATA!D8=""."".DATA!D8)
Is there any way to change the formulas...
|
|
2 |
105 |
|
|
2 =IF conditions by
BetaDocuments
=IF(O141000000000,"DUAL VP",IF(O14500000000,"VP", IF
(O14100000000,"AVP", "OFFICER")))
I what above condition to be true only when Cell A1 is selected...
|
|
3 |
141 |