Excel
Excel calculated value in a text string
Excel calculated value in a text string
http://office.microsoft.com/en-us/excel-help/text-function-HP010062580.aspx
="Buy In $50 Pot - Total Pot Winning pot " &TEXT(COUNTA(A3:A21)*50,"$0.00")
Calculate for non blank values
Calculate for non blank values
http://office.microsoft.com/en-us/excel-help/text-function-HP010062580.aspx
=IF(ISBLANK(D3),"",($C3/D3)-1)
Convert minutes to Hours and minutes
Convert minutes to Hours and minutes
Format the cell as time format
=H13/1440
Macro to hide columns
Macro to hide columns
Sub Button2_Click()
Dim cl As Range, rTest As Range
Set rTest = Range("d2", Range("d2").End(xlToRight))
For Each cl In rTest
If Not cl.Value = "blah" Then
cl.EntireColumn.Hidden = True
End If
Next cl
End Sub
Substring
Substring
Servername
Datacenter =MID(A2,17,3)
Product Code =MID(A2,8,3)
Swimlane =MID(A2,8,3)
Type =MID(A2,11,2)
Environment =MID(A2,3,4)
Tier =MID(A2,2,1)