|
|
Formulas by
Simon
I am trying to find a formula that will count 2 columns
and return one value.
For example : I want to count all cells in column B that
contain RI + cells in...
|
|
1 |
95 |
|
|
|
|
2 |
413 |
|
|
|
|
1 |
257 |
|
|
How do i fill one column based on another? by
Debra Dalgleish
1. Select a cell in the table, and choose DataFilterAutoFilter
2. From the dropdown in cell F1, choose Legal
3. From the dropdown in cell Q1, choose...
|
November 19th, 2003 02:24 PM
by aapp81
|
3 |
419 |
|
|
Countif with 2+ Criteria by
muziq2
HI:
I'm looking for a way to use the countif function to look at 2 criteria
before counting only the data that matches both.
For example, say I have a table...
|
|
2 |
112 |
|
|
VLOOKUP - "Close Matches" by
John
I'm running a standard vlookup, with the intention being
that the user will enter a potential new account name into
a field, and the lookup will identify...
|
|
6 |
285 |
|
|
|
|
2 |
175 |
|
|
Lowest number in a row by
Jason Morin
Assuming your price is in A1 and the prices you wish to
compare are in row 3:
1. Select row 3.
2. Format Conditional Formatting
3. Select "Formula Is" in...
|
November 19th, 2003 04:05 PM
by Dan E
|
1 |
515 |
|
|
Combo box instead of command buttons by
John
Hi,
I have a three command buttons, one links to a particular
cell on a worksheet and the other two open up a browser
window. The VB for these buttons...
|
|
9 |
379 |
|
|
|
November 19th, 2003 04:47 PM
by Tysone
|
6 |
310 |
|
|
|
|
1 |
459 |
|
|
|
|
2 |
564 |
|
|
Adding time by
Lorrie
I'm going crazy. I'm trying to add up a column of time.
Employee enters time in and out for a two week period.
The total number of hours appear in column I...
|
|
4 |
134 |
|
|
Special today Date challenge question by
ZONNET
What I want is have a today function eg in cell A1.
based upon entering any text in for eg b2, puts me the julian dat in cell
A2, So far, so good, I got that...
|
|
1 |
397 |
|
|
Count example dosen't work by
Domenic
One of the formulas in excel help =COUNT(A2:A8,2) that is to count the number of cells that contain numbers in the list A2:A8, and the value 2 dosen't work. ...
|
|
5 |
315 |
|
|
AutoCalculate Problem by
Iris
Due to the way someone 3 stops down the chain from me is
exporting, the autocalculate function does not work with
my data. For some reason, if I go in and...
|
November 19th, 2003 07:43 PM
by
|
2 |
144 |
|
|
Stop formulas from changing on it own. by
Gina
I hope someone can help. I set up a spreadsheet. Each
column has a different basic formula. eg column A and
1st line has an amount the column B has a...
|
|
2 |
431 |
|
|
vlookup not accepting a reference by
burke
i'm having a problem with vlookup not accepting
a "reference" to a cell as the "lookup_value"
this =VLOOKUP(C2,range,2) returns #N/A
but if i manually type...
|
November 19th, 2003 08:54 PM
by burke
|
4 |
205 |
|
|
Display data list in Matrix by
GJones
If I understand your question you can go to Data / Text To
Columns in Excel and it will do it for you. It offers you
different choices on which delimeter to...
|
November 19th, 2003 11:57 PM
by GJones
|
0 |
316 |
|
|
fomulas by
Gina
I hope someone can help. I set up a spreadsheet. Each
column has a different basic formula. eg column A and
1st line has an amount the column B has a...
|
November 20th, 2003 01:59 PM
by Paul
|
1 |
126 |