|
|
Countif multiple criteria in same cell by
CP
Hi all,
I have a sales worksheet that calculates 'action
codes'using COUNTIF. That is easy. Is there a way to enter
more than one 'action code' in a cell and...
|
|
3 |
356 |
|
|
Percentage difference between two numbers by
Michelle
I have two numbers that I need to calculate the percentage
of difference between them.
Example:
$1.22 increased to $1.30 = I need a formula that will tell
me ...
|
November 7th, 2003 01:56 PM
by Jim
|
2 |
388 |
|
|
|
|
2 |
151 |
|
|
|
November 7th, 2003 02:39 PM
by
|
1 |
297 |
|
|
Password protect & read only by
ANGELA
I would like to know how to protect a worksheet with "read only/view" capability. I am able to password protect the worksheet, however other users cannot view...
|
|
1 |
302 |
|
|
table lookup function by
Harlan Grove
"Stewy p" wrote...
I need help in looking up the a table that is sorted by product and by
dept and date. (In my actual...
|
November 7th, 2003 05:13 PM
by Stewy p
|
1 |
100 |
|
|
VLookup is odd by
Rob
Ok, I have a VLOOKUP function that works, but here's what
is weird. It's giving me all 0's. When I go and double
click the cell that contains the lookup value...
|
November 7th, 2003 05:19 PM
by
|
4 |
140 |
|
|
count conditional format colour by
shital
i have given some conditional format to the cell. which
have red, green & black colour. Can it count the cell how
much cell in red colour & green &...
|
|
2 |
301 |
|
|
how to find 80% value using formulas? by
Keith R
I am using an array formula to pull a range of values off of Sheet1.
The values represent a continuous measure, in this case, minutes.
I'd like to know what...
|
November 7th, 2003 05:40 PM
by Keith R
|
5 |
284 |
|
|
nested if and ranges by
Scott
Here's another option for your nested if statement. I
have set up this formula to give you a zero if the value
is below 10 and that's why you see the zero...
|
November 7th, 2003 06:27 PM
by Scott
|
0 |
203 |
|
|
|
|
2 |
538 |
|
|
Data validation query by
Flub
Hi All
I have a work sheet best decribed as a timesheet.
I also have two columns e.g. A and B containing
Names (A) and Pay numbers (B).In Cell C1 I have
a Data...
|
November 7th, 2003 07:13 PM
by Flub
|
6 |
167 |
|
|
MAX function by
Asif
How do you search through an entire worksheet (the formula resides in another worksheet) to find the largest number with the MAX function?
Thanks.
|
|
2 |
124 |
|
|
Automatic calculation by
Brenda
Good morning...
I have a workbook that I have saved as a manual
calculation which does NOT save before closing. I had to
set it up this way because I have SO...
|
November 7th, 2003 07:56 PM
by Jim
|
3 |
279 |
|
|
|
November 7th, 2003 07:57 PM
by Jim
|
4 |
171 |
|
|
xirr function by
Bill
The Office 2003 Student/Teacher upgrade does not appear
to have an xirr function. Is this seperate function
available as a download or do I have to purchase...
|
|
1 |
116 |
|
|
Macro to read to end of column list by
joe kristofeld
I know this is simple but I don't have a resource for commands such as "end
down",etc.
anyways, if I want a macro to include only the data I've entered and...
|
November 7th, 2003 09:00 PM
by May
|
4 |
279 |
|
|
Combo boxes by
Steve
I have just been browsing the web site and come across
some very useful tips and tools. One of those was linking
cells together.Depending what you select from...
|
|
4 |
122 |
|
|
not eqaul by
ant
how to you right not equl ina formaul
for ex,
if A2 is not equal to 0 than hello
|
|
1 |
106 |
|
|
SUMIF Formula by
Ed
Why wouldn't this formula work? The value of A6 is Oct. What I am trying to
do is summarize on my 'Summary' page some transactions by month. The dates
for...
|
|
1 |
194 |