Worksheet Functions - Page 3 - 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 3 of 4390

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
Navigating by ~ One Fine Old Dude I minimize Excel and size it so it uses 1/2 of my monitor window. I open another window in the other half so I can copy data from this to Excel. On...	June 6th, 2007 06:38 PM by ~ One Fine Old Dude	0	55
How to Concatenate with a text & number by \|\| cypher \|\| A1 will have a 4 digit number and letter (ex: 1332s) B1 will have a number between 1 & 999 I am trying to get C1 to concatenate the two, taking the B1 value...	June 25th, 2005 12:43 AM by Damon Longworth	1	123
RETURN intersecting value with known horizotal & vertical?? by \|\| cypher \|\| How would I have a cell return a value based on the intersection of two other cells. I have A1 with a Validated List running vertically (the percentages) I...	February 2nd, 2005 09:27 PM by Ken Wright	4	134
excel - query by \| m o [] hi! I am preparing a basic calculator for myself for some funds and I got into a trouble... there is a excel file U can...	November 29th, 2004 05:39 AM by Ian Huitson	1	151
macro problem related with all worksheets by ___Zoom Hi, I have a workbook with a lot of worksheets. I need to write a macro that: a) takes an input of date in (dd.mm.yyyy) format. b) takes an input of some...	August 4th, 2007 07:58 AM by ___Zoom	7	89
Help needed with priority list by _SPCA I need to take this list and pick a color by means of priority. In this example, I put a priority of 1 for the color of orange in the cell next to the color,...	January 20th, 2005 10:24 PM by _SPCA	0	93
Worksheet Name by _Pete_ Hi All, I am a first timer. So bare with me. I would like to get the workbook name and place it in a cell in the worksheet. This is what I do. I copy a...	May 26th, 2009 05:05 AM by Jacob Skaria	2	70
Autofilter - can I increase the drop down font by _Jonah Is it possible to increase the size of the font when using autofiltering dropdowns in Excel? Jonah	September 16th, 2005 08:06 PM by _Jonah	6	85
Password Protecting Sheets in Excel So Others Can't See Certain Sh by _ian2006_ Hopefully this won't be too confusing. I have a workbook with 3 sheets in it. One sheet for one partner, one for another, etc. Without having to create 3...	February 23rd, 2006 05:38 PM by JE McGimpsey	3	92
if statement limit?? by _Bigred Is there a way around the if statement limit??? TIA, _Bigred	June 30th, 2004 11:17 PM by Harlan Grove	5	141
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
using functions after (using autofilter) by _Bigred Hello All, (Excel 2000) If I have a sheet and use auto filter, I will would like to be able sum, average etc... it's results without fixing the cell...	November 25th, 2003 03:44 PM by _Bigred	4	177
date related question??? by _Bigred I currently have a sheet that has the following columns: CurrentDate, SeniorityDate,TotalYears and other columns. 01/03/07, 10/19/92,14 I would like the...	January 4th, 2007 01:23 AM by Franz Verga	1	96
Nested Limitations by _Bigred I have a excel worksheet that I want to do the following: If A1 has OFC and B1 has 1992 then C1 returns a value of 20.33 However I'm trying to create the...	March 16th, 2006 08:31 AM by George	3	57
search box in excel 2003? by _Bigred I use excel 2003 Is there a way to create a search box on the top of a sheet instead of continually using the find option under "edit". I would like to be...	December 10th, 2005 03:46 PM by Dave Peterson	1	77
how to count weeks from date "X" then calculate by _Bigred I want to create a field(s) in Excel 2003 that will allow me to enter a hard (non-changing date) and have it calculate how many weeks have eclipsed since that...	October 18th, 2005 09:35 AM by Arvi Laanemets	6	102
counting yes' (that are selected from data validation) by _Bigred (Excel 2000) I have a column that for each record you select Yes or No (from another column - i.e. data validation). What formula I use to count these Yes',...	December 22nd, 2003 02:40 AM by Jim	1	132
? doing IF(N8="pilot",(AB8+.05) but how do I avoid the "false" value for nonmatching??? by _Bigred I am currently using the formula below (i'm trying to add 5¢ if a person if a pilot). But this formula returns FALSE for anyone not matching pilot. How do I... ( 1 2)	March 9th, 2005 03:59 PM by JulieD	10	164
removing part of field by _Bigred I have a excel 2000 file that contains 300-400 records. The field in question contains data such as: OSHKOSH, WI 54901 OSHKOSH,WI 54902 OSHKOSH,WI **... ( 1 2)	June 30th, 2004 06:59 PM by Harlan Grove	10	578
calculating future contract values (approx 10yrs) by _Bigred (excel 2000) 1) I currently have a cell that shows a yearly salary without a length of service payment 2) and a cell that shows a yearly salary "with" a...	September 28th, 2003 10:14 AM by _Bigred	0	229

Page 3 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 10:28 PM.