|
|
|
|
1 |
77 |
|
|
|
|
3 |
156 |
|
|
SUMIF based on cell shading by
IlliniEric
Is it possible to write a SUMIF formula based on cell shading? If so, how? I
want to add up cells based on the shading of the cell. Thanks.
|
|
1 |
163 |
|
|
sorting multiple columns by
arbe
I have multiple addresses on a work sheet. I need to have all the same zip
code # together. How do I sort them by zip code so right name and address
ends up...
|
|
2 |
94 |
|
|
|
|
1 |
111 |
|
|
Ignore "-" by
msnyc07
I have a script that generates acronyms from company names. It was set it up
to ignore of, and, the, etc. (I didn't code it just spec'd it)
If Not...
|
February 17th, 2010 09:30 PM
by msnyc07
|
6 |
95 |
|
|
countif object by
ginble07
Is there a way to use a count function for objects? I have a series of
textboxes in rows and columns that will be moved around freely. I need to be
able to...
|
February 17th, 2010 09:26 PM
by ginble07
|
0 |
94 |
|
|
|
|
0 |
84 |
|
|
|
|
1 |
119 |
|
|
HELP!! Formula with different conditions by
Teri
Hi there. I'm hoping someone can help me. I'm pulling my hair out trying to
figure out how I can take a certain number of hours (for OT banking purposes)...
|
February 17th, 2010 08:04 PM
by T. Valko
|
5 |
123 |
|
|
Conditional Formatting for entire row by
HeatherJ
I know how to use conditional formatting for a cell, but is there a way to do
conditional formatting for an entire row?
Example: if cell A18 contains the...
|
February 17th, 2010 08:03 PM
by T. Valko
|
5 |
156 |
|
|
|
|
2 |
99 |
|
|
for loop with if statement by
Steve
Morning all.
I'm looking to set up an automatic password sheet protection tool and there
are only specific elements that I need protected on the worksheets in...
|
February 17th, 2010 07:56 PM
by Steve
|
1 |
75 |
|
|
|
|
3 |
80 |
|
|
|
February 17th, 2010 07:29 PM
by tb
|
0 |
87 |
|
|
ANOVA with 3 factors by
Confused Slug
Is it possible to using Excel to perform an ANOVA with 3 (or more) factors?
Thanks
|
|
1 |
74 |
|
|
|
February 17th, 2010 07:14 PM
by Colin
|
4 |
124 |
|
|
CUBEMEMBER by
Shairal
Does anyone know if you can use a wildcard with the cubemember function, and
if so, how? I am trying to pick up all product IDs that start with KRLMJ129*...
|
February 17th, 2010 06:33 PM
by Shairal
|
0 |
79 |
|
|
Creating a dynamic IF statement by
Robert Robinson
I have data in two sheets. I want to create an IF statement in the second
sheet that has the ability to scan the first sheet for a value. If it finds a
match...
|
February 17th, 2010 05:09 PM
by Luke M
|
2 |
91 |
|
|
Conditional formatting offset reference by
IanC
I have a spreadsheet with a block of 10 rows by 8 columns with conditional
formatting with absolute references to row 6.
I need to change these to reference...
|
February 17th, 2010 04:58 PM
by T. Valko
|
3 |
102 |