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

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
How do I validate data from another validation cell? by Bo I am currently working on a project that I can't figure out the last few details. This is similar to what I have: Program: (followed by validated list of... ( 1 2 3)	May 13th, 2005 11:10 PM by Max	20	276
COUNTIF in between rows by Vasilis Tergen How would I find the maximum amount of intervals between "Larry" re- appearing in column A? I must use a formula- not a macro or a filter. The correct answer... ( 1 2 3)	January 13th, 2007 10:22 PM by Vasilis Tergen	20	176
Compare columns, count matches by adodson I'm looking to compare two lists (a1:a10 compared to b1:b10, unnamed). Then, return the count of original matches between the two lists. For example, if... ( 1 2 3)	January 25th, 2007 02:34 AM by T. Valko	20	233
Showing Top 30 with array-formula? by [email protected] Hello there; I have a list with values from A1:A2000 from which Iwould like to retrieve the Top 30 (largest values) in B1:B20? I think I have seen it done by... ( 1 2 3)	July 1st, 2007 05:33 PM by Dave Peterson	20	193
My Final #DIV/0! that I'd like to say Goodbye to! by Dan the Man[_2_] The following cells on my spread sheet produce the #DIV/0! error under the following circumstances, and I'd prefer the cells to remain "blank" until data is... ( 1 2 3)	July 23rd, 2007 05:40 PM by Harlan Grove[_2_]	20	200
If/Then Statement by Karen I need help with an IF/THEN statement if anyone can be so kind. The formula will be placed in column U. In column F there could be a number 1, 2, 3, 4 or... ( 1 2 3)	August 14th, 2007 06:53 PM by Pete_UK	20	196
Tricky IF/Then Date based formula needed by Titanium Column A has the date and time displayed: Thu, 06/14/07, 11:15 Column B needs to calculate: "If (A=Mon to Fri from 7:00 to 20:00, Sat from 7:00 to 15:00, Sun... ( 1 2 3)	September 6th, 2007 01:50 AM by Titanium	20	225
Date Conversion Formula Needed by Titanium From a database some info is generated that reads "20070917 at 1900". I need to be able to generate "9/17/07 at 19:00" At first I was thinking I could use a... ( 1 2 3)	September 16th, 2007 09:18 PM by Titanium	20	199
Modifying only the worksheet when draging down a cell reference by [email protected] How can I change only the worksheet when I drag down a cell reference. these are all worksheets in an active workbook. We are creating a summary table in... ( 1 2 3)	September 29th, 2007 03:22 AM by Max	20	196
Find a range of values in a range of cells by Jack Taylor I have a spreadsheet that contains contribution data. Each cell in the range G4 through G780 contain individual contribution amounts. I would like be able... ( 1 2 3)	November 25th, 2006 01:26 PM by Ron Coderre	20	148
copy a list and skipping blanks by ART Which formula do I use if I want to copy a range of cells but skiping the blanks. For example, in column A is a list of items, and in column B is a list of... ( 1 2 3)	November 29th, 2006 03:21 PM by ART	20	240
lookup more than one cell by andrewm Is it possible to lookup on more than one lookup table simulatenously. I was told to use lookup and not an if statement as I cannot use more than 7 nested... ( 1 2 3)	June 14th, 2005 05:33 AM by mangesh_yadav	20	522
vlookup function return all values by j2thea My table for vlookup: A1:B4 1110 2 or it can have one key 1110 2 1110 3 3 1120 4 ... ( 1 2 3)	November 2nd, 2005 10:32 PM by Domenic	20	504
VBA function for "Mean" using Array as argument by ASokolik I am trying to create a function in VBA (possibly an add-in in the future) to calculate Relative Standard Deviation (RSD). I would like to be able to use an... ( 1 2 3)	March 28th, 2006 08:57 PM by lantern20	20	360
How many similar functions can be put in one cell? by Forrest I have a formula in one cell with several functions used multiple times. It seems though that 25 times is the max for the Round function before it blows up. ... ( 1 2 3)	October 28th, 2005 12:36 AM by Ron Rosenfeld	20	280
Removing Rows for Printing by Frick I have a report that pulls data from another worksheet in Range A26:J58. What I want to be able to do is assign a button for printing the report but before... ( 1 2 3)	March 10th, 2006 10:53 PM by Ron de Bruin	20	403
Count the number of unique Numbers in a column by ajajmannen Hi!! i'm currently trying to count the number of unique numbers in a Column using this formula: =SUMPRODUCT((A3:A3002"")/COUNTIF(A3:A4002;A3:A3002&"")) So... ( 1 2 3)	May 10th, 2006 06:03 PM by Domenic	20	200
Intersection point return data by tvtime First, thanks to Peo for helping me truncate time AND lookup all in one formula. Second, I'd like help with an 'intersection' formula, if possible. ... ( 1 2 3)	July 27th, 2006 07:20 PM by Biff	20	168
Return Min & Max value of Conditional Formatted cells by Sam via OfficeKB.com Hi All, Is this possible with a Formula?... I would like to retrieve the Minimum and Maximum from numerous columns with cells that already have Conditional... ( 1 2 3)	September 5th, 2006 10:56 PM by Domenic	20	197
vlookup formula by Gemz Hi, I have the following 2 formulae and i have been desperately trying to make them work but the dont! I am looking up the value of column D in 1 worksheet... ( 1 2 3)	January 24th, 2008 04:16 PM by Gemz	20	217

Page 12 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 02:28 AM.