|
|
Averageif puzzle by
GB3 via OfficeKB.com
I'm attempting to average values depending upon a category name (using Excel
2007).
I thought this formula would work to average values for Group 1 over...
|
|
5 |
107 |
|
|
Excel to Word by
Raz
Is it possible to link from word to excel???
I have a table in Word, would like to fill some of its cell from an Excel
Workbook.
Possible??
How would I do...
|
|
2 |
135 |
|
|
|
|
1 |
139 |
|
|
|
|
0 |
115 |
|
|
how do I dropdown list by
JM
I need a drop down that will show a code and a description of that code, but
after I select it I only want the code visible.
|
|
1 |
106 |
|
|
Can you solve this???? by
mahendra2210
"I have a distribution list of 5 cities in cell A1, 5 manufacturers in cell
B1, 5 products category in cell C1, and 5 product list in cell D1."
Now, I want...
|
|
2 |
139 |
|
|
Summing Up My Time (minutes) by
Kimbe
I am having a problem figuring this out and I'm sure it is quite simple and
maybe I am trying to hard but I have a worksheet that an employee enters how
many...
|
|
4 |
120 |
|
|
Comments by
LPhillips
Can you tell me how to add comments to an individual cell when the worksheet
is protected? The option does not appear on the toolbar nor when right
clicking.
|
|
2 |
154 |
|
|
|
|
5 |
112 |
|
|
|
|
1 |
187 |
|
|
Counting Text Occurances - HELP PLEASE by
Beauty Girl
I have numerous (approx. 30) 2 letter codes used to identify different type
of work events. Some are "soft" events, some are "hard" events. I want to
count...
|
|
1 |
161 |
|
|
Count Blank Cells & Letter P by
Karen
I have a range of cells from B10:B32 that have a few different values in
them. I want to be able to count the cells that only contain nothing (blanks)
and...
|
|
6 |
93 |
|
|
Sumif and Specified Ranges by
MstgSally
How would I sum a column of numbers, based on the following ranges:
1. 0 - 2500
2. 2501 - 5000
3. 5001 - 10000
4. 10001 - 15000
5. 15001 - 20000
6....
|
|
2 |
123 |
|
|
Indent by
Indent
What formula can I use to display the number of spaces indented if the user
user formatcellsindent (not the spacebar)?
|
|
2 |
83 |
|
|
IF, THEN SYNTAX by
BBABBZZ
HELP!!!
=IF(AB2, C1 THEN B2)
C1 IS A DATE....IF AB2 IS GREATER THAN OR EQUAL TO THAT DATE THEN INSERT
AMOUNT IN B2, IF NOT ENTER "0"
|
|
5 |
89 |
|
|
|
|
1 |
149 |
|
|
Excel 2007 CF Multiple criteria by
Pierre
I've always thought CF was one of the more understandable tools used
in Excel. Until now. Using Excel 2007.
Trying to hilight a cell if it's contents are the...
|
January 12th, 2010 09:51 PM
by Pierre
|
3 |
90 |
|
|
how do I get a php code by
Jim at Li Jin Trad
I have Data in Zip files which I need to get up and running as drop down
menus for locating which part is compatible etc.
I was sent the data by my main...
|
|
0 |
90 |
|
|
|
|
1 |
133 |
|
|
If statement by
gbish
I want to look in multiple cells and return a predetermined value:
I want cell F5 to return a value if there is an X in any of the cells A1
thru A5, if there...
|
January 12th, 2010 08:10 PM
by Mike H
|
1 |
98 |