|
|
|
|
1 |
120 |
|
|
sum unique entries only by
Jo
I need help with a formula. I have the following formula giving me the no of
unique positions that are ines 4
...
|
April 30th, 2009 05:26 AM
by Jo
|
0 |
102 |
|
|
|
|
1 |
131 |
|
|
|
April 30th, 2009 07:57 AM
by Peter
|
2 |
101 |
|
|
Q for Dana DeLouis by
M Thompson
Hi Dana, and thanks again for the following:
=MEDIAN(-400,-MIN(3 + 0.02* H9, 0.05* H9),0)
Can you elaborate on it? Math is a shortcoming for me, so I'm...
|
|
7 |
84 |
|
|
|
|
1 |
102 |
|
|
Conditional Formatting by
TheStuff2007
I'm trying to make a conditional formatting rule in Excel 2007 that makes a
row of several cells where one cell contains the text "Yes" to be formatted
to...
|
|
2 |
110 |
|
|
|
|
0 |
115 |
|
|
Pivot Table - Hidden Data by
Beth
Hello
I have got a pivot table showing today's transactions by account number.
I found that say an account has three receipts for £500 then it will be laid...
|
April 30th, 2009 11:03 AM
by Beth
|
0 |
143 |
|
|
UNABLE TO CHANGE SHARED FILE by
vcff
Hi All
I had placed a file to be shared by 5 persons. However, only 2 persons are
able to open the file and make changes while 3 persons can only open the...
|
April 30th, 2009 11:24 AM
by vcff
|
1 |
100 |
|
|
mathmatical equation symbols by
bnjii
I just loaded MS 2007 tonight. I was excited to find the capability of
inserting equations in Word, but found that this wasn't available in Excel.
Does...
|
April 30th, 2009 11:39 AM
by bnjii
|
2 |
104 |
|
|
|
|
0 |
82 |
|
|
|
|
2 |
101 |
|
|
|
|
1 |
92 |
|
|
custom format by
Dreamstar_1961
How to format something like 744532451500 into 74-45-32-45-15-00
this so the "-" are added automaticlly
Thanks
|
|
3 |
118 |
|
|
Clearing Print Area Outline by
DubboPete
Hi all,
Is there any way of getting rid of the print area "dots" once one has
clicked and set a print area? I want to display the worksheet to
200+ people,...
|
April 30th, 2009 03:26 PM
by Bob I
|
1 |
117 |
|
|
Why can't I call a range of cells 'c'? by
Jock
Using "Insert|name|define" I have named certain ranges 'a', 'b' and 'd' (w/o
the ').
I can't set up one called 'c' though - I get the message: "That name is...
|
|
3 |
117 |
|
|
|
April 30th, 2009 03:42 PM
by Bob I
|
2 |
141 |
|
|
Auto Complete not working in one column by
Lisa
I have Excel 2007. I'm entering data into 3 colums. Auto Complete is not
working for one of my colums. It was when I first started and I can't figure
out...
|
April 30th, 2009 04:26 PM
by Sheeloo
|
3 |
104 |
|
|
|
April 30th, 2009 04:28 PM
by JLatham
|
2 |
104 |