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 Last Post Reverse Sort Order Replies Views
Correlation tool says Input range must be contiguous reference. by HermH
Trying to use Data Analysis Correlation tool, but keeps saying "Input range must be a contiguous reference." CORREL() functions works Ok on same range....
April 28th, 2010 12:06 AM
by Mike Middleton[_2_] Go to last post
1 258
How do I delete a calendar function from a spreadsheet by Tiger
I inserted a "calendar function" in one of my spreadsheets and want to resize it, but can;t figure out first how to delete it. Can anyone help?
April 27th, 2010 11:42 PM
by Gord Dibben Go to last post
1 134
Removing items on Sheet1 that are common to Sheet2 by email4kh
Sheet1 and Sheet2 have identical data on some rows. In Excel 2003, how do I find and remove all the rows on Sheet1 that are also on Sheet2?
April 27th, 2010 10:23 PM
by Don Guillett[_2_] Go to last post
1 110
Identifying the top five values in multiple groups by RobFJ[_4_]
I've got a spreadsheet of pay information for about eight hundred people. Each person is on one of eight salary scales I'd like to create a new worksheet...
April 27th, 2010 10:19 PM
by Herbert Seidenberg Go to last post
6 193
FDIST Function by StatsUser
What is the formula used by Excel to calculate the FDIST function?
April 27th, 2010 09:52 PM
by StatsUser Go to last post
0 115
"Can not empty the clipboard" by Nutgrower
When trying to copy and paste, I get the message "Can not empty the clipboard" Help!
April 27th, 2010 09:06 PM
by Glenn[_6_] Go to last post
2 165
Need solution for wildcard use in array by Another wildcard and array problem
I need to find a solution for the following formula to be used in an Excel worksheet in Excel 2003: =SUM((('GCP Vendors'!L3:L999)="*Other*")*(('GCP...
April 27th, 2010 08:51 PM
by Tom Hutchins Go to last post
2 115
Suppress First Page Numbering by Michael
Hi folks - Is there anyway to suppress page numbering on the first page of an Excel sheet? Thanks. Michael
April 27th, 2010 08:43 PM
by Michael Go to last post
4 133
Using VBA to find a value and select a range by AlexJarvis
I am trying to write a macro that will let me find a specific vale in a specific column, then select part of the row that the value is in, beginnign with a...
April 27th, 2010 08:38 PM
by AlexJarvis Go to last post
4 169
How to? by Rebecca[_7_]
I have a work sheet that has lots of prices from things that we do and I am wanting to put it into a page where if say B4 is Cookies then the price for...
April 27th, 2010 08:37 PM
by Joe User[_2_] Go to last post
6 129
Formula to fill one cell from another by GeorgeQ
I have a table of data based upon the 12 months of the year, one month per column. Other data is added to the spreadsheet with associated month numbers:...
April 27th, 2010 08:04 PM
by GeorgeQ Go to last post
0 99
Missing values from a pivot table field by Kelli[_3_]
I am creating a pivot table from an access database containing 896426 records. The issue I am running into is that on one of the fields the pivot table is...
April 27th, 2010 07:44 PM
by Jim Thomlinson Go to last post
1 111
Formula help by Cooldistribution
I am trying to program excel to return rows and values based on criteria and need some help on which formula to use and how. I need a separate excel document...
April 27th, 2010 07:41 PM
by Luke M[_4_] Go to last post
1 96
Significant digit causing wrong value? by Eiyore
I have been using a simple IF formula w/o any problem for several weeks until now. The IF statement just calculates the amount of product from a meter...
April 27th, 2010 07:38 PM
by Joe User[_2_] Go to last post
2 107
COUNTIF: everything in a row larger than zero over multiple worksh by Yannig
Hi, I have a workbook with the first worksheet (main) as a general worksheets containing the results. All the other worksheets contain scores (SBOz1, SBOz2,...
April 27th, 2010 07:35 PM
by Yannig Go to last post
1 133
MSN Stock Quote by Wendy Hoffman[_2_]
We have a worksheet setup that uses the MSN Stock Quote. For the most part, the worksheet is fine. However, a few of the symbols are not able to be found. ...
April 27th, 2010 07:12 PM
by Don Guillett[_2_] Go to last post
1 90
add two cells from seperate work sheets into a cell on seperate wo by lar
I have two cells on one work sheet that I want to add together in a cell on another work sheet. And is it possible to add together two cells on seperate work...
April 27th, 2010 06:54 PM
by Gord Dibben Go to last post
6 130
Date formula needed by d7
Hi I need a couple of date formulas for invoices recieved, eg. invoice date is 14/03/2010, payment terms are end of month following. so i need excel to...
April 27th, 2010 06:36 PM
by Rick Rothstein[_2_] Go to last post
3 109
Counting dates within a range by towem3
I have a large database of ~10,000 dated and timed entries. Each entry represents the date and time of a hospital admission. I would like to know for each...
April 27th, 2010 05:23 PM
by Bob Phillips[_3_] Go to last post
1 97
Calculate number of days by Linda P.
I am using Excel 2000. I need help with a formula. In A1 I have # of years, in A2 I have # of months and in A3 I have # of days. In A4 I want to add A1...
April 27th, 2010 04:29 PM
by Linda P.[_2_] Go to last post
7 238
Post New Thread


Display Options
Showing threads 961 to 980 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 06:14 PM.


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