Worksheet Functions - Page 4387

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

4387

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
need help comparing data in 2 separate worksheets by \Wayne via OfficeKB.com\ I am trying to figure out how I can compare data on 2 different worksheets. Here is what I am trying to do... I have Worksheet 1 (WS1)and Worksheet 2 (WS2)....	July 6th, 2005 09:02 PM by \Wayne via OfficeKB.com\	0	92
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
problem conditional formatting? by _Bigred I have a sheet that has approx 7,000 rows. Until I get all the data into it many columns will contain: #DIV/0! or #VALUE! I would like to do some...	September 4th, 2006 06:02 AM by Max	6	133
Date (hours and still counting) by _Bigred I need to have a formula that will do the following: Count from July 1st, 2005 til present (not past June 24th, 2006). then provide the number of hours...	April 1st, 2006 04:23 AM by _Bigred	2	62
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
? 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
averaging percentages by _Bigred can someone tell me how to average multiple percentages? (Excel 2000) 69.1% 63.3% 63.3% ----- ?%	July 14th, 2004 01:32 PM by Wayhe	3	95
put everything after comma, into next column? by _Bigred I have a column that contains the following style of data: Smith, John Smith,John Smith,John (WCCS) Smith, John (WCCS) I would like to eliminate the "," and...	July 11th, 2004 03:27 PM by David McRitchie	4	110
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
COUNTING COLUMNS AFTER DATA FILTER by _Bigred (Excel 2000) Somone answered this a while back, but I lost it due to cpu crash. If I have a sheet that uses the "DataAuto Filter" feature, how do I...	December 16th, 2003 03:35 AM by Debra Dalgleish	2	233
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
using date in formula by _Bigred (Excel 2000) I have a point tracker for everything I eat (yes - I journal everything). I would like to just infinitely add items under each...	January 18th, 2004 05:15 AM by _Bigred	5	88
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
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
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
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
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