|
|
event vba by
irosh
hi all
how can i intercept an add entire row event ?
|
November 11th, 2008 10:25 AM
by irosh
|
4 |
86 |
|
|
breaking a field out by
JCM
I have a column of cells that all have a last name followed by a comma and
then a first name. I need to have the last name in one column and the first
name...
|
|
3 |
129 |
|
|
Reference column by
climate
Hi
I have a matrix (A2:BJ200) on sheet1, and column A consist of name of
stations which name of any station repeated in 3 cells.( i say Reference
column).
On...
( 1 2)
|
November 11th, 2008 06:24 AM
by climate
|
14 |
255 |
|
|
|
November 11th, 2008 05:17 AM
by Kashyap
|
3 |
109 |
|
|
IF and OR statements by
bob
I'm trying to create a formula that does the following from sheet2:
If the text in sheet2 column A equals the text in sheet1 column H
and
the text in...
|
November 11th, 2008 04:57 AM
by T. Valko
|
1 |
111 |
|
|
Lookup less than a number by
Rod
Hello.
I would like to be able to do the equvivalent of:
look up a number in range MaxTermAvail and if the number is the left value
then bring back the...
|
November 11th, 2008 03:46 AM
by T. Valko
|
6 |
108 |
|
|
count if question by
gurmy77
I am trying to help out the office at work with this one but I seem to be
missing something. First off they are using excel 2003. I know the first
answer is...
|
|
3 |
132 |
|
|
|
|
6 |
128 |
|
|
|
|
3 |
106 |
|
|
Expanding a named range by
jayceejay
I Have a set of values in a column that keeps track of customers for a given
product. I have a CountA function set up to count the non-null values in the...
|
|
3 |
104 |
|
|
|
|
4 |
131 |
|
|
How to determine the value? by
Eric
Does anyone have any suggestions on how to determine the value?
There is a list of values under column A
191,189,183,177,175,171,167,165,155,153,151
There is...
|
|
2 |
105 |
|
|
How to use a range in a custom function? by
Danny
I am trying to do a custom lookup function where the range remains constant
a1:b365 and I am trying to lookup a long list where some references are blank
and...
|
November 11th, 2008 01:48 AM
by Danny
|
5 |
109 |
|
|
formatting question by
Belinda7237
I have a column with various numbers in the millions and want to format:
12,342,000 to $12.3
Is there a way i can easiliy format a column this way?
|
|
1 |
93 |
|
|
countif function by
jerry
I have a 4 column spreadsheet. Col a = date, Col b = time in, Col c = time
out, Col d = minutes spent. I would like to count all the entries that fall...
|
November 11th, 2008 12:39 AM
by T. Valko
|
8 |
102 |
|
|
IF Statement with AND Statement by
Ken Quick
I have a Statement that Shawn Devonshire helped me setup.
Suppose you set up a table like this starting in cell A1
A B ...
|
|
4 |
92 |
|
|
Help with function, if possible by
Steve D
Hi all,
Using Excel 2003. I have 12 sheets, each labled with the month name, I use
each sheet for a calendar for that month. Sheet looks similar to this, D1...
|
November 10th, 2008 11:20 PM
by Steve D
|
8 |
168 |
|
|
Conditional formatting by
Dinesh
I am using office 2007. I have created Pivot Table. Column A which is called
"Area" has a filed setting set up as "Automatic" as subtotal. Pivot has
columns...
|
|
1 |
86 |
|
|
Identifying unique values among duplicates by
bob
If sheet2 cols A and C match the value in sheet1 cols H and I, I want to
return the number of unique values in sheet 1 column A. Can anyone provide a
formula...
|
November 10th, 2008 10:43 PM
by T. Valko
|
4 |
103 |
|
|
No. of columns in a Pivot Table by
mathel
Hi,
I am new to Pivot tables and I am trying to do a report to track certain
information. I created a workbook that has 19 columns and intended to do 3...
|
|
1 |
96 |