Worksheet Functions - Page 4385

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 4385 of 4390

4385

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
COUNT THE NUMBER OF LETTERS INCLUDING SPACES IN A CELL? by zurafz6 Im currently creating codes for our inventory list. The system provider mentioned that my codes can only have 30 characters including spaces and symbols. Now I...	March 6th, 2006 07:53 AM by Biff	7	114
a function that counts the number of cells with information by zuri125 Is there such a function that counts the amount of cells with information in them. For example right now Im trying to find this so I can find an average. So Im...	June 7th, 2006 07:37 AM by VN	1	116
Adding a constant to a formula. Problems w/filling in by zuri125 I am trying to find a way to "fill in" a funtion. I have F2=E2+F1, for example. I want the cell next to it, G2, to be =E2+G1. In other words, I want Row 2 to...	February 3rd, 2006 06:16 AM by Biff	4	88
how to add values of cells only if a corresponding cell has information on it by zuri125 Is there a function that can add up the values of cells but only if a corresponding cell has information on it. For example i have two columns of lists. The...	June 7th, 2006 06:59 AM by Ardus Petus	1	94
Why does the right 'Alt' key not work in Excel? by zuzartej The right 'Alt' key does not work in Excel 2003. The key plus the enter key provides a paragraph break in a cell of text. When I discovered the problem at...	January 2nd, 2006 06:36 AM by zuzartej	4	129
combining conditional formatting and functions by zvi Hi all, I want an empty given cell, say AA5, to become the color red when a range of 8 cells in the same row starting 13 columns to the left of AA5 (i.e. the...	December 9th, 2005 12:37 PM by zvi	2	135
Inserting automatic text in Excel by [email protected] Is there an option in Excel for "Inserting automatic text" like in MS-Word? I would like to have some "pre-preapred" text expressions that I can easily insert...	June 8th, 2006 12:21 PM by hans bal(nl)	1	61
FLOATING CELLS by zvone Hi, Please can anyone help. I would like to have a part of table that stays in same position. (floating) I don't want to make split of freeze, I just wan't to...	November 16th, 2005 05:21 PM by Peo Sjoblom	1	72
reorganising data by zvonul Hi, I'd like to reorganise data from a spreadsheet as follows: I have a number of columns with a couple of rows as title and some data underneath each. The...	March 11th, 2008 05:29 AM by Max	4	90
Conditions by zvroom How can I put 3 conditions in one formula	January 12th, 2009 07:51 AM by Rick Rothstein[_2_]	3	91
I can't open PDF files when using the hyperlink by zwalbij Hi everyone, I encounter the following problem. All my hyperlinks work except for the hyperlinks that refer to PDF files. When I click on the hyperlink the... ( 1 2)	March 10th, 2007 11:02 PM by zwalbij	12	283
under standing if statments by zx12rbullet I am trying to create a drop down box and with what ever i select from it put the price two cells over say backhoe cost is 44.57 hr backhoe trencher blade...	July 21st, 2007 10:16 PM by Gord Dibben	2	74
=OR(IF(AND(....),HYPERLINK.... by zx6roo I need to have a formula that says if one cell says CO and another says Y then another cell links off to the hyperlink otherwise it says pending. This is...	July 18th, 2007 07:13 AM by Max	3	95
Index, match, multiple IFs query by zx6roo I have the following individual...	May 8th, 2010 08:46 AM by Ashish Mathur[_2_]	9	251
#REF! error with Multiple Documents by zxcvbnm6000 I keep receiving a #REF! error when I try to use VLOOKUP to find data in one document and bring it to another. If both documents are open all the numbers are...	February 5th, 2010 02:25 AM by zxcvbnm6000	7	141
Number of Specific Day within Dates by zxcv[_2_] On Jun 29, 6:51*am, Abdul wrote: Hi, Is there a way to find how many Day (eg. wednesdays) within a a date range? ...	July 3rd, 2009 09:59 PM by zxcv[_2_]	2	100
toolbar keeps coming back by zxcv[_2_] There is a toolbar that I do not want to see when I open up excel, either a new workbook or a saved file. I can make it disappear temporarily by going to...	November 4th, 2009 04:48 PM by zxcv[_2_]	1	105
How to get YTD Summary by zy1972 Hi, I have a 12-m sales number. I know it is easy to get MTD number by using vlookup, but is there a way to get YTD number when month changes? For example,...	May 23rd, 2008 04:08 PM by zy1972	4	96
Multi YTD Summary by zy1972 Hi, If I have the following schedule (on bottom), I have another cell to input numbers (1-12), Is there a formula could automatically summary each function...	May 30th, 2008 04:49 PM by zy1972	3	64
YTD average cust calulation by zy1972 Hi, I have the following schedule. Basicall, I would like to drive my YTD average customer calculation by input month. Is there a simple formula to achieve...	July 4th, 2008 06:41 PM by NoodNutt	3	75