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

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
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
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
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
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
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	100
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
Calculate weeks cover by \Kevin Carroll via OfficeKB.com\ I'm trying to calculate the number of weeks cover an inventory value represents. My worksheet is laid out as follows: Each Row represents a week Col A ...	July 8th, 2005 01:00 AM by Kevin Carroll	2	197
count unique with conditions by \ditzman via OfficeKB.com\ I am looking for a function or group of functions that can help me count the unique entries that meet two other criteria. The table is similar to: Column A: ...	July 8th, 2005 12:41 PM by slc	8	256
2007 ä¸çš„å·¥å…·åˆ—é…ä¸: è³‡æ–™--è³‡æ–™å·¥å…·--å‡è¨ç‹€æ³åˆ†æž--è³‡æ–™è¡¨, è«‹å•é€™åŠŸèƒ½æˆ‘å¦‚ä½•åœ¨2003ç‰ˆä¸æ‰¾åˆ°??? by åœ¨2003ä¸æ‰¾2007çš„åŠŸèƒ½* 2007 ä¸çš„å·¥å…·åˆ—é…ä¸: è³‡æ–™--è³‡æ–™å·¥å…·--å‡è¨ç‹€æ³åˆ†æž--è³‡æ–™è¡¨, è«‹å•é€™åŠŸèƒ½æˆ‘å¦‚ä½•åœ¨2003ç‰ˆä¸*æ‰¾åˆ°???	March 11th, 2010 06:08 PM by Gareth_Evans (InterCall EMEA)[_2_]	2	151
How can I turn off the [VSync] mode in my excel file? by [VSync] off? Hello, Can somebody help me? I am working on my excel file & need to open this file in a new window without using the mode. The thing is I need to look...	August 7th, 2007 06:19 PM by Dave Peterson	5	76
SumProduct & Index functions by [G]rumpy [O]ld [D]uffer I have an EXCEL file (call this "Database") that in a simplified form looks like this (Col. & Row Headings shown):- A B C D E F G 1 Day Loc. 1 Loc. 2 Loc....	July 2nd, 2004 01:32 PM by Domenic	1	89
Links showing #VALUE! by [G]rumpy [O]ld [D]uffer I have an EXCEL file (named 'Master') with 2 worksheets. On each of these worksheets I have formulae which links with data on 2 different EXCEL files (named...	May 26th, 2004 10:49 PM by Frank Kabel	1	117
Need to work out a timesheet with times going into next day (24 h by z_insyd Im trying to work out a time sheet for work and the problem is that i work with 24 hr clock and shifts can start at any time over that period and finish...	July 21st, 2007 08:12 PM by z_insyd[_2_]	5	68
Lookup funtion referenced from another sheet. by zzzaps Is ther a way to force the Auto Complete to reference another sheet? What i want to do is have sheet 1, row 1 referece sheet 2, row 1 for the auto complete...	March 9th, 2006 04:00 PM by zzzaps	2	84
2 criteria lookup of text. Return text form column 3. SUMPRODUCT t by zzxxcc Hi Can I use SUMPRODUCT to lookup two criteria text values in sheet1, cell A2:A100 and B2:B100 and return the text from C2:C100? The formula will be in...	August 26th, 2008 11:04 PM by zzxxcc	2	108
Names of workbook cell ranges not accepted with some signs by zzxxcc I have named a range of cells based on the top row in each column. S1:CR20. Some names need signs like"/" and "-" and """, etc. This doesen work with...	August 20th, 2007 02:02 PM by zzxxcc	1	69
Search, find or lookup defined text in text string by zzxxcc My data in B2:B1000 contains text and numbers. In D2:D1000 I need to return the findings of a search in B2. Eksample: The text in B2 is "Add FCM#6". I want...	September 6th, 2007 09:37 PM by Ron Rosenfeld	9	131
How do I convert a cell(s) from the formula to it's contents? by ZZBC Using Excell 2000 ... I have data being retrieved from another sheet Cell A1 of the Input Sheet, for example might contain the words "This is a TEST" Cell A1...	January 30th, 2006 03:05 PM by Otto Moehrbach	9	149
How can I test if a Macro if firing? by ZZBC I was given this code from another post "How do I convert a cell(s) from the formula to it's contents?" . Private Sub Worksheet_Change(ByVal Target As...	January 31st, 2006 03:09 AM by ZZBC	6	99

Page 4 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 07:57 AM.