|
|
excel 2007 by
Stan Halls
i have a script for saving a file to 2 locations, 1st location saves in
excell2007 macro enabled, 2nd location saves in excel2003 compatable version,
i have...
|
|
0 |
34 |
|
|
Data Extraction Problem by
Duke Carey
Since you have Excel 2003, make your range of data a list (Data-List...).
Excel will outline the range with a border and add a new row with an
asterisk. ...
|
|
0 |
34 |
|
|
get date function result as text by
Andrew[_2_]
Hello,
I am grabbing weekday names with this function =DATE(E5,C5,D5) where
E5 is 2007 C5 is 1 and D5 is1 the result is Mon
I wish to look at some data by...
|
|
2 |
34 |
|
|
|
|
1 |
34 |
|
|
|
|
1 |
34 |
|
|
Only the last rows... by
Lars
I have a spreadsheet with about 50 rows that gradually will be filled up with
numbers. How can I make formula that will count and ad up only the 12 last
rows...
|
|
2 |
35 |
|
|
Autofilter multiple columns by
Saintsman
I need to filter 2 columns (from about 30) using VBA
Select Client (drop down box) &/or Select Contractor (drop down box)
I can select on either one using
...
|
|
2 |
35 |
|
|
|
|
2 |
35 |
|
|
Cell placement by
Dianethetech
I am trying to take data from 3 different columns and put it in either of two
other columns. For example:
F47 is a date formatted MM/DD/YY and T47 is a...
|
|
4 |
35 |
|
|
Count occurences and return total by
Daniel A.
HELP! I know someone here can help me! I want to count the number of times
a specific ID number occurs in a column, and return the total count in the
cell...
|
|
2 |
35 |
|
|
|
|
3 |
35 |
|
|
Rounding by
Steve[_3_]
Hello,
I have a spreadsheet for calculating labor rate. Column A contains tenths of
an hour (.1, .2, .3 etc...) Column B has a simple formula (=A1*32.39),...
|
|
3 |
35 |
|
|
Averaging last 5 cells in a column by
Bob Smith
Hi folks,
In my workbook, I have a bunch of worsheets, where I'm average all numbers
in one column. I'd like to add one more stat, to where I'd like to...
|
|
4 |
35 |
|
|
dynamic range and series by
Cass Calculator
I am doing regression analysis for tree size (independent variable)
and tree age (dependent variable). I want to make a template that
will allow me to chart a...
|
|
1 |
35 |
|
|
Access to Excel by
Steve.M
Basically I want to type a name in an access table/field titled name. I want
the name to simply be inserted in a cell named name in excel. I want that
done...
|
February 17th, 2007 05:06 AM
by Steve.M
|
0 |
35 |
|
|
Help needed would this be an IF statement by
pano
How do I write this formula I have been given the first part but cant
work out the rest myself
=IF(A1"",8.26,"")
If A1 is blank make b1 blank if A1 is not...
|
February 11th, 2007 06:37 PM
by T. Valko
|
5 |
35 |
|
|
VLOOKUP, Sorting, Calculate by
rldjda
I have a project to create a "running" report that calculates various
formulas for each particular jobID, but the job ID's aren't entered yet ( to
be entered...
|
February 7th, 2007 09:41 PM
by driller
|
3 |
35 |
|
|
Macro hot button in Spreadsheet by
watchtower
How can I create a hot button/key in my spreadsheet and attach a Macro that
will be available to everyone that opens it?
For example, I have a formatting...
|
February 2nd, 2007 05:27 PM
by CLR
|
3 |
35 |
|
|
excel worksheet by
fubar1
Jn my excel worksheet, there are a few boxes, that change the data I
enter...For example row F, line 155, I type in the number 46....push the tab
for the...
|
|
2 |
35 |
|
|
Formula in cell by
albericht
Excel Help says enter 10-5 and it will read the answer as 5 in the cell. I
tried it, but it just read 10-5. So I then tried clicking Enter, but it then...
|
November 5th, 2007 08:29 PM
by CLR
|
2 |
35 |