|
|
copying text into a macro by
pagelocator
I was trying to write a macro in which I was copying a selection from a
combo box into a second macro which would then be run under instruction
from the first...
|
|
1 |
188 |
|
|
Roundup by
Hakan D
I want to use roundup formula in a few different rows in
a worksheet, anything above .30 will be round up to next
nearest number such as 14.30 will appear as...
|
|
3 |
143 |
|
|
|
|
1 |
75 |
|
|
Help!!! by
soxn4n04
I'm new to functions and formulas in Excel. I need to write a series of
functions:
If cells A3, A8, and A12 are greater 4, then the result is 3.
If cells A2,...
|
November 24th, 2004 01:53 PM
by soxn4n04
|
4 |
94 |
|
|
calculate average hours worked by
llstephens
I am self taught in Excel so my knowledge is very limited. I can create
simple formulas but I am having trouble with this one. I need to take the
daliy hours...
|
November 24th, 2004 02:37 PM
by izbryte
|
1 |
245 |
|
|
|
|
6 |
121 |
|
|
Lookup Data in Several Columns by
simplywitt
What formula would I write to lookup a data match from another file that
may be in several columns? Example:
File #A - Contains "RF01" in cell F6
File #B -...
|
November 24th, 2004 04:11 PM
by Domenic
|
4 |
199 |
|
|
GET.CELL by
Biff
Hi Folks!
Anyone know where I can find info on the argument values
for GET.CELL?
I saw a post a couple of wks ago that had a link for a
help file from MS but...
|
November 24th, 2004 07:16 PM
by Biff
|
2 |
1,288 |
|
|
|
|
1 |
244 |
|
|
Moving from 1 row sheet1 to sheet2 by
tomc112
I have an Excel problem and I was wandering if anyone could give me
their 2 Cents worth.
Let me explain. I will have 2 worksheets Lets say A and B. ...
|
|
5 |
138 |
|
|
|
|
1 |
109 |
|
|
Phone Numbers by
natei6
Hi
I have a column of phone numbers e.g. 1555-555-1212. What formula do I
use to change all the numbers to e.g....
|
|
6 |
419 |
|
|
Display material with usage by
lintan
Column A contains material name and Column B contains usage. I would like to
choose the name and the total usage of materials that were used. For
explanation...
|
November 25th, 2004 08:32 AM
by Max
|
4 |
261 |
|
|
Pivot Table Problem by
Yandros
Hi All,
I have compile a spread sheet which among other columns has one with
contains numbers. These numbers are not unique and may appear several times
in...
|
|
1 |
82 |
|
|
isnumber with sumproduct by
sh0t2bts
Hi
I have a am trying to count occurrences of someone entering data into my
table.
The below function counts every occurrence where Maximo A2 to A1398...
|
|
2 |
85 |
|
|
Scroll by
Messy
Hi,
My iserted images and trace precedents lines move around
with the scroll bar and the latter can give me some
erroneous cell links when vertical. Can anyone...
|
November 25th, 2004 03:24 PM
by Messy
|
0 |
89 |
|
|
Excel :Save date function by
Elodie
In a cell I would like to have a function that makes appear the last save
date (as it's possible with word insert/field/savedate).
Does someone know if this...
|
November 25th, 2004 04:25 PM
by Elodie
|
1 |
149 |
|
|
|
|
1 |
227 |
|
|
no more fonts by
j@bsi
when I am adding a combo box from the forms toolbar, I get a message that
says "no more fonts can be added to this workbook", I click OK and excel
closes...? ...
|
November 25th, 2004 05:03 PM
by Hayeso
|
1 |
91 |
|
|
VLOOKUP function by
Peters
Hello,
I am encountering problems with de VLOOKUP function. I have a database
with prices and company names. I have calculated the max. price per
product and...
|
November 25th, 2004 07:07 PM
by Peters
|
6 |
94 |