|
|
|
|
1 |
105 |
|
|
simple countif formula by
Brian
Column B in my spreadsheet consists of 10 rows with one letter in each cell.
I would like a formula to count cells B1,B3,B5,B7 and B9 only if the value
in...
|
|
2 |
209 |
|
|
|
|
69 |
2,780 |
|
|
|
February 4th, 2010 09:48 PM
by Eric F.
|
1 |
201 |
|
|
|
|
1 |
98 |
|
|
indirect function by
WINDMILL
I'm not familiar with why / when the INDIRECT function is used.
I've inherited a spreadsheet, it has 10+ spreadsheets, and throughout them
there are several...
|
|
2 |
97 |
|
|
|
|
1 |
140 |
|
|
Value list by
Maint Girl
i need help with making value lists in excel so that i can make my data base
consistant with the data i am entering
|
|
1 |
76 |
|
|
|
|
3 |
103 |
|
|
|
|
1 |
102 |
|
|
calculating the "mean" for a group of numbers by
rob
I am trying to find the mean for a groud of numbers, but the formula needs to
exclude any number less then 26.
29,64,90,48,25,0,96,65,50,86,99,0,0
|
|
2 |
129 |
|
|
Turning =E13 to =$E$13 by
Bishop
I have worksheet with several hundred formulas in the form of =E13. I want
to make all the formulas static, i.e. =$E$13, because I have to delete some
rows...
|
February 4th, 2010 06:58 PM
by Pete_UK
|
3 |
134 |
|
|
Password by
Maria Elena
forget the password in worksheet( excel )
|
February 4th, 2010 06:41 PM
by Eduardo
|
1 |
109 |
|
|
HELP by
Roozo
The above explains everything great, however i do not have the same number
rows in each set of data, e.g.
A1 address 1
A2 address 1
A3 address 1
A4 address...
|
February 4th, 2010 06:18 PM
by Roozo
|
0 |
82 |
|
|
|
February 4th, 2010 06:14 PM
by Tony41
|
0 |
123 |
|
|
match by
ganga
Hi,
I have 2 work books. One is weekly schedule and other one is yearly vacation
schedule. I would like to link both books matching names and dates. Vacation...
|
|
3 |
106 |
|
|
Returning a Value from Another Worksheet by
TLH3934
I have two worksheets in one Excel 2007 file that I'm working with, in which
I want the second worksheet to return values of the first worksheet. Hope I
can...
|
February 4th, 2010 05:55 PM
by Kristin
|
2 |
114 |
|
|
|
|
3 |
104 |
|
|
Sumproduct Search, Sum Durations by
mp80237[_2_]
Hello, I have a table that I need to get information out of using Excel.
Below is a sample from the detail data.
systemslist severity Duration Minutes
Fare...
|
February 4th, 2010 05:37 PM
by Pete_UK
|
5 |
129 |
|
|
Count rows based on multiple criteria by
dmg
I have a need to count the number of rows in an Excel spreadsheet based on
contents of multiple cells. The formula is on one worksheet and all data is
on a...
|
|
3 |
148 |