|
|
COUNT formula need two conditions by
DB Explorer
I have a database dump, which column B having different names of users,
and column C having values either TRUE or FALSE...I want a count of all
records, which...
|
|
3 |
95 |
|
|
|
August 16th, 2005 02:00 PM
by DB16
|
2 |
81 |
|
|
|
April 20th, 2006 08:21 PM
by Matt
|
4 |
86 |
|
|
multiple If's based on today's date by
dballou
I need to have the value of a cell based on the number of days past from a
date in another cell. i.e. A1 = 40 if A2 is =today()+365 or, A1=80
if A2 is...
|
March 24th, 2008 04:28 PM
by dballou
|
5 |
99 |
|
|
formula for linear regression by
DBane
I have a column of figures 20,30,40,50,60. when I select the range and put
the + at the bottom and pull, the result shows 70. the same using chart
wizard,...
( 1 2)
|
|
14 |
311 |
|
|
Running total formula by
DBane
My cells look like this.
in a:4 value is 6. In b:4 the value is 112.
in a:5 value is 7. In b:5 the value is 125.
in a:6 value is 6. in b:6 the value is 110.
in...
|
June 2nd, 2006 07:38 PM
by DBane
|
0 |
55 |
|
|
IF TODAY() by
[email protected]
I'm trying to automatically fill some cells in a spreadsheet that's
linked to a MS Project file. There are 5 cells - the first one is the
cell linked to...
|
|
3 |
41 |
|
|
hide duplicate addresses in Excel by
DbaseGuy
I manage a database for a school. when sending mailings home we often print
two labels to the same home due to siblings in the same school.
Is there a way to...
|
|
1 |
64 |
|
|
IF Function?? by
DBassmaker
What can I do so that when I type a certain number in a column it will
give me another number? For example I have a list of temperature
correction factors...
|
|
2 |
73 |
|
|
|
June 24th, 2006 07:57 AM
by starguy
|
8 |
110 |
|
|
|
|
3 |
80 |
|
|
|
November 15th, 2005 08:43 PM
by JakeyC
|
3 |
74 |
|
|
|
December 29th, 2007 12:53 AM
by joeu2004
|
2 |
108 |
|
|
Changing groups of cells in Excel by
DBB9
In Excel 2003 can I change a group of cells (e.g. a column) so their results
all become negative or do I have to change each cell individually?
|
|
3 |
82 |
|
|
#DIV/0! ERROR by
dbconn
I have a worksheet that has a number of rows in each of several different
categories. Before any information is entered, each row shows a 0 sum. When...
|
|
2 |
167 |
|
|
year formula returning incorrect value by
dbdewitt
As I understand it, the YEAR formula should return the year to which the
formula relates. I have a date of 4/24/2008 in a cell (let's say it's in
cell B2),...
|
|
5 |
145 |
|
|
|
April 23rd, 2007 02:06 PM
by DBenny
|
2 |
62 |
|
|
Excel Formatting by
dberger16
In my spreadsheet, I would like to find all the "and" words and then
CAPITALIZE the very next letter or word in the same cell.
Thanks!
--
DaveB
|
|
5 |
66 |
|
|
Capitize first letter in sequence by
dberger16
Hi,
here is an example of data in my column:
Lorena & james
i simply want to capitize the J (james).
Thanks for your assistance
|
April 20th, 2008 12:46 AM
by Max
|
2 |
83 |
|
|
|
|
1 |
104 |