4th Year at CSC

Me in Indian Linux Users Group Chennai :-)

http://www.ilugc.in/content/ilugc-meet-minutes-may-2011


Here are the snaps

http://www.facebook.com/media/set/?set=a.223766014302108.66861.133359730009404&l=0d0edfa4d4

To arrange IP addresses

Type this in cell B1 then arrange these values by expanding and sorting, Wola your IP addresses are sorted.   =((VALUE(LEFT(A1, FIND(".", A1)-1)))*256^3)+((VALUE(MID(A1, FIND(".", A1)+1, FIND(".", A1, FIND(".", A1)+1)-FIND(".", A1)-1)))*256^2)+((VALUE(MID(A1, FIND(".", A1, FIND(".", A1)+1)+1, FIND(".", A1, FIND(".", A1, FIND(".", A1)+1)+1)-FIND(".", A1, FIND(".", A1)+1)-1)))*256)+(VALUE(RIGHT(A1, LEN(A1)-FIND(".", A1, FIND(".", A1, FIND(".", A1)+1)+1))))