|
|
collapse rows into one by
Vic
Each occurence of A has 20-30 rows of data appearing in columns B thru K. I
need to collapse all rows into one per each occurence of A. Value in A
appears...
|
|
2 |
130 |
|
|
blank = no formating, 95% Red, 95% Green by
Go Bucks!!![_2_]
I need to conditionally format cells based on their value. These values are
in percent. I want the following conditional formating rules:
blank = no...
( 1 2)
|
|
13 |
229 |
|
|
Balance sheet functions? by
Behrens
I would like to add 2 columns and display the results in a 3rd column and
keep a running balance. A "check" register is really what I would like to
set...
|
|
3 |
114 |
|
|
If IsError Help by
Karin
My formula:
=IF(SUM(Q20:R20)S20,"over budget",SUM(Q20:R20)/S20)
If there is a division error on the last part, I need to have it return ""
Not sure how to...
|
September 21st, 2009 09:04 PM
by Mike H
|
1 |
87 |
|
|
2 macro help by
puiuluipui
Hi, i have in a macro this part of the code that delete empty rows:
Dim lRow As Long
With Application
..ScreenUpdating = False
..Calculation =...
|
September 21st, 2009 08:46 PM
by Joel
|
7 |
111 |
|
|
Excel 2007 NOT locking spreadsheet by
Patrick
I have a few users complaining that multiple users are able to get into
spreadsheets and modify them simultaneously. What would cause that to happen
and how...
|
September 21st, 2009 08:16 PM
by Patrick
|
0 |
100 |
|
|
Subtracting dates from two columns by
Shannan
Hi,
I am trying to find a formula that will subtract the dates from two columns
and give me the difference in months. I had " =MONTH(AD15)-MONTH(Y15)", but...
|
|
5 |
106 |
|
|
|
September 21st, 2009 07:58 PM
by nsd
|
3 |
259 |
|
|
|
September 21st, 2009 07:33 PM
by Eric
|
0 |
121 |
|
|
macro-file could not be found by
puiuluipui
I haved a macro that copy information from a closed workbook. If the macro
doesn't find the closed workboo, i receive an error '1004': file......could
not be...
|
|
2 |
120 |
|
|
|
September 21st, 2009 07:28 PM
by Luke M
|
1 |
111 |
|
|
divide and round up by
Pammy
I have a formula: c5/4
I want a formula to divide: c5/4 then round up to a whole number. example:
if the answer is 17.3 I want the answer to be 18.
|
September 21st, 2009 07:01 PM
by Eduardo
|
2 |
115 |
|
|
Duplicate cells by
Yvonne L.
I need three different cells on the same worksheet to say the same thing. For
example: I type a name in one cell and the other two cells duplicate the...
|
September 21st, 2009 06:53 PM
by Eduardo
|
1 |
101 |
|
|
|
|
0 |
114 |
|
|
Text function MID, RIGHT, LEN by
tomjoe
Hi
I try to extract part of a text:
I want to extract the numbers 300, 200 and 5 in the column to the right of
the textstrings under.
MY WORLD - AUSTRALIA...
( 1 2)
|
September 21st, 2009 06:08 PM
by tomjoe
|
11 |
195 |
|
|
|
|
1 |
136 |
|
|
|
|
1 |
108 |
|
|
Scripting Help by
Jeremy
I am using a color function =ColorFunction(A2,A9;AA9). Is there a way to
write a script or something like to where if the wrong color is selected you
could...
|
|
1 |
113 |
|
|
|
September 21st, 2009 05:46 PM
by GINN
|
4 |
133 |
|
|
|
September 21st, 2009 05:44 PM
by Pennyc
|
5 |
106 |