Learn New Formulas in Excel

Sub dell()

dim r as range

for each r in selection

if r.value="DL" or r.value ="KL" or r.value="PJ" then


r.entirerow.delete

end if

next r
end sub

 

Sum between into Cell Digit
1223	==      8
	=SUMPRODUCT(MID(B7,ROW(OFFSET($A$1,,,LEN(B7))),1)+0)

VLookup between two Sheet Data


=IFERROR(VLOOKUP(A2,Sheet2!A:B,2,0),VLOOKUP(A2,Sheet3!A:B,2,0)) 

Calculate your age with Formulas

DOB : - 10-Jul-1987
Today : - 15-Nov-2011

Years : - =DATEDIF(A2,B2,"Y")

(A2= DOB, B2=Today)

Month : -
=DATEDIF(A2,B2,"ym")


Days : -

=DATEDIF(A2,B2,"md")

Count specif Character in one Cell
                           

For More Formulas See Hare