|
|
row height issue by
Mike SoCal
I insert a row height of 15.75 and excel changes it to 15.60 automatically on
my new machine. I need to be able to create the 15.75 row height but cannot.
...
|
|
1 |
169 |
|
|
Average using Sumproduct by
Basenji
Using Excel 2003, I need to find the average age of males who have had a
specified procedure before March 31, 2010. D3:D11 are ages. E3:E11 are
gender....
|
|
4 |
166 |
|
|
Rounding by
Cynthia
How can a get a number to round in the formula bar when it is already rounded
on the worksheet. Ex: Formula Bar says 16651107.5346 and the worksheet has...
|
April 13th, 2010 06:12 PM
by Cynthia
|
4 |
173 |
|
|
Change the weekends by
Sadad
Dears,
I want to calculate the working-days of my subordinates and I usually I use
the function NETWORKDAYS but in this country the weekends are Saturday and...
|
April 13th, 2010 05:37 PM
by Mike H
|
1 |
167 |
|
|
|
|
2 |
146 |
|
|
|
April 13th, 2010 05:13 PM
by Sadad
|
2 |
164 |
|
|
Date Diff - excluding working days by
Scott_goddard
Hi all, Does anyone know how i can return the difference between two dates
that across weeks, months and years and only count working days?
|
|
2 |
153 |
|
|
Median with Criteria by
Demosthenes
Hello,
I want to write a formula that calculates the median of a set of values
specified by some criteria. For example, if you have the following in A and...
|
|
2 |
199 |
|
|
Vendor List by
Andri
Dear Expert,
Please help to create the list automatically.
Here is the situation, for simflify, i just take the Vendors Columns Only.
Supplier (we assume G1...
|
April 13th, 2010 03:53 PM
by Andri
|
7 |
171 |
|
|
ISNA VLOOKUP does not recognize 63023 by
Nain
Hello
I need help. The formula listed below works for all the employee numbers on
my spreadsheet which are in column B except for the employee number 63023....
|
|
4 |
173 |
|
|
Adding totals from different columns by
Eskercat
Hi
I have a column called year group, one called total attendance and one
called possible total. I would like to create the total % attendance for the
group...
|
|
1 |
219 |
|
|
|
April 13th, 2010 03:04 PM
by Eduardo
|
1 |
165 |
|
|
|
|
0 |
164 |
|
|
Hyperlink won't open in excel by
JBrits
I get a message in excel when I try to open hyperlink in excel that says
"This operation has been cancelled due to restrictions in affect on this
computer....
|
April 13th, 2010 02:33 PM
by JBrits
|
0 |
138 |
|
|
Combining text from multiple cells by
mgerken79
Help please. I'm trying to combine text from multiple cells using the
following formula.
=B3&" / "&C3&" / "&D3&" / "&E3&" / "&F3&" / "&G3
Column I is where...
|
|
6 |
141 |
|
|
|
|
8 |
131 |
|
|
Array Formula Help Needed by
nelly
Hi Guys
I need an array formula which counts the number of instances range Comp1 has
a value greater then zero AND Range Comp2 has a blank value.
Sounds...
|
April 13th, 2010 12:43 PM
by nelly
|
5 |
195 |
|
|
Look for Min and second Min by
Elton Law[_2_]
Dear expert,
Have posted a similar message before, but look like no one replied.
Lat me try the last time as I found the previous post was not clear...
( 1 2)
|
|
13 |
609 |
|
|
Removing multiple duplicate events by
Father John
Hi
I have a spreadsheet that has a complete address in one column (a)
In column (b) (B1:B165) I have the name of the suburbs I wish to remove from
col...
( 1 2)
|
|
10 |
292 |
|
|
Help with formula by
Brandon
I want to return the first date in which the sum of the previous columns
first exceeds inventory on hand (total). Should return 4/5 on this...
|
April 13th, 2010 10:48 AM
by Stefi
|
1 |
135 |