|
|
|
|
1 |
122 |
|
|
Shared workbook by
puiuluipui
Hi, i have a shared workbook. I want to work with another user, at the same
time. But if i enter some datas on the same row as the other user, i receive
an...
|
|
0 |
118 |
|
|
|
|
2 |
110 |
|
|
Conditional format for complete column by
Vaquita
Hi I have the following conditional rule in column Z3
=AE3(TODAY()-30)
I want to apply it for 50 cells more it means from Z3:Z53 using the
information from...
|
|
1 |
95 |
|
|
Help with if statement by
rew3791
Ok, I can't quite make this formulat work.
Assume: Column D is Birth Year, Column E is Death Year, Column F is Age at
Death
The basic formula is =E-D (Death...
|
November 20th, 2009 06:08 PM
by T. Valko
|
4 |
137 |
|
|
counting based on two dates by
AccessNoviceButTrying
I have two columns which both contains dates. I want a count based on
criteria from the dates. For example...
Start Date End Date
01/01/08 ...
|
|
2 |
92 |
|
|
Data not updating in linked workbook by
Teri
I have two workbooks that I was trying to link together. Workbook 1 holds
the data and the information went on to workbook 2 but it's not updating when
you...
|
|
1 |
114 |
|
|
Condition based on multiple cells by
WAR
I would like to look at 3 cells: A6, C6, E6. If all 3 of these cells are
blank, I would like to return a blank cell. If any of the 3 cells has a
value, I...
|
November 20th, 2009 05:04 PM
by WAR
|
4 |
99 |
|
|
Rounding Effecting Sum by
Steve Graves
I have cells that cotain formulas based on adding four other cells together.
One of those cells is the result of a percentage applied to a dollar amount. ...
|
|
2 |
95 |
|
|
|
November 20th, 2009 04:53 PM
by Bob I
|
2 |
100 |
|
|
Problem with PowerPivot Virtual Lab by
dbaechtel
I am following the PowerPiot Virtual Lab from
https://cmg.vlabcenter.com/default.aspx?moduleid=ad3bd3e9-8d2b-498d-94fa-e41e1b09730d with Excel 2010...
|
|
0 |
129 |
|
|
Incorrect result for simple SUM formula by
VivienW
Hello,
Does anyone know why Excel sometimes give an incorrect result when adding
the contents of cells? It may only be 1p out but even if I increase the...
|
|
9 |
147 |
|
|
missing drop down command by
Darin
I was customizing my toolbars and when I click on the data drop down menu, I
accidently clicked on one of the options and tried to drag it into my
toolbar. ...
|
November 20th, 2009 04:43 PM
by Bob I
|
1 |
98 |
|
|
Transform table into calendar format by
Matheus
I have a table with dates (column A) and events (column B). I wanted to know
how I automatically create a calendar template with the events I have on this...
|
November 20th, 2009 03:58 PM
by Matheus
|
2 |
119 |
|
|
Office 2007 Converter for Office 2003 by
Rob Jordan[_2_]
I have this one machine that is running MS Office 2003 SP2 (Must remain SP2
due to a unified messaging app that's broken by SP3). I've installed the
File...
|
|
1 |
118 |
|
|
Calculation if a cell contains a word by
James
I've exported data from a database and then performed a subtotal/count. I
need to multiply the count of the different criteria by three different
values.
If...
|
November 20th, 2009 03:27 PM
by James
|
4 |
82 |
|
|
|
November 20th, 2009 03:23 PM
by Rulon
|
0 |
115 |
|
|
|
|
2 |
117 |
|
|
|
November 20th, 2009 03:01 PM
by Luke M
|
1 |
137 |
|
|
More than 3 Conditions by
John Moore
Hi, I am looking for a code which will do the following for me
Range is T5:T90
Condition 1: If Cell value is 10 make background light blue
Condition 2: If...
|
November 20th, 2009 02:59 PM
by Luke M
|
2 |
96 |