|
|
Excel worksheet by
boschuster50
Is there a formula, or function that will,
In a spreat sheet, if there is a section in the sheet that does not pertain
to some of the users of the...
|
|
2 |
77 |
|
|
Countif Range not working by
tommcbrny
Hi,
I have the following entered to set a text value in column d when some other
text value is found in a cell range within columns b and...
|
|
4 |
100 |
|
|
Data Base Functions by
Gerardo
Hello,
I need to sum info that meets more than one criteria. Excel has Data Base
funtions that work by referencig to a range that contain criteria to be used...
|
August 1st, 2008 05:25 PM
by Gerardo
|
2 |
102 |
|
|
find a sequence by
LiAD
I want to get excel to look through a series of numbers and words, find the
words that match, calculate the difference between the two numbers associated...
|
|
3 |
73 |
|
|
Need help creating a function by
chrspty
I have a spreadsheet that compiles a specific incentive given to customers.
I need to be able to total the number of people who received the incentive
based...
|
|
2 |
88 |
|
|
Vacation Calculator by
Sarah
I am attempting to calculate vacation time for employees based on years of
service. I do not know how to write the function to do so. I have an
accrual...
|
|
1 |
72 |
|
|
|
August 1st, 2008 04:43 PM
by Spiky
|
3 |
115 |
|
|
|
August 1st, 2008 04:35 PM
by RagDyeR
|
3 |
104 |
|
|
IF with Search/Find??? by
TotallyConfused
I have tried several ways to identify a rows in a column with the first three
characters are the same "BSB". The data reads in the column like:
ColA
row 5...
|
August 1st, 2008 04:33 PM
by RagDyeR
|
6 |
143 |
|
|
skipp blank cell by
Sanjiv
for example :
I write a formula : =if($m9=25,$j9,"")
and copy the same A!:A7
ouput of the above :
A
1 100 ...
|
August 1st, 2008 04:09 PM
by Spiky
|
3 |
154 |
|
|
Fill color with if function by
maz
Hi.
I want to fill a cell with some color based on the value in other cell.
if a24 then a1 is blue.
Can anyone help me?
thanks
|
August 1st, 2008 03:48 PM
by Spiky
|
4 |
80 |
|
|
|
|
9 |
98 |
|
|
|
August 1st, 2008 03:08 PM
by Pete_UK
|
8 |
81 |
|
|
COUNT IF but not if 'X' IS NULL by
Pyrite
Hi,
I have a list of vehicle types and a list of MPG figures. I want to do an
average MPG for each vehicle type so I need to know not only how many of the...
|
August 1st, 2008 02:34 PM
by Pete_UK
|
5 |
89 |
|
|
I Need get work this formula by
ytayta555
Best to you
I have this formulas :
=AND(COUNT(B1;B3;B5)=1;COUNT(C1;C3;C3)=1;COUNT(D1;D3;D5)=1;COUNT(E1;E3;E*
5)=1;COUNT(F1;F3;F5)=1)
An perfect...
|
|
6 |
78 |
|
|
Can I use solver for this? by
Belinda7237
I am not sure the best way to solve my problem and am hoping someone can help.
I want to be able to determine approx how long each item takes to produce.
I...
|
|
5 |
62 |
|
|
Using Autofilter to exclude dates by
Ian
I'm working with data that has about 19,000 rows. The information is date
specific, and there are scores of rows for each date..
I was working with February...
( 1 2)
|
|
11 |
126 |
|
|
Password by
Gitano
Is there any way to protect some worksheets with a pasword that can not be
breaked?
|
|
3 |
59 |
|
|
|
August 1st, 2008 10:42 AM
by ash
|
0 |
128 |
|
|
Formula with multiple variables by
Sam
I have two reports pulled into a workbook. I am trying to match three
columns of data and bring back the results from a 4th column. I am using the...
|
August 1st, 2008 09:58 AM
by Max
|
8 |
96 |