Worksheet Functions - Page 3895

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
Dates by aeroman55 How can I return a date, six months plus the first of the following month from a specified date? In other words, both January 1, 2005 and January 31, 2005...	January 11th, 2005 06:26 PM by Jason Morin	2	105
table by dow I need help making a table in Excel 2000. I want to make a table in a worksheet (sheet 2) that incorporates numbers (calculation 1 & caculation 2) that are...	January 11th, 2005 05:17 PM by dow	0	123
Using a grouping of cells to check one cell against another... by deucer Hello, There is a group of 56 cells that contain 3 letter groups (i.e. DCM, DCP, DCE, NTP). There is a column of cells that are listed in the following...	January 11th, 2005 04:19 PM by JulieD	1	209
conditional formatting conflict? by Abi I have a three column sheet. The first column pulls information from another sheet. The the other two are going to be blank with underline where someone will...	January 11th, 2005 03:41 PM by Abi	2	418
Help! + and - and blank cells by Helen Black I am trying to do a worksheet for our drivers hours, I have totalled up their hours and deducted 48 hours max working week, I have then deducted 48 hours off...	January 11th, 2005 02:38 PM by Helen Black	0	91
templates by Terri I would like to create my own worksheet to save as a template for accountancy book keeping for small business. I have searched for suitable templates...	January 11th, 2005 01:23 PM by Terri	0	82
SUMPRODUCT TO CALCULATE VISIBLE CELLS ONLY by Debra Dalgleish There's an example here that counts visible cells in a filtered column. You could modify the SUMPRODUCT formula to reference your cells, and add one more...	January 11th, 2005 12:58 PM by Lisa	3	147
Showing the column of current day by Sepiax Hello. I have a worksheet that is like a calendar, with a column for each day. I want to keep track of past days and also to show future days, exactly like a...	January 11th, 2005 11:33 AM by Bob Phillips	1	68
COUNTIF BOLD by Ola Hi Press Alt+F11. Insert Module. Copy and Paste the below. Public Function FontBold(MyCell As Range) As Variant FontBold = MyCell.Font.Bold End...	January 11th, 2005 10:49 AM by Sean	1	122
excel tests by Sir Paul I designed a spreadsheet to do these basic formulas, but what I wanted my students to do was look at my spreadsheets and try assess what I was trying to work...	January 11th, 2005 05:13 AM by Sir Paul	0	80
Removing Hard Borders from Excel Spreadsheet by Battery Dude I have ben tasked with revising some price sheets for our company. I am having problems removing the hard border which is aroud the spreadsheet. Have gone into...	January 11th, 2005 04:28 AM by Max	1	119
how to use lookup a value by date for criteria in Excel sheet by Thank you for your help, it seem function one of part. I also prefer when I change sheet2 "A2" value to 3.2.2001, the sheet2 "C3" value will be changed to...	January 11th, 2005 04:22 AM by Max	2	372
Link - deactivate being sent to source when click on linked cell? by Dave Peterson It sounds like your hyperlink is still there, but the cell isn't formatted in a hyperlink style. Select the cell and hit Insert\|Hyperlink (or ctrl-k) See if...	January 11th, 2005 02:11 AM by Dave Peterson	0	408
Using The Average Function if a cell has NA by JE McGimpsey You've been given solutions for what you asked for, but in general, it's poor practice to return expected "errors" as errors. If you trapped the NA error,...	January 11th, 2005 01:59 AM by JE McGimpsey	0	160
In Microsoft Excel, how to I enable the arrow keys? by Carol Yes, my cat must have stepped on the key. Thank you. Carol "Chip Pearson" wrote: Use the arrow keys. Most likely, the Scroll Lock is on which causes the...	January 11th, 2005 01:51 AM by Carol	0	269
Conditional format with and OR statement by Dena How would I enter a conditional format formula with an OR statement? I would like to have a cell change to a specific colour if it is equal to 15, 20, or...	January 7th, 2005 05:34 PM by Dena	0	300
Conditional Rank by spolidm Hello - I have a situation in which I need to get the top 2 revenue values based on 2 different conditions (office and position). I can get the first easily,...	December 28th, 2004 05:16 PM by spolidm	0	114
How can I count #N/A in a column? by Rasoul Khoshravan Azar Dear Domenic Thanks. It was easy but informative. Regards, Rasoul	December 21st, 2004 06:52 AM by Rasoul Khoshravan Azar	0	77
Implicit rate calculation by LBJones Can someone help me calculate the interest rate (or implicit rate) on the following cash flows? It should be a negative #, due to the residual. (the first 6...	December 16th, 2004 07:38 PM by LBJones	0	204
Hiding #N/A by Mick Can anyone help please with how to hide #N/A please? I have tried conditional formatting but cant get the settings right. -- Kind Regards Mick ---	November 30th, 2004 09:18 AM by KL	1	90

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