Worksheet Functions - Page 4282

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
Nested IF's and VLookup Tables by darkangelstorm Hi if anyone could help me i would be grafeful, the problem im having is trying to use nested if's with vlookup tables. for...	November 18th, 2003 06:15 PM by Harlan Grove	5	360
Data Validation by Connie I have posted this question, worded differently, before in this newsgroup and have tried to follow the instructions but I'm not getting the results I would... ( 1 2)	November 18th, 2003 05:38 PM by Connie	10	488
Custom Views in Excel 97/2000/XP by StefV Dear, Since we had edited a file a month ago, (when it still worked) we get errors in Excel and Excel closes. This problem only occurs with one...	November 18th, 2003 05:14 PM by Max	1	565
count cells that fall within a range of numbers by Dan E Robin, If you want the range 14 = X = 30 use: =COUNTIF(A1:A100,"=14") - COUNTIF(A1:A100,"30") OR =SUMPRODUCT((A1:A100=14)*(A1:A100=30)) includes 14 and...	November 18th, 2003 05:04 PM by Paul	1	658
editing chart source data by NO more new fonts may be applied to this workbook	November 18th, 2003 05:00 PM by Jim	1	216
I Need To Calculate Total Hours by scw1217 Okay, assume I am a total Excel dumby (which is the truth). I know only basic functions of Add, Subtract, and Multiply. However, I need to set up a payroll...	November 18th, 2003 04:39 PM by Paul	2	342
adding/deleting cells in a named range of cells by Tat Once you have named nonadjacent range of cells and used a formula to calculate that range how can you add additional rows to be included without having to...	November 18th, 2003 03:38 PM by	2	456
Generate new document with data by Jon Barchenger[MS] Good morning Rose - What you describe so far can be done with a macro in Excel. You could start by recording a macro that does what you want it to do - from...	November 18th, 2003 03:30 PM by Jon Barchenger[MS]	0	540
Help by David Herring Having spoken to my manager - here is a list of things that would be useful for me: IF functions (also IFISERROR) LOOKUP tables Connecting to...	November 18th, 2003 03:26 PM by Bryan	2	112
Circular Formula (Reference) by PJM I have a workbook for a company budget with an intentional circular reference (calculate a loan balance, then calculate the interest charge on that which...	November 18th, 2003 02:41 PM by PJM	0	299
Name conversion by I have a spreadsheet that is updated by multiple users. When they enter their names they enter it in the format (first_name Last_name). Does anyone know how I...	November 18th, 2003 04:35 AM by immanuel	1	109
need help with formula(s) by _Bigred (Excel 2000) I need to create a formula that does the following: 25¢ per hour added on, if you are under $13.00 (but you could only move to a maximum of...	November 18th, 2003 02:13 AM by CLR	7	137
How do I get a filter to "UPDATE" the rows selected? by Phillips Hey there! I am using Excel 2002 and I have a speadsheet that has prices in it. If I have the filter set to (the filter criteria is much more complex...	November 18th, 2003 02:04 AM by Debra Dalgleish	3	220
Home Loan calculation by KP Does anyone have charts for amortization and comparing 5- 1 ARM, 7-1ARM, 30-yr fixed loans etc? Thanks Kaushik	November 18th, 2003 02:02 AM by 2rrs	1	141
lines by John Loyd I am trying to print an excel spreadsheet showing lines and I can't seem to figure out how. Can someone help me?	November 18th, 2003 01:41 AM by Gord Dibben	2	83
What formula would show me I already entered an invoice number once before? by Marvin Hlavac Hi All, In column A I enter invoice numbers. Occasionally the same invoice number is entered by a mistake. How to avoid that? Perhaps in column B a warning...	November 18th, 2003 01:40 AM by Marvin Hlavac	4	524
Copy Duplicate rows by vrmomo I have about 3000 rows in worksheet1 and 3500 rows in worksheet2. Is there anyway to copy all the duplicate rows from worksheet1 & worksheet2 to...	November 18th, 2003 12:54 AM by Max	3	499
Allow a circular reference by Paul "Nali" wrote in message ... I need a formula that keeps a running total. I...	November 17th, 2003 11:48 PM by J.E. McGimpsey	1	336
Excel by Lmiller048 I'm putting together a spread sheet to show the month % change. My columns run from Jan - Dec with a YTD column. And I need to calculate the difference, can...	November 17th, 2003 11:46 PM by J.E. McGimpsey	1	83
timeline? by Leslie I have the data below: Number of Jobs BeginDate EndDate TotalDays 107 1/2/04 2/3/04 31 50 1/23/04 2/20/04 28 etc... How can...	November 17th, 2003 10:33 PM by Bob Phillips	2	92

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