Friday, August 1, 2008
Concatenate Implementation
In this post, you will see guidance how to apply concatenate function.
Because animation picture are a little big (800kb), so you must click Readmore link below. It will directing you to full post.
Click button below to play the video:
Last name formula (to extract last name from full name):
=LEFT(A18,FIND(",",A18,1)-1)
First name formula (to extract first name from full name):
=MID(A18,FIND(",",A18,1)+1,LEN(A18)-FIND(",",A18,1))
Couple name formula (to join both first name with same last name):
=IF(B18=B19,CONCATENATE(C18," & ",C19, " ",B18),"")
Lock Cells with Button and Macro
In this post, you will see guidance how to lock cells using button control panel and macro.
Because animation picture are a little big (600kb), so you must click Readmore link below. It will directing you to full post.
The code are: (from Jim Gordon)
Sub LockemUp()
' LockemUp Macro
' Macro recorded 7/30/2008
Cells.Select
Selection.Locked = True
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
Thursday, July 31, 2008
Wednesday, July 30, 2008
Find Inverse Matrix
You know, calculate inverse matrix need hard work. Specially for matrix with wider than 3 dimension. So we do not need manually calculate it by pen. Just using Excel. Simple and Fast ;)
See Below:
Monday, July 28, 2008
Sunday, July 27, 2008
Minimize Ribbon (Excel 2007)
Sometime we dont neet to see ribbon to make us see larger view of cell.
Readmore »»
Subscribe to:
Posts (Atom)
