Friday, July 26, 2013
Finding 2nd Largest Item in a List that meets more than 1 Criteria [Excel Array Formulas]
›
={LARGE(IF(Sheet2!$D:$D=Sheet1!$B$3,IF(Sheet2!$K:$K="",Sheet2!$H:$H,""),""),2)} You add the brackets by pres...
Wednesday, April 17, 2013
How to find the nth word in a excel cell
›
=IFERROR(IF($R$1=1,MID(O2,1,FIND(" ",O2,1)),MID(MID(MID(SUBSTITUTE(O2," ","^",$R$1),1,256),FIND("^",...
Monday, April 8, 2013
How to return the number of words in a cell?
›
Answer: the following formula will return the number of words in an excel cell. =If(LEN(TRIM(B1))=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(B1,...
Friday, February 11, 2011
Sum data found in a range or specific data
›
This function lets someone take the sum of data in a row that matches a range of data so you don't have to do a sumif() function over an...
Tuesday, January 25, 2011
Count the Number of Colored Cells in Excel
›
First open the workbook in which you wish to count or sum cells by a fill color. Now go into Visual Basic. Insert new module: Code: Funtion ...
Monday, January 24, 2011
VBA Code for Random Generation of Stats
›
CoinToss() Dim x As Integer Dim Row as Integer Dim NumberOfFunds As Integer erOfFunds = Sheets("Sheet1").Range("NumberOfPeopl...
Find Function in VBA
›
----------This Search Feature allows you to add a variable such as strMyString------------ ----------strMyString can be any value you want t...
›
Home
View web version
