Worksheet Functions - Page 44 - 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.

		Home » OfficeFrustration forum » Microsoft Excel
Worksheet Functions

Home

Page 44 of 4390

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
copy cell contents but not formula by newbie Cell B1 has a number which is created by a formula. I would like to copy the value in cell B1 to C1 but I do not want to copy the formula. Is this possible?...	May 14th, 2004 10:06 PM by greg	5	615
Using the TRANSPOSE function by sj5603 I have a table that I would like to transpose from horizontal to verticle. It is structured like a database with the fields in columns and the records in...	April 20th, 2004 11:44 PM by za111	6	615
Text not fitting in a cell by Arvi Laanemets Hi MS Help: Worksheet and workbook specificatiions Length of cell contents (text) - 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the...	May 1st, 2004 09:34 AM by Frank Kabel	1	613
copying worksheets to other workbooks by Roy I have a workbook with formulas that reference sheets (tabs). I want to copy the formulas to another workbook with the same tab names and have the formulas...	September 17th, 2003 07:18 PM by Don Guillett	1	613
Suppressing 0's in pivot table - Please help by Gaurab Hazarika All, I have a pivot table where are sum up the values of a column. The pivot table shows the information correctly but shows the rows for which the sum is...	December 5th, 2003 01:06 PM by Gaurab Hazarika	2	613
Create AVGIF function by plindsay Does anyone know how to create an average if function similiar to a SUMIF function? I'm not that familiar with VBE so I believe this is out of my league. Any...	August 30th, 2005 05:40 PM by Max	3	613
Page Breaks by Alicia Can anyone tell me what I need to do when Excel won't let me adjust the page breaks on a worksheet? I'm trying to select the "fit to one page" option, but...	March 3rd, 2004 02:08 PM by Alicia	3	613
Copy and Paste hidden rows by DuncVern I would like to copy from one worksheet that has hidden rows, and paste to another worksheet not including the hidden rows. So only paste the data that is...	April 1st, 2004 05:16 PM by Frank Kabel	1	613
Sumproduct search between Dates by Robert Christie Hi I have two sheets in a XP workbook. Sheet1 contains three columns. Dates Code Price. Sheet 2, column A contains Codes starting on row 3. I like to be...	May 22nd, 2004 03:09 PM by Robert Christie	5	612
writing criteria in access and using pivot in excel by Frank Kabel Hi for the first question: depens on several things: - what is easier for you - amount of data - etc. I'd group it in MS Access (but that's just a personal...	March 23rd, 2004 04:35 PM by Frank Kabel	2	612
I need to Sum multiple columns by referencing one formula. by GaryZ First of all, I know little about Excel formulas. I have a spreadsheet report generated by a Visual FoxPro program using data imported from an Access...	July 3rd, 2004 12:45 PM by GaryZ	2	612
Forget SUMIF, COUNTIF and VLOOKUP by Pierre Leclerc Hi The SUMIF function allows you to sum a range using one criteria. =SUMIF(a1:a11,"New York",b1:b11) In plain English sum range B1 to B11 if in the... ( 1 2)	November 21st, 2004 11:34 PM by JulieD	15	612
Data validation based upon another cell's data by joannanpa Hi all. I'm not very savvy with excel so bear with me. I am setting up a spreadsheet that tracks window orders. To make it easy, let's say we have 2...	May 10th, 2004 06:24 PM by joannanpa	0	612
Importing from Excel to Access by yolanda I am coming up with errors when I'm importing from Excel to Access. The error message is "field truncation." The way I saved my Excel Sheet is in Tab...	May 13th, 2004 10:16 AM by onedaywhen	2	611
Fonts of Drop Down Forms by Stijn When using the forms' drop downs, how can I modify the font size/type ... ?	September 16th, 2003 11:12 PM by s-o-s	3	610
Copying a Formula from NotePad to Excel by carl I have a formula on my notepad and would like to copy it to excel. the column refernces are correct but the row reference are not. is there a way to copy and...	March 21st, 2004 09:25 AM by Frank Kabel	4	610
exporting/linking data from a row on one sheet into another sheet by Clark haddock I have a master sheet with all the sales information that my company tracks. I would like to create seperate sheets for each sales rep. I have all their...	February 2nd, 2004 03:25 PM by	1	610
Unable to calculate std dev for any value with 6 or more digits to the left dec. by Thomas Burns I am unable to obtain the standard deviation for any value with six or more digits to the left of the decimal. The values are coordinates, usually with six or...	January 21st, 2004 08:07 PM by Thomas Burns	0	610
sumif across multiple sheets in excel 2007 based on a condition by dave@homedeliverygroup I have a small work book, tracks deliveries made and trucks used. I have seven sheets Saturday thru Friday and one sheet that totals everything up! The...	May 13th, 2010 07:42 PM by T. Valko	6	610
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)	April 13th, 2010 12:28 PM by Steve Dunn	13	609

Page 44 of 4390

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	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 04:38 AM.