|
|
Sorting by cell or text format by
Does anyone know of a way to sort a list by the cell
format or by the text format? I have a very long list
where the 'good' cells have been colored in yellow....
|
|
1 |
654 |
|
|
Data transfer2 by
Let me clarify. I am trying to transfer data from an
excel 2002 cell to a specific place in a word 2002
document. I am not trying to cut/copy and paste. I...
|
|
1 |
171 |
|
|
|
March 17th, 2004 07:27 PM
by
|
0 |
445 |
|
|
Loops by
I need a loop function in excel... is there such a thing?
What I need is for excel to look over a range of cells and
if there is data written in the cells to...
|
May 13th, 2004 03:12 PM
by
|
3 |
265 |
|
|
Round function - round to 5 by
-----Original Message-----
I'm trying to round to 5 but can't figure it out.
Decimals are clear, so
is round(xx, -1)... but:
26 should be 25
27 should be...
|
May 18th, 2004 11:36 AM
by
|
0 |
264 |
|
|
|
May 18th, 2004 07:23 PM
by
|
0 |
93 |
|
|
Deleting a Link by
I've copied a worksheet from another workbook. When I open
the file to which I have copied the message states that
there is a link to another file. I don't...
|
July 5th, 2004 03:54 PM
by Gbonda
|
1 |
107 |
|
|
|
July 14th, 2004 05:34 AM
by
|
6 |
112 |
|
|
List by
Hello,
I am trying to create a list in a cell that references a
name range on another sheet. The only way I know how to
create a list currently is to...
|
July 13th, 2004 07:21 PM
by
|
2 |
103 |
|
|
Per Diem Caculation by
I am writing a spreadsheet to figure Travel Vouchers for
myself and my Army classmates. I've everything except for
Meal payments on weekends. Got the date...
|
|
4 |
86 |
|
|
array formula by
I have an array formula summing only posotive numbers in a
single column but in differant rows. I'm not able to use
the : because it sums all info inbetween...
|
|
7 |
226 |
|
|
comparing values for matches by
I would like to set up a cell to look for a number match
for a cell next to it in another worksheet and over many
columns and rows.
Does the value in...
|
October 27th, 2003 09:55 PM
by
|
2 |
168 |
|
|
formulas by
I have a spreadsheet which tracks locations of parts. The
location is in test format. I want to add up the total of
each location to a numeric value. Any...
|
|
1 |
115 |
|
|
Calculating Ages by
I am trying to find a formula that will calculate ages in
one column based on a birthdate entered into a previous
column on a worksheet, that will update on a...
|
November 5th, 2003 09:28 AM
by
|
2 |
158 |
|
|
|
|
2 |
175 |
|
|
Unique entries in a filtered list by
Hi Peo,
I posted it again in case anyone missed it the first
time. I got your formula to work and although it was
impressive it is not applicable for the way...
|
|
1 |
547 |
|
|
Excel on Pocket PC by
I understand that some complex spreadsheets transferred
from PC to Pocket PC will not function since some of the
commands are not recognised. However, similar...
|
December 17th, 2003 02:25 PM
by
|
0 |
327 |
|
|
MSNStockQuote by
I have installed the add-in but the formula is bringing
back the error message. As for more info...I am wondering
if there is some way to determine if the...
|
|
1 |
127 |
|
|
|
|
2 |
157 |
|
|
Date and formulas by
Hi
I have a spreadsheet with a load of dates when a
particular service was carried out.
I would like to create a formula in another cell with a
date which is...
|
|
9 |
141 |