Worksheet Functions - Page 397

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
will a function do this for me? by quailwood Does Microsoft Excel 2003 have a function which computes the value of a variable involved in generating a desired solution? In other words, if one needs for...	August 26th, 2009 03:08 AM by Max	1	119
SUMIF with "OR" criteria by SwtHapa8 Hello, I'm having an issue with an IF-THEN formula. In my situation, I'm trying to say," If A1:A5 = CA or DE or NJ or NY or PA or WI, then sum B1:B5" Can...	August 26th, 2009 02:16 AM by T. Valko	2	115
Matching dates to cells by Donna[_5_] Col A COL B Col C DATES TRANS ADJ 4/06/07 A 1 4/07/09 C 4/06/07 A 1 4/25/09 C 4/03/09 A 2 4/09/02 C 4/25/09 ...	August 26th, 2009 02:14 AM by Max	8	124
sun total of one column using criteria in another column by Ben how do you add up a series of numbers in one column using a critera of another column? Column A Column B Apples ...	August 26th, 2009 02:11 AM by T. Valko	5	200
calculated fields in pivot tables by Brad Autry Hi, I have a fairly simple pivot table whose rows consist of various job post sources. So, for my small example, let's say the rows...	August 26th, 2009 12:22 AM by Dave Peterson	1	120
Pivot Table Calculate Field by Brad Autry Hi, I have a fairly simple pivot table whose rows consist of various job post sources. So, for my small example, let's say the rows...	August 26th, 2009 12:22 AM by Dave Peterson	1	127
Inserting pictures into unprotected range in a protected worksheet by Fernando Reyes I have a worksheet with unprotected cells and ranges. I can type into these ranges but I can not insert pictures into the unprotected ranges. How can I...	August 26th, 2009 12:20 AM by Dave Peterson	1	109
How do I turn on Paste Special for linked data? by dlps I want to link data from one worksheet to another. When I click Paste Special, I get "unicode text" or "text" as my options. How do I get the full Paste...	August 25th, 2009 11:56 PM by Gord Dibben	1	112
Drop down list - color coding by Sue I have a spreadsheet and want my drop down list of names to be color coded. I have the orginal list color coded and when I created my list, the color...	August 25th, 2009 11:54 PM by Gord Dibben	1	112
Sending Fax Using Fax Numbers in Excel Spreadsheet by FredK I am using Excel 2003. I have a column in a spreadsheet that contains fax numbers. Is there a program or add-in that can utilize these numbers and send out...	August 25th, 2009 10:59 PM by FredK	0	112
Attendance formula for payroll please help by Tia[_3_] Hello, I am working a attendance and payroll sheet i have one sheet called "programm" that i update the date each month 30 or 31 days every working day is...	August 25th, 2009 10:11 PM by Tia[_3_]	0	91
Attendance formula for payroll please help by Tia[_3_] Hello, I am working a attendance and payroll sheet i have one sheet called "programm" that i update the date each month 30 or 31 days every working day is...	August 25th, 2009 10:11 PM by Tia[_3_]	0	95
Total Working hours If by Tia[_3_] Hella i am working a attendance and payroll sheet i have one sheet called programm that i update the date each month 30 or 31 days every working day is...	August 25th, 2009 10:03 PM by Tia[_3_]	2	116
Is there a way... by salgud[_3_] to do this without going to VBA? I track the Division vehicle for our group. Every 5,000 miles it needs an oil change. I have a spreadsheet to track the...	August 25th, 2009 09:53 PM by salgud[_3_]	5	116
Creating a function to auto hide rows by Robert G. Hello, I want to have a function that will look for a value ( 1 or 0 ) and based on that hide the current row. The value of "1", or "0" is being based off if...	August 25th, 2009 09:47 PM by Gord Dibben	1	92
I'm trying to include a cell reference as part of an ext. link by John M I want to pull data from another workbook, but I want the name of the workbook I pull from to be controlled from a drop-down in the main worksheet. I have...	August 25th, 2009 09:05 PM by Dave Peterson	4	84
Link to word document by mx Hello I am trying to create a link in an excel sheet to a word document as follows: ...\project\test%20whatever%20Specification%20.doc#35 the link is fine...	August 25th, 2009 08:03 PM by mx	0	88
Using a variable to point to a location by John I want to point to a name by its index number: =NameSheet!D The kind of formula I want to use is like this, only instead of the "12" I want to use a...	August 25th, 2009 07:27 PM by John	2	89
Formula for elapsed time by Hookette I have two cells with dates and time in them and I need to figure out elapsed time. When it's within the same month C2-B2 works fine, if it's months apart...	August 25th, 2009 07:26 PM by Hookette	3	117
Merging sheets by mo773w What is the best way to merge two sheets, deleting any dupicate row entries?	August 25th, 2009 06:08 PM by Jacob Skaria	1	86

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