Excel calculated value in a text string="Buy In $50 Pot - Total Pot Winning pot " &TEXT(COUNTA(A3:A21)*50,"$0.00")
Calculate for non blank values=IF(ISBLANK(D3),"",($C3/D3)-1)
Convert minutes to Hours and minutesFormat the cell as time format =H13/1440
Macro to hide columnsSub 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
SubstringServername 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)
|
|