|
|
|
|
1 |
118 |
|
|
|
June 19th, 2009 04:22 PM
by Max
|
3 |
101 |
|
|
Cell Change Color - Need Help by
alani
Hi All,
I wonder if anyone can help me on this. I'm working on something which
will help me to monitor inputs. e.g. A system will send a heartbeat
every...
|
|
1 |
489 |
|
|
Cell Change Color - Need Help by
alani
Hi Bob,
Thanks for the quick reply. I've tried it but it didn't work as
expected or maybe i did something wrong. I've already click and paste
the script as...
|
|
1 |
109 |
|
|
Auto transfer of row by
alanled
I have a list of components to be ordered in each row is a cell with a
order number entered in it. What I want is to copy the row to another
sheet (which is to...
|
August 18th, 2006 12:06 PM
by starguy
|
2 |
117 |
|
|
Sum Problem by
alanled
This is the second part to a problem Ive descussed in a previous thread
(thanks Karen). I have 2 rows one with part numbers in and one with the
total amount of...
|
February 13th, 2006 03:02 PM
by George
|
3 |
107 |
|
|
Simple Stock Control Sheet by
alanled
Im Trying To Write A Simple Sheet That Basicly Lists All The Components
In Stock With There Quantities, And Then Have A Cell Dedicated To
Selecting A Component...
|
February 10th, 2006 06:33 PM
by Karen
|
1 |
82 |
|
|
Adding selected cells by
alanled
If i have a list of numbers say in cells c1 to c10 and i have a sum to
add these all together and display the answer in c11. I want to be able
to only allow...
|
|
1 |
76 |
|
|
deducting a monthly payment by
alanled
Hi I would like to have a cell displaying a total outstanding loan
balance and another cell displaying the monthly payment and every month
on a set day the...
|
|
1 |
157 |
|
|
How do I count the number of cells by
Alan[_2_]
I have several dozens columns and 52 rows containing Data.
All the columns are labled Odd or Even
In the final (right most) Column I want to count the number...
|
|
7 |
214 |
|
|
|
|
1 |
212 |
|
|
|
|
1 |
90 |
|
|
Lost data on import by
alban
Excel 2002
New web query downloads the string "10E6/L" OK but on
import creates a blank cell. However the string "10E6\L"
imports OK. I've tried adjusting...
|
June 21st, 2004 03:52 AM
by Alban
|
5 |
196 |
|
|
How to add 100 years to a column of dates by
Albert Einstein
I imported a faxed spreadsheet into OmniPage and directed it to output
the data into an Excel spreadsheet.
It did a good job, except that the dates in the...
|
|
3 |
92 |
|
|
No Dialog Box when Pasting Cut Cells by
Albert Lan
I am using one of the Microsoft Press books to learn Microsoft 2003.
When I cut a group of cells it instructs me to go to the Insert menu
and click cut cells...
|
|
1 |
181 |
|
|
|
December 19th, 2007 03:55 PM
by RagDyeR
|
3 |
109 |
|
|
|
|
1 |
104 |
|
|
Filename without dir & sheet name by
Alchemist
Tried =cell("filename",ref) but could not find how to remove the entire
directory and the worksheet name.
I only require the .xls filename without the sheet...
|
August 4th, 2007 10:14 PM
by Smitty
|
2 |
94 |
|
|
mulitple concatenate conditions by
Alchemist
hiya.
Can you use concatenate with more than one if criteria?
I'm using this currently:
=CONCATENATE((COUNTIF(D5:D91,"*DVD*"))," = DVD")
How could I use the...
|
|
2 |
107 |
|
|
some merging question by
aldaris
in the screenshot below, i want to merge the cells at the bottom
(-idaman tegas-) so that it looks like the one at the top, -maxisegar-
(all data in one cell...
|
|
1 |
88 |