|
|
Count If equals x AND y by
Nadine
Excel 2003
Col A Col B Col C
1 No Count this cell
I need to count all the cells in Col C if Col A=1 and Col B=No
Thanks.
|
May 5th, 2010 09:11 PM
by Nadine
|
9 |
187 |
|
|
validation by
ganga
hi,
I have a workbook with 2 sheets. In one sheet I have a calender and other
sheet just list of names. what i want to do is: In the calender sheet if i...
|
May 5th, 2010 08:54 PM
by ganga
|
0 |
104 |
|
|
|
May 5th, 2010 08:47 PM
by Nadine
|
4 |
171 |
|
|
|
|
1 |
149 |
|
|
hr worksheet counting days missed by
Tina
I currently track employee time for the purpose of tracking vacation time.
Now my bosses would like to add a function that will alert if an employee is...
|
|
2 |
123 |
|
|
|
|
3 |
170 |
|
|
|
|
18 |
400 |
|
|
Graph Paper by
Rainchild
How do you make graph paper with 2 square cm in Excel?
|
May 5th, 2010 07:33 PM
by Billns
|
2 |
280 |
|
|
|
|
3 |
1,112 |
|
|
vlook on different tabs based on value by
jatman
good day,
i have the following so far in my macro:
....
supcode = Range("B4").Value
....
If supcode = "CLI" Then
ActiveCell.Offset(0, 4) =...
|
|
1 |
134 |
|
|
Lookup / Summary Table by
Joe
I want Excel to lookup a value in a table and return each row it finds that
value in.
As an example:
Lookup Value: Ford
Lookup Table:
A1: Ford B1: Focus
|
|
8 |
153 |
|
|
insert blank row and formulas by
scottmcm
when I insert a new row in my worksheet, I noticed it does not update the
formulas for any row below that line that reference another sheet in my...
|
|
1 |
138 |
|
|
|
|
2 |
126 |
|
|
VLOOKUP by
PAL
I am using VLOOKUP as I have many times in the past. The formula I am using
is:
=VLOOKUP($A3,Raw,2,FALSE)
It returns a "0" presumeably becasue it thinks...
|
|
2 |
106 |
|
|
Combining cells with text by
Nadine
I have two cells that both have text in them. Cell A2 contains the old
status. Cell B2 contains the new status. I'd like to keep the history of
the old...
|
May 5th, 2010 06:23 PM
by Nadine
|
2 |
152 |
|
|
Duplication by
Lorenza@hsccs
How do I duplicate a worksheet and contents 20 times in a workbook?
|
|
1 |
87 |
|
|
WEEKNUM function not working by
Cam
Hello,
I have a cell to calculate current week number, =WEEKNUM(TODAY())
and I have the analysis toolpak checked in the Add-In menu, but it still
result...
|
|
4 |
123 |
|
|
|
|
2 |
125 |
|
|
|
May 5th, 2010 05:23 PM
by Mike H
|
2 |
110 |
|
|
conditional formatting by
Russell
I want to be able to search for two things in a column. The first is a value
of less than or greater than $100. (OK so that is really two things I guess)....
|
|
3 |
125 |