Worksheet Functions - Page 64 - OfficeFrustration

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

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
How do I add additional columns beyond column "IV"? by Adding Columns I'm exporting data from QuickBooks which goes beyond Column "IV" in Excel verison 2007. Is there a way to set-up Excel to increase the columns?	November 12th, 2008 03:16 AM by Dave Peterson	1	85
Copy rows but need to refer to same cell in original formula by addison I need to copy/paste 5 original rows multiple times in worksheet but need formula to refer back to same static amount in cell k3. How can I do this without...	April 4th, 2008 04:29 PM by addison	4	99
Exel 2003 Copy Formula Problem by addison I have used Exel for years and never experienced this issue. I am trying to simply copy (drag) a formula from one cell down the column and it will only copy...	December 12th, 2007 06:49 PM by addison	4	77
Nesting Networkdays function inside and If function by Addison Hello - I'm working on a massive payroll analysis. I'm wondering if it's possible to nest a networdays inside of an if function. I pasted a formula below...	April 13th, 2006 08:04 PM by Bob Phillips	2	168
WEEKNUM to dynamic range name by additude I need to take a column of dates starting from Jan 1 of the current year to Dec 31 of the current year (cells from A2 to A366) and assign each week of that...	July 23rd, 2006 08:12 PM by daddylonglegs	5	132
Sort referenced sheets together! by Addy I would like to know that how can I sort one sheet and accordingly get other sheets to sort with it. Problem being faced: USing 8 Sheets which referenced to...	January 12th, 2006 02:47 PM by Addy	3	89
Substitute for Dragging by Addy I am looking to fill a formula in specific cell say A2 then I want this formula to be there in the whole column A, i.e. from A2:A65536 Till now the only way I...	January 12th, 2006 08:32 PM by Gord Dibben	4	85
How do I use the excel function "funformula"? by Ade How do I use the excel function "funformula"?	August 18th, 2008 07:18 AM by Héctor Miguel	1	62
make a cell red after 14 days by ade hi i want to enter a date in a cell and when 14 days have passed i would like that cell to turn red. is this possible?? thanks ade	July 3rd, 2006 12:21 AM by CLR	2	63
lookup number greater than by Ade Taiwo I want to Look in a one-row or one-column range for a value and return a value from the same position in a second one-row or one-column range, but instead of...	June 17th, 2009 06:43 PM by Luke M	1	141
lookup number greater than by Ade Taiwo[_2_] I want to Look in a one-row or one-column range for a value and return a value from the same position in a second one-row or one-column range, but instead of...	June 17th, 2009 05:52 PM by Mike H	3	167
If Then by ADean I'm trying to find a formula that will continue to search for a row that meets the specified IF criteria without returning the rows that do not. i.e. I want...	September 20th, 2007 03:32 AM by Teethless mama	5	58
Excel - filter results in column, need to find adjacent column data by adeater I have columns of data P3:P1007 and that is filtered for the 5 largest and 5 smallest values...	July 21st, 2004 04:08 PM by Domenic	5	264
conditional formating If A1 or B1 is blank then C1 (Font Colour Ch by Adeel Hello, I want to apply conditional formating to the following simple scenario, If A1 or B1 is blank then C1 (Font Colour Change) Awaiting for the suggetion of...	September 18th, 2008 11:16 AM by Mike H	7	87
Worksheet protection by adehart I am working with a group of files that unfortunately were protected. Is there a way in Windows Explorer that I can unprotect all the files in a directory...	October 16th, 2006 02:57 PM by vezerid	1	58
Retain INDIRECT() Data by Adel Good day Is it possible to retain data pulled through from another workbook when using an INDIRECT() function once that workbook has been closed? Or...	December 8th, 2009 02:27 PM by Dave Peterson	2	164
Use Index to get range by Adella I have a dget function that I want to use different range and criteria ranges depending on a flag. I thought that index would work but I am getting a value...	November 17th, 2005 05:56 PM by Adella	4	160
formula issues by adella40 How do you enter data, simultaneously, in two different worksheets?	May 5th, 2007 12:19 AM by Gord Dibben	2	50
combining and sorting 2 lists by Adelle sayegh I am trying to include details from one list into another and sort by name yet there seems to be a limistation that the new additions get sorted and go at the...	January 18th, 2006 08:56 AM by Adelle sayegh	2	63
how do I paste range name list? by Adesso Part of my homework assignment is to paste a list of all existing named ranges. How do I do that?	January 20th, 2007 10:22 AM by mike	2	46

Page 64 of 4390

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 09:16 AM.