Worksheet Functions - Page 614

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
File name Save by Elton Law[_2_] Dear Expert, A1 has a text "Performance2009_" A2 has a formula =Today() A3 is day(A2) = 11 (in this case) A3 is month(A2) = 4 (in this case) A3 is year(A2) =...	April 11th, 2009 06:30 PM by Dave Peterson	4	76
I can not sort data - why by CAKE LADY	April 11th, 2009 05:53 PM by Gord Dibben	3	53
Add rows depend on the number in a cell by Elton Law[_2_] Dear Expert, In A1, it has a number 3. In A2, it has a number 5. In A3, it has a number 4. I want to run a marco that add 2 rows if A1 contains a number of...	April 11th, 2009 02:09 PM by Don Guillett	3	95
Add Rows depends on the number in a cell by Elton Law[_2_] Dear Expert, In A1, it has a number 3. In A2, it has a number 5. In A3, it has a number 4. I want to run a marco that add 2 rows if A1 contains a number of...	April 11th, 2009 12:04 PM by Mike H	1	92
3 D reference of IRR formula. by sirocco Try as I may I have been unable to reference a cell containing an IRR function to a cell in a different worksheet. The problem is that in worksheet 3 (in a...	April 11th, 2009 09:08 AM by sirocco	2	95
Cell protection short cut button by Bert I am using 2007 now insteat of 2003. I cant find a short cut button to lock and unlock a cell. There was one in excel 2003 but as yet I can't find it in...	April 11th, 2009 05:56 AM by Bob Umlas, Excel MVP	1	105
I need to know how to use the solver by MS EUDORA I HAVE A PROBLEM WHERE I HAVE TO USE A SOLVER AND I CANT GETIT RIGHT I HAVE TO MINIMIZE THE VALUE OF ONE CELL BY CHANGING THE VALUE IN A RANGE SUBJECT TO...	April 11th, 2009 03:23 AM by Fred Smith[_4_]	1	86
WHETHER TO USE COUNTIF, SUMIF or SUMPRODUCT by dblevins I have 2 columns: names in column F and dates in column G. COL A COL B JET 4/1 JET 4/1 JET 4/1 FRED 4/1 I am trying...	April 11th, 2009 03:20 AM by Fred Smith[_4_]	4	118
Need to calculate the number of days between two dates on a 30 day by James Dasher I want to be able to calculate the days between two "dates" however I need it on a 30 day system. It doesn't run on a true calendar, but always on 30 days....	April 11th, 2009 02:46 AM by Ron Rosenfeld	5	98
Countif function with multiple column criteria? by Ryan Hello... I'm hoping someone, much smarter than I, can help me find a solution to my problem. Problem: My spreasheet looks like this (two columns): 1 day 2...	April 11th, 2009 01:36 AM by Dave Peterson	8	107
Excel If statement copy only if ISNumber result is yes by Austin I have two sheets in one excel document. I need to pull a parts description from sheet 2 to sheet 1 only if sheet 2's part description has a numeric value...	April 11th, 2009 12:13 AM by T. Valko	1	94
Choosing Names From a List by ppidgursky I am working on a schedule. Our schedule changes often and I am trying to simplify things. I have the schedule with Location A & B, Monday thru Sunday, AM and...	April 11th, 2009 12:08 AM by Gary''s Student	1	100
Dragging across columns: I want column constant, but row increment by CM I've searched for an answer to this problem and learned about using the $ to keep the row or column constant, but it does not seem to work the way I want it...	April 10th, 2009 11:47 PM by T. Valko	6	74
Inserting page breaks by Rich Mogy I have written a macro that will insert page breaks in my workbook everytime the word "Date:" is found. How can I eliminate Excel's automatic page breaks and...	April 10th, 2009 11:26 PM by Don Guillett	3	170
Need to stop formula and keep value on met condition by AUCP03 I have a spreadsheet I use to track tasks for my branch. All the information is in a list. Column C is due dates Cell J2 is the function =TODAY() ...	April 10th, 2009 09:26 PM by AUCP03	2	92
Get cell reference address by Vadims Podans [MVP] Hi! I'm interesting about this task. I have a table with data like this: N.p.k. Nosaukums ID Svars Iepakojums Cena USD par 100m Cena LVL par 1m Cena GBR par...	April 10th, 2009 08:50 PM by Vadims Podans [MVP]	2	90
finding a number within a range by Cathy Landry Hello, We have a PO log that tracks the PO number series and the clinic they were issued to. I have a vlookup that appears to work most of the time but for...	April 10th, 2009 08:45 PM by Cathy Landry	6	149
changing the vlookup col_index_num by dawn I have a spreadsheet where I update the col index number each week to reflect the new weeks data for about 100 customers. At this point each week I go in...	April 10th, 2009 07:49 PM by dawn	5	126
Multiple logics in one formula by Sri Harsha[_2_] I am working on creating an Effort Estimate Tool for Clients. I have 5 products Affinity, Quantim, QES, Interlink and COPE. For each product we have...	April 10th, 2009 07:40 PM by Sheeloo[_5_]	1	75
Stop displaying a message because of a formula by Urgent Help I have a formula very simple in 2000 columns. A B C 1 5 3 =IF(B3-A5=0, "ORDER COMPLETE") It works pretty nice, but i have the formula...	April 10th, 2009 07:29 PM by Mike H	2	83

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