A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Reverse Sort Order Last Post Replies Views
A B C D column names and 1 2 3 4 by Brendan
Can I hide A B C D column names and 1 2 3 4 rows so I can only see my workspace
November 12th, 2003 12:53 PM
by Stephen Bye Go to last post
3 299
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...
October 15th, 2009 04:42 PM
by Bernie Deitrick Go to last post
1 107
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...
October 8th, 2006 10:24 PM
by Teethless mama Go to last post
2 61
execute external program when cell reaches certain value by Brendan DJ Murphy
Hi, As the subject-line says, Is there an easy way to make Excel execute another program triggered by a cell meeting a certain criteria? Thanks Brendan
February 16th, 2005 06:25 PM
by Brendan DJ Murphy Go to last post
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...
May 11th, 2005 01:10 PM
by Bob Phillips Go to last post
3 73
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...
December 11th, 2009 07:11 PM
by Brendan Quirk Go to last post
0 95
How to define and select the last (bottom) number in a column? by BrendaN_at_Welke_Customs
I want to select the last entry in a column, and insert this value into a formula elsewhere. A new number is added daily to this column. There are empty...
(Multi-page thread 1 2 3)
November 5th, 2007 06:06 AM
by T. Valko Go to last post
24 260
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...
February 9th, 2006 07:15 PM
by Bob Phillips Go to last post
1 87
Copying formulas from one workbook to another by Brendas
We are using Office XP Standard. We used to be able to open two separate workbooks, opened separately from a folder on our file server, then copy one formula...
July 20th, 2007 10:07 PM
by Gord Dibben Go to last post
1 69
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 10:24 PM
by Brendy Go to last post
5 105
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 09:11 PM
by vezerid Go to last post
8 98
Tab Color - Excel 97 by brenrogers7142
How do I color a workbook tab in Excel 97? Thank you.
July 8th, 2005 03:54 PM
by Falcon Go to last post
4 55
set up a link that updates page one from all other page entries? by brensand
In an Excel workbook the first page includes info from 20 counties. The other pages in the workbook contain info from each of the individual counties....
May 17th, 2006 08:19 PM
by LTUser54 Go to last post
2 55
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...
(Multi-page thread 1 2)
June 7th, 2006 01:37 PM
by Don Guillett Go to last post
12 146
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 02:17 PM
by Pete_UK Go to last post
3 68
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...
January 9th, 2009 12:54 AM
by Rick Rothstein[_2_] Go to last post
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...
November 13th, 2007 01:52 PM
by Roger Govier[_3_] Go to last post
2 74
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 Go to last post
4 100
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...
April 17th, 2007 03:30 PM
by steelbee Go to last post
7 120
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...
June 28th, 2006 09:20 PM
by Kevin Vaughn Go to last post
1 91
Post New Thread


Display Options
Showing threads 10181 to 10200 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:52 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.