|
|
|
|
1 |
115 |
|
|
INDEX use Question by
Smitty
I'm calculating averages on 2 different golf courses. For each course, I'm
using the formulas:
..
F1 -...
|
|
5 |
167 |
|
|
how can this be done? by
sam
I have an excel sheet that I update and want others to view it only(view
permissions only).
My Question is:
Can myself and other person edit the sheet at...
|
June 24th, 2009 04:49 PM
by sam
|
0 |
120 |
|
|
How to code the formula? by
Eric
Does anyone have any suggestions on how to code the formula within Excel?
There is a list of values under M2:M27 in descending order with space in
between,...
|
June 24th, 2009 04:41 PM
by RagDyeR
|
5 |
108 |
|
|
Problem with a sumproduct by
Sasikiran
Dear,
I am struggling with a formula to count the number of mails received on a
particular day within a particular time slot. This data is copied from an...
|
|
4 |
99 |
|
|
|
June 24th, 2009 04:31 PM
by Salman
|
0 |
78 |
|
|
fix left column(s) and/or upper row by
mariekek5
Hello,
Two questions:
1) is it possible to fix the left column or maybe the two most left columns
on the left side of the sheet...so that when one goes to...
|
|
6 |
103 |
|
|
Selecting data points in a scatter chart by
Anthony Blackburn
I am making a scatter chart. I want to put a trend line in it, but I can't
seem to select all of the datapoints in the chart. I right click on a
datapoint...
|
June 24th, 2009 04:17 PM
by Joel
|
2 |
112 |
|
|
UPDATE LINKS AUTOMATICALLY by
Navya
Hello,
I have created few tables in excel that link to tables in word. Any changes
in word reflect in excel.when ever I try to copy both excel & word &...
|
June 24th, 2009 04:14 PM
by Navya
|
0 |
91 |
|
|
Conditional Formatting help by
rodchar
hey all,
you know how you can select a column for conditional formatting, well, i was
wondering if there was a way to highlight the whole row if the...
|
June 24th, 2009 03:56 PM
by rodchar
|
6 |
89 |
|
|
change the color of a range of cells by
Srajes
Hi,
I need to change the color of a range of cells depending up on the value in
another cell.
Consider cells
1 2 3 4 5
, I need to change the color of all...
|
June 24th, 2009 03:47 PM
by Eduardo
|
1 |
83 |
|
|
Macro to list report results by
GeorgeA
Hello,
The macro below copies and pastes a row of data from sheet 'Zoomerang Data'
into row 2 and calculations reference that row. The results are formatted...
|
|
3 |
121 |
|
|
Macro Runtime Error 1004... help? by
Derrick
error: Unable to set the Hidden Property of the Range Class
code:
under Worksheet, Change.
Private Sub Worksheet_Change(ByVal Target As Range)
If...
|
|
6 |
146 |
|
|
file extensions in excel by
Denny Dunn
I have a coworker that refuses to save excel in the new format (xlsx) I
explained that this format will give her more features than available with
the 2003...
|
June 24th, 2009 03:01 PM
by Eduardo
|
2 |
91 |
|
|
|
June 24th, 2009 02:57 PM
by Joel
|
3 |
118 |
|
|
help with formula by
Soth
Hi-
I have this long string of number 1001.020.0000.0055.24110100.00000.0000 in
a cell and I just need to separage only this 8 digit number 24110100 and I...
|
|
2 |
126 |
|
|
comparing 2 columns by
rodchar
hey all,
i have 2 columns and i want to compare row-by-row if they are the same or
not. is there a way to do this?
1,1 the same
1,2 different
2,2 the...
|
June 24th, 2009 02:47 PM
by rodchar
|
2 |
89 |
|
|
Return value from column by
DT
I have the following columns
Item Currency Exchange_rate
A USD 10
B USD 10
C Euro 5
D ...
|
June 24th, 2009 02:35 PM
by DT
|
2 |
122 |
|
|
Can I make a search function for a chart? by
Eini
Hello,
I'm quite a new user with Excel 2007, and I'm wondering, if it's possible to
create a seaches in Excel.
I've made a chart including a list of words...
|
June 24th, 2009 02:03 PM
by Eini
|
2 |
88 |
|
|
Auto Insert NEw Row with formatting by
Greg
I have an employee job list. I have Col. "B" as Employee Names. When I
click onto the cell (i.e. "B1") a drop down list appears with all the
employees...
|
|
2 |
134 |