Worksheet Functions - Page 544

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
Count letter"B" in one column based on unique value among duplicat by Mero Hello, Need to know how to count the letter "B" in column J based on unique values among duplicates in another column. Column D Column...	May 21st, 2009 12:26 PM by Mero	4	109
refer some letter from one cell(pipe/mech or mech/pipe (reqd: pi) by PERANISH Hai I having text in one column like Col - A piping/mech mech/piping piping/painting i need rsult for each row --- pi if Piping No need to refer others....	May 21st, 2009 10:19 AM by PERANISH	2	125
Help on complex multi-column sum is appreciated by DocBrown I would appreciate some direction on how to perform the following complex sum. I expect it to have several subtotals, and maybe a sumproduct that are added...	May 21st, 2009 10:11 AM by DocBrown	0	105
Help on complex multi-column sum is appreciated by DocBrown I would appreciate some direction on how to perform the following complex sum. I expect it to have several subtotals, and maybe a sumproduct that are added...	May 21st, 2009 10:10 AM by DocBrown	0	113
Help simplifying IF OR formula by Divya Hi, Can I write this a better/simpler way? IF(OR(A2=$A$1, B2 = $A$1, C2 = $A$1, D2= $A$1),1,0) Basically comparing a range of cells to one value and...	May 21st, 2009 09:53 AM by mubashir aziz[_24_]	6	210
Return a column value from a horizontal search by Spag Hello I'm trying to look across a row for a non blank cell and return what is in the first cell of the column in which the non blank cell is found. Does...	May 21st, 2009 08:42 AM by Spag	8	94
autofilters on worksheets within workbook by cheryl i'm using Excel 2007. I have about 12 worksheets within a workbook. I want to know how I can clear the filters on all worksheets and return each worksheet to...	May 21st, 2009 08:27 AM by cheryl	2	142
How to perform logistic regression in Excel 2003 by jbottg As far as I can tell the Statistical Analysis Tool add-in and statistical functions in Excel 2003 do not support a logistic regression model. I'm no expert...	May 21st, 2009 06:29 AM by jbottg	2	184
Crazy Hard Function by Chris Well, as the title says, I've got a hard function, and I'm at a loss, so here goes what I'm trying to code. This function will be on Sheet20. Where cell... ( 1 2)	May 21st, 2009 05:58 AM by Chris	17	214
Decorative Pillows India by [email protected] Ruby Kilim ~ Rustic Red Black Euro European Pillow Sham Cover 27x27 Price:$22.99 Image: http://bestdeallocator.info/image.php?id=B0018VCT1S Best deal:...	May 21st, 2009 05:39 AM by [email protected]	0	206
Help with identifying time and time zones in a formula by Mr BT[_2_] =Q278&" "&TEXT(J278,"hh:mm")&" CST "&N278&", "&P278&" SAB" I have the above formula in column M where column J will be entered the current time. I need the...	May 21st, 2009 05:23 AM by Jacob Skaria	1	92
Cup Holder by [email protected] Norpro Grip-EZ Tea Infuser With Cup Price:$3.99 Image: http://bestdeallocator.info/image.php?id=B000SSU8Z6 Best deal:...	May 21st, 2009 05:09 AM by [email protected]	0	137
Meyer Kitchenaid by [email protected] KitchenAid Gourmet Reserved Red Double Burner Griddle Price:$80.00 Image: http://bestdeallocator.info/image.php?id=B000I2Q4G4 Best deal:...	May 21st, 2009 05:08 AM by [email protected]	0	120
Compare and count if data elements on two worksheets are similar by aascasacspas I need to compare text in a range of cellw on worksheet 1 to a cell in worksheet 2 AND text in another range of cells in worksheet 1 to another cell in...	May 21st, 2009 04:59 AM by Teethless mama	1	108
Creating a Automatic Alpha transfer from other sheets? by Teresamlo How do I create a cover sheet that only automatically transfers the alph and numeric items from another sheet, for example, I have five lines of alpha and...	May 21st, 2009 04:51 AM by Teethless mama	1	87
SUMIF using two criteria to count by mokihi I would like to use a sumif function to count the values in column C if Column A is a "Monkey" and Column B is "before 1/1/2009". Thanks in advance A ...	May 21st, 2009 04:49 AM by Jacob Skaria	2	76
Double Bowl Undermount Kitchen Sink by [email protected] Lesscare Sink - Kitchen Stainless Steel Undermount Sink L-201L Price:$139.00 Image: http://bestdeallocator.info/image.php?id=B000QJ8TXU Best deal:...	May 21st, 2009 04:37 AM by [email protected]	0	121
Clean Fish Tank by [email protected] Python No Spill Clean and Fill Price:$46.07 Image: http://bestdeallocator.info/image.php?id=B000255NXC Best deal:...	May 21st, 2009 04:32 AM by [email protected]	0	173
Return Top values with changing criteria by [email protected] I am trying to return the top N values from a list with corresponding names. The criteria for ranking changes. ColA:C contain my data (thousands of rows). ...	May 21st, 2009 04:08 AM by Ashish Mathur[_2_]	9	109
Bathroom Sink Plug by [email protected] 4" Lavatory Faucet with PO Plug - ABS Price:$20.56 Image: http://bestdeallocator.info/image.php?id=B000VY2WBA Best deal:...	May 21st, 2009 03:53 AM by [email protected]	0	99

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