|
|
Dynamic range creation for Countif statement by
elitebpoinfo
Hi,
I am trying to dynamically create the range statement in Countif
formula but for some reason it doesn't work. At present I am hard
coding the information...
|
|
1 |
454 |
|
|
Help with Nested Functions by
Comcast News Reader
I've been trying for the last several hours to get this right. Here's the
logic I'm trying for:
1. If Column D is earlier than of equal to 7/1/2003, and...
|
|
3 |
211 |
|
|
How do you convert mins to hours by
mary
I have two columns of data, HOUR AND MINS. I WILL LIKE TO
ABOUT TO CONVERT THE MINS TO HOURS. THIS FUNCTION IS NOT
GIVING ME THE EXACT...
|
|
2 |
207 |
|
|
|
|
1 |
470 |
|
|
assigning score by
Bob Phillips
Hi Mat,
Is this any good?
=VLOOKUP(B2,{1,0.19;2,0.17;3,0.15;4,0.13;5,0.11;6,0.09;7,0.07;8,0.05;9,0.03;
10,0.01},2,FALSE)*A2
--
HTH
|
December 27th, 2003 03:04 PM
by jiggler
|
4 |
217 |
|
|
|
December 27th, 2003 03:30 PM
by rjb
|
2 |
615 |
|
|
|
|
2 |
205 |
|
|
EXCEL 2002 INVOICE TEMPLATE by
BRIAN
IM SWICHING TO EXCEL 2002 FROM 2000 AND CANT SEEM TO FIND
THE INVOICE FUNCTION UNDER TOOLBAR TO BRING UP THE BOX
FOR AUTOMATIC NUMBERING OF THE INVOICE NO. ARE...
|
|
2 |
1,562 |
|
|
|
|
1 |
392 |
|
|
Column Headers appearing in sort by
Ringmaster
When I do a search, the "Column Headers" appear in the search results,
but not as column headers, they get mixed in, and included in the
"alpha" sort. How do...
|
|
3 |
295 |
|
|
|
|
0 |
340 |
|
|
|
|
1 |
370 |
|
|
lookup latest date Excel 2000 by
Wanda Round
I know I've seen this, but the brain is totally locked.
First column data is area inspected, 2nd column is date
of last inspection.
Need to know date of last...
|
|
5 |
348 |
|
|
insert cell value into hyperlink? by
R. Levesque
is there any way to insert a cell's value into a
hyperlink. for example, i want to be able to place the
cells value into a web search without inserting...
|
|
2 |
252 |
|
|
Grades by
Amy
what is the funtion to post a letter grade corresponding
with the percentage you receive
|
|
3 |
79 |
|
|
count with multiple conditions by
John Hatch
I am trying to find a formula to count the number of rows that have BOTH a
"4" in column C AND a "ph" in column H
My info shows...
|
|
3 |
325 |
|
|
|
|
0 |
458 |
|
|
SUMPRODUCT by
Mike
Hi.
In SUMPRODUCT, is there a way to specify the arrays to
cover non-sequential cells? For instance, I want to use
sumproduct by specifying the following...
|
December 29th, 2003 12:10 AM
by Mike
|
4 |
120 |
|
|
Simple Average?? by
GBL
Hi Guys & Gals:
My problem is to obtain an average from selected row-cells that are
separated (non-contiguous). For example:
A D F H K
2 3 ...
|
December 29th, 2003 01:15 AM
by GBL
|
3 |
89 |
|
|
|
|
2 |
341 |