|
|
|
|
3 |
151 |
|
|
Use CountIf for a literal string by
chadkwelch
I am trying to count the number of cells in a range that contain the string
0.1. I don't want the number of cells that contain numbers less than 0.1, I
want...
|
|
3 |
206 |
|
|
salary defined by slab table by
XKruodo
Hi,
I have a sheet with a table which has number of hours in a column A. Salary
per hour is in column B as under.
50 3.5
100 5.7
150 ...
|
|
5 |
210 |
|
|
Moving cell formula by
iamjbunni
I have a formula that calculates averages each week. I need a formula that
automatically uses the cell below when new data is entered.
|
|
3 |
152 |
|
|
|
|
5 |
162 |
|
|
|
|
9 |
238 |
|
|
Help with conditional formatting... by
Mr. Ruger
This may sound like a basic question. But I am trying to set up some
conditional formatting based on varying text in Excel 2003. I am sorting
baseball...
|
|
0 |
135 |
|
|
|
|
2 |
155 |
|
|
|
|
2 |
114 |
|
|
comparing two colums ? countif by
manfred3
Hi,
I have a spreadsheet with "weeks in column A and "Daily Charges" in
column R.
col A col R
Week 1
Week 1
20
|
|
1 |
117 |
|
|
|
|
4 |
167 |
|
|
|
|
1 |
138 |
|
|
|
|
0 |
221 |
|
|
wildacrds by
Dave
Hi,
XL2003.
Is it possible to use wildcards in simple logic statements?
If A1 contains "qwerty" and B1 contains "qw"
In C1 I've tried:
=A1=B1* - xl...
|
March 20th, 2010 03:48 PM
by G Ray
|
4 |
160 |
|
|
Multiple sheet querries by
G Ray
I want to bring a lot of data into Excel from a database. Using SQL I
can retreive much more data than one worksheet can hold.
I have found I can create and...
|
March 20th, 2010 03:36 PM
by G Ray
|
4 |
123 |
|
|
Excel Logical IF function by
Stuck!
I am trying to enter in a function in Excel that if is if A5 is less than
half of D5, if true Y if false N. I can not figure out how to enter the half
of D5...
|
|
2 |
125 |
|
|
|
|
2 |
126 |
|
|
|
|
3 |
157 |
|
|
|
|
2 |
181 |
|
|
Counting formula by
lawhawg
I need a formula to sum on the cells that match a variable in another cell
A B C D E F G H I
1
2 Bo Jim Ron
3 ...
|
|
1 |
113 |