|
|
sorting and combining data by
I've got two different spread sheets with large amount of
data. These two charts however share one grout of data
(in this case street address) The first set...
|
|
1 |
222 |
|
|
|
June 26th, 2004 05:54 AM
by Don
|
3 |
173 |
|
|
how to switch a #N/A value into 0 by
I used the vlookup function to get pricing from a=20
database which is multiplied by a specific volume. When I=20
have no pricing in the database for a product...
|
|
1 |
85 |
|
|
Custom Function & Personal.XLS by
Excel 2000 SR1, Win2kPro
Using a custom function works fine if the module is in my
current workbook, but when I move the function to the
module in my...
|
|
1 |
329 |
|
|
Percentages by
I have several percentages in a drop down validation box.
I'm trying to put 23.5% in using one decimal place. It
shows as 23.5%, however, when you choose it...
|
|
1 |
144 |
|
|
Count function by
How can I count a text value only once when there are
multiple occurrences in a column?
|
|
2 |
129 |
|
|
|
|
1 |
185 |
|
|
Dollar amount dependent on date by
Hi, I have a column of $ amounts and corresponding dates
in another column.
Date Amount
1/1/04 $100.00
1/15/04 $100.00
1/31/04 ...
|
September 7th, 2004 04:35 PM
by
|
4 |
336 |
|
|
Total for negative amount by
Hi all,
Need you advise on how to Sum-up the following amount
only total the negative sign amount (from range A2 to A13)
and the results is...
|
September 20th, 2004 01:58 AM
by duane
|
2 |
130 |
|
|
Do I use an IF function? by
Here is what I'm trying to do. I'm making an expense
record chart. I am entering a negative (-) number for
items paid with a credit card and a positve (+)...
|
|
9 |
140 |
|
|
Returning a Value by
I had two spreadsheets. The first contains two columns of
data, and on the second I wish to set up an equation (no
macros or sorts) so that when I type in a...
|
June 12th, 2004 02:00 PM
by JulieD
|
6 |
122 |
|
|
Excel Template Function by
I need to insert a function into one cell of my worksheet
(which will become a template) so that everytime the
template is use it adds a number. Like a counter...
|
October 21st, 2003 08:59 PM
by
|
0 |
219 |
|
|
Name conversion by
I have a spreadsheet that is updated by multiple users.
When they enter their names they enter it in the format
(first_name Last_name). Does anyone know how I...
|
November 18th, 2003 04:35 AM
by immanuel
|
1 |
103 |
|
|
Sequential Cell Reference follow-up by
That worked Great! Thank you.
I'm probably pushing it, ...... but it would be ideal if a
qualifer could be added ... e.g. add '@IF(A10,A1,0)for B:600;...
|
|
1 |
105 |
|
|
|
|
1 |
536 |
|
|
|
|
2 |
224 |
|
|
long formula by
Could you suggest a way to trim this formula...
|
|
9 |
148 |
|
|
Sorting by
I have office xp. I'm new to excel and having trouble
sorting a column of names. The sort tool is grayed out no
mater what cell I select. If I start a new file...
|
|
3 |
96 |
|
|
|
|
2 |
308 |
|
|
Cell by
I type account number in cell and it turn into 2.50021e+12.
I check the format o cell and it just gernral. The
2.50021e+12 is underline. I not sure wy the cell...
|
|
2 |
124 |