|
|
|
|
3 |
309 |
|
|
Average of top x% of a list by
Brendan
I need a flexible formula to find the average of the top x% of data in tables
of varying size.
To be more specific, I have daily data for many years and I...
|
|
1 |
109 |
|
|
getting data from a database into a form by
Brendan
Hi all,
i am trying to create a form from a database.
in the first col is the account #.
in the second is the company name
and in the third to fiftyforth is...
|
|
2 |
62 |
|
|
|
|
0 |
93 |
|
|
Conditional Formula by
Brendan J Cuffe
Can anyone help with the following: -
I have data in cells A2 and A3, in another cell (A10) I need a formula so
that
If there are no values in A2 or A3 the...
|
|
3 |
74 |
|
|
shared workbook issue by
Brendan Quirk
Hello All - I am using Excel 2007 and have a shared workbook that is
also password protected.
One user of the workbook attempted to save changes and received...
|
|
0 |
95 |
|
|
|
|
24 |
261 |
|
|
Worksheet function for range of numbers by
brendan_doc
I'm trying to find an Excel formula which will give me the total number
of entries in a range.
1-4 should provide 4
2 should provide 1
345 should provide...
|
|
1 |
88 |
|
|
|
|
1 |
71 |
|
|
parentheses by
Brendy
From one excel novice to all you excel brain boxes can any of you give
me some tips on when and where I should be putting parentheses after
the = sign when...
|
January 15th, 2006 09:24 PM
by Brendy
|
5 |
106 |
|
|
EXCEL LOOKUP by
Brendy
Hi I have an excel workbook with 2 sheets, the first sheet has all the
information in it and the second is where I want the results displayed.
In sheet 1 have...
|
January 12th, 2006 08:11 PM
by vezerid
|
8 |
98 |
|
|
|
July 8th, 2005 03:54 PM
by Falcon
|
4 |
56 |
|
|
|
|
2 |
57 |
|
|
New Excel function SUMABOVE by
brent
Suggested new Excel function: SUMABOVE(Ref)
Ref = Single cell reference in the same column as the function. The function
automatically adds all values from...
( 1 2)
|
|
12 |
148 |
|
|
Formula question by
Brent
State Insp Date
FL 1/01/09
SC 1/10/09
NC 1/5/09
FL 2/14/09
VA
FL
GA 1/12/09
Hi, I need help...
|
February 19th, 2009 01:17 PM
by Pete_UK
|
3 |
69 |
|
|
conditional formating by
Brent
I am using Excel 2007 and would like to create certain rules and cannot
figure out how to do using conditional format. Lets say I have a typical...
|
|
6 |
78 |
|
|
Columns and Conditional Formattin by
Brent
I am using =countif(a:a, a1)1 to look for duplicate values in a spread sheet
and I have copied this formula to the end of the list. However the sheet in...
|
|
2 |
76 |
|
|
Sum IF by
Brent
I have 2 columns (Column A = "Per Game Fee" , Column B = "Number of Games").
I am attempting to total Column A after it has been multiplied by Column B.
column...
|
March 29th, 2006 12:27 AM
by Brent
|
4 |
101 |
|
|
Conditional cell color by
Brent
I have created a calendar within Excel and would like to accomplish the
following:
Whenever I enter text (any text) into a cell, I would like for the cell...
|
|
7 |
121 |
|
|
Strange error with basic divide function by
Brent
I am using Excel 2000 and if I enter a formula that uses the / key to
perform a divide function, I get a "formula you typed contains an error"
message. This...
|
|
1 |
93 |