Worksheet Functions - Page 550

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.

Thread / Thread Starter	Last Post	Replies	Views
Convert a Yes/No/NA response to a # value or % by OdayLadyMJ I have a large sample of data used to determine compliance in a Yes/No/NA format. How do I convert this data to numbers so that I can automate the data...	February 21st, 2005 02:55 PM by OdayLadyMJ	2	84
how do I count the sum of 2 columns in excel? countif(a1:a100='op. by Bruce I am having trouble with the syntax here nested functions - this is what I am attempting to do countif(a1:a100='open' and b1:b100='i')	February 21st, 2005 03:20 PM by JE McGimpsey	1	86
Help with Protections ASAP by [email protected] Hello, I have created a large workbook with 274 worksheets. It worked fine until last night I saved it, went to General Options and saved it with a Password. ...	February 21st, 2005 03:31 PM by [email protected]	2	91
How do I select only specific parts of one field? by wearfinkle I have an Excel worksheet of 5000 addresses. I want to select a range of only certain zipcodes. Unfortunately, the zip is part of one big address field. I...	February 21st, 2005 03:46 PM by Jason Morin	1	86
Dynamic Print Range Help by waxwing I need away to dynamically change the print range for a sheet that contains a pivot change in which the number of columns and rows may change. I've figured...	February 21st, 2005 03:47 PM by waxwing	2	346
horizontal & vertical scroll bars by labrev I'm creating a spreadsheet which has a ' MENU 'sheet, so users can navigate to other sheets within the spreadsheet via button clicks on the 'MENU' sheet. Is it...	February 21st, 2005 03:49 PM by Bob Phillips	2	203
macro recording by Tobias I am trying to record a macro, with a very long if-sequence. and it just says "weren't able to record". I tried writing it in the VB-window as well but...	February 21st, 2005 04:13 PM by Tobias	2	69
dates, 1st of month by LatinViolin in cell A1 i have 1-jan-2005. i would like to copy this info down into A2, A3, A4, etc. as long as i like but each cell should read the next month 1st day. ...	February 21st, 2005 04:38 PM by Tom Ogilvy	3	281
totaling times past 24 hours by txduster Trying to add a column of times on the 24 hour clock. how do I get a total above the 24 hour limit?	February 21st, 2005 04:39 PM by txduster	2	80
sum of cells without #VALUE by Shooter I have values in cells C3, E3, G3, I3. I have input "n/a" in cell G3. In cell K3, I have a formula ( =C3+E3+G3+I3). I am getting a #VALUE error message in cell...	February 21st, 2005 04:48 PM by Jock W	2	96
help with if statement by Qaspec how do i translate this into a formula if d47 equals blank then blank else if d48 equals blank then if (today - d47) 89 then e47 else 0, if d48 is not blank...	February 21st, 2005 05:12 PM by Arvi Laanemets	1	82
How do I convert cell contents that are Hex to binary? by KarenSue33 I want to process a column at a time, so I need a main function.	February 21st, 2005 05:41 PM by Tom Ogilvy	1	114
Is it possible to create one column with two different width? by Dave H... Does anyone know how I may create two tables, one under the other, but with different column width on each table??? In case it's not clear: 1- My first table...	February 21st, 2005 05:45 PM by Dave H...	0	127
Is it possible to create one column with two different width? by Dave H... Does anyone know how I may create two tables, one under the other, but with different column width on each table??? In case it's not clear: 1- My first table...	February 21st, 2005 05:45 PM by Dave H...	0	191
Is it possible to create one column with two different width? by Dave H... Does anyone know how I may create two tables, one under the other, but with different column width on each table??? In case it's not clear: 1- My first table...	February 21st, 2005 05:52 PM by JE McGimpsey	1	124
Automatically print all page contents in pivot table. by David P Hi All, Can anyone help me with writing a macro whe From a Defined Range (e.g. Sheet1! B9-B20), for each cell value, I would like a pivot table page on...	February 21st, 2005 05:57 PM by David P	0	101
occurance of numbers in cell range by Dillenger Hello, I'm trying to figure out how to calculate the occurance of multiple numbers in multiple cell range. For example: A1 B1 C1 3 11 54 2... ( 1 2)	February 21st, 2005 06:45 PM by Harlan Grove	14	216
how do i bring information from one worksheet to another in excel. by Excel I would like to plug in a number to a cell on worksheet one and it automatically populate the fields from worksheet two?????? help	February 21st, 2005 06:55 PM by Tom Ogilvy	1	127
vlookup array in excel VBA by Lolly HI I am using the following formula Sub find() Range("C150:H150").Value...	February 21st, 2005 07:01 PM by Harlan Grove	6	156
Calculat years married or age of someone on today's date by Chersie I want a cell to give how old someone is or how long they have been married today. It has to show that a child born on 2/20/2000 is 4 years old...	February 21st, 2005 07:11 PM by Chersie	4	251

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