|
|
|
|
4 |
180 |
|
|
|
May 16th, 2009 07:44 AM
by RJinNZ
|
0 |
136 |
|
|
|
|
5 |
128 |
|
|
using multiply if function by
lbreger
I need to create a formula using this information.
Lets say cell G3 is an age 28.4
Than I need in another cell
If G3 is 30 = 1.25
30-40 =1.0
...
|
|
4 |
134 |
|
|
sorting by
teh_chucksta
how can i sort a column with numbers and text, in descending order, where the
text falls to the bottom and not the top?
thanks,
charlie
|
|
2 |
117 |
|
|
|
|
4 |
111 |
|
|
matching 2 worksheets by
melody_ph
I have been reading the blogs but couldn't really find what I'm looking for.
I have 2 sheets. One is our ledger that has 3 columns as follows:
A - Date
B -...
|
|
1 |
99 |
|
|
|
|
4 |
118 |
|
|
|
|
2 |
81 |
|
|
|
|
3 |
97 |
|
|
|
|
8 |
166 |
|
|
|
|
3 |
91 |
|
|
Help with SUMPRODUCT by
Alex Mackenzie
I admit I do not fully understand SUMPRODUCT; I am trying to follow the
variious samples I have found.
Data:
Whs Reasons Returns
1 1 ...
|
|
7 |
97 |
|
|
|
|
7 |
93 |
|
|
is there an AND logical ? by
Don Guillett
You're right. I had to type in
and function
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Don Guillett"...
|
|
2 |
87 |
|
|
importing data from a txt file by
rrlogan
The software my company is using creates 2 rows of data for each sku which I
can create as a txt file to import into excel 2003.
LIke this:
Sku ...
|
|
1 |
112 |
|
|
Finding the current year by
BrittaniMV
I am trying to determine the current year at a given date.
For example, if my beginning date is 1/1/2000, as of 12/31/2002 this date in
time would be in...
|
|
3 |
150 |
|
|
Excel formulas become cell contents by
DJLT
I am experiencing a problem in Excel. When I enter a formula (any formula)
in certain cells the formula remains visible in the cell as the cell content.
...
|
|
3 |
121 |
|
|
|
|
2 |
98 |
|
|
|
|
3 |
273 |