|
|
sumifs, sumif with dates by
Richard Manor
Workbook to report all OT (overtime) performed during FY08 within a range of
date for comparison to current FY usage.
Two worksheets, 'Report' and 'FY08'. ...
|
|
6 |
83 |
|
|
|
|
1 |
94 |
|
|
|
|
1 |
49 |
|
|
|
|
1 |
67 |
|
|
can I make a macro to print? by
Richard Horn[_2_]
I have a summary worksheet in my Excel (2003) workbook that has multiple
sections such as, Projects Completed, Projects In Queue, Projects of Hold,
etc..
I...
|
|
9 |
107 |
|
|
Count everything in a Column "except" by
Richard Horn[_2_]
I have a worksheet where one column is for the project status. I want to
count all projects with the exception of any project that has the status
"Carried...
|
|
2 |
73 |
|
|
Adding column when number exist by
Richard Horn[_2_]
I have a project workbook and I am working on a summary page.
From the Q1 worksheet, column K, we have listed cost savings. Some projects
have a cost savings...
|
|
3 |
172 |
|
|
Combining Functions (Sumproduct and Countif) by
Richard Horn[_2_]
I am using this sumproduct function in our project summary log to retrieve a
range of cells that contains "Richard Horn" (project Lead) but not if they...
|
|
5 |
159 |
|
|
Percentage equals 0 error by
Richard Horn[_2_]
I know if I ask for the percentage of =G44/H44 and both columns contain a 0,
or H44 contains a 0, Excel will return a #DIV/0! error. Is there anyway to...
|
|
7 |
122 |
|
|
Data Connection Wizard by
Richard Horn[_2_]
Need some help with the Data Connection Wizard. We have a database which is
on one of our internal servers and it is accessed by a url. Can I, or how do
I...
|
|
0 |
150 |
|
|
Round values to 0.05 or 0.00 by
Richard Hope
On an Excel spreadsheet, I'm looking to convert prices (or=20
numbers with 2 decimal places) to the nearest .00 or .05 -=20
for example =A31.42 would round...
|
|
3 |
196 |
|
|
Flag for Follow Up by
Richard Hocking
Hi folks, any advice with the following greatly appreciated.
I've a spreadsheet that, on occasions, will have an entry in a particular
cell changed /...
|
|
0 |
68 |
|
|
Remove time from cell by
Richard Gendron
Hi there,
I am importing several rows/columns from a main frame and I would like to
create a macro that I can re-use on different columns that would strip...
|
|
2 |
92 |
|
|
Rank by
Richard from Atlanta
How can I get the rank value for a list of values, without
sorting the items...I have a bunch of cities for example,
and and various metrics that I want to...
|
September 29th, 2004 07:23 PM
by JWolf
|
5 |
145 |
|
|
RANK FUNCTION by
richard from atlanta
I have 20 cities down col a
I have 10 variables down col b - k
each city has a value for each variable
the systems are sorted alpha
I want to look at the...
|
October 3rd, 2004 08:36 PM
by
|
4 |
159 |
|
|
Nested "IF" With "And"and "OR" functions by
Richard Freist
In Excel 2003, I can't figure out the fomula for a company that has full time
and part time employees who recieve family leave time. For full time
employees...
|
|
3 |
81 |
|
|
Copying condition formatting cells only by
Richard Flint
I would like to know if there is a way to copy the
conditional formatting into from one cell to all the other
cells in the column.
However, the referenced cell...
|
October 21st, 2003 09:17 PM
by Felipe
|
1 |
442 |
|
|
Array formula issue by
Richard Fletcher
I have the following in a macro :-
Range("Y5").Select
Selection.FormulaArray = _
"=SUM(IF(data!$c$2:$c$65000=""Sheffield"",data!
$l$2:$l$65000,0))"
When run...
|
|
1 |
123 |
|
|
|
|
2 |
86 |
|
|
MATCH being sent two arrays by
Richard Fangnail
I don't understand what it means if you sent MATCH two arrays. The
below is from the Help page for "count unique values...
|
August 17th, 2007 02:03 AM
by bj
|
2 |
73 |