|
|
Counting by
AdamMCW
I have a list of scores 1.1, 3.2, 1.2, 2.4, 1.1, 3, etc... . I need to know
how many are between 1 and 2. Is this a countif? I can't seem to figure out
how...
|
|
4 |
50 |
|
|
Copy Worksheets by
adams77
I am creating a worksheet for each month with a formula that calculates
the YTD in a column. My problem is when I copy the sheet of the
previous month in the...
|
June 13th, 2006 03:32 PM
by adams77
|
0 |
67 |
|
|
|
|
1 |
49 |
|
|
|
|
1 |
78 |
|
|
|
|
1 |
65 |
|
|
Help! by
Adamw3
I am trying to make it so that column 'D' in my worksheet gives me the total
of column 'A' divided by column 'C' (where not 'Part Change', but only
between...
|
|
3 |
87 |
|
|
If statement help by
Adam[_3_]
Looks like this
Adam 1
Smith 2
Johns 6
adam 3
smith 4
johns 7
What i would like to do is if
|
|
1 |
42 |
|
|
|
|
2 |
116 |
|
|
|
August 3rd, 2007 12:28 AM
by Wigi
|
2 |
122 |
|
|
|
|
1 |
76 |
|
|
Add different values that equal 1 on a row by
Add sum of different values
I am trying to add how many seat hours per equipment type each person has.
Which formula should I use? I've tried several and I get errors.
Example:
Crane...
|
|
2 |
82 |
|
|
Haw to Randomized available data by
Adda
I have 10 columns of data. I wanted to randomized each column so that I will
get a new combination of data. Its like permutation but actually applying it
to...
|
April 10th, 2005 09:57 PM
by Ragdyer
|
2 |
73 |
|
|
|
|
3 |
133 |
|
|
HELP! countif by
addicted
I'm trying to do a bit of a survey analysis.
Anyways in counting responses this is what i need.
I need to run the COUNTIF function for a particular column,...
|
|
3 |
66 |
|
|
Formula Needed to Omit Characters by
addie
Is there a formula that would recognize and omit specific characters
within a field?
Example:
Data Field has the following 9 characters "R0502AA01".
Only...
|
February 17th, 2006 05:55 PM
by SteveG
|
6 |
142 |
|
|
Altering VLookup Formula by
addie
How would I alter a v-lookup formula to recognize specific characters
within a field?
Example:
Data Field has the following 9 characters "R0502AA01”.
Can...
|
|
1 |
135 |
|
|
Summing Up Data Based on Codes by
addie
I have a spreadsheet with several rows of data. Each row's data
corresponds to a code that appears in the 1st field of the...
|
February 18th, 2006 12:09 AM
by addie
|
2 |
89 |
|
|
Summation Formula Needed by
addie
I have a spreadsheet with several rows of data. Each row's data
corresponds to a code that appears in the 1st field of the...
|
|
6 |
72 |
|
|
|
|
1 |
243 |
|
|
adding a search box to a spreadsheet by
Adding a search box to a spreadsheet
I have a workbook with 92 tabs containing data and text. i would like to add
a search box to my index tab. This search box would allow a user to type in
what...
|
|
1 |
51 |