
Yogesh Gupta
blogs from Gurgaon

Yogesh Gupta's latest posts on IndiVine
Excel Macros : Find Last Row with Data (3 votes)
Find and remove duplicates in Excel (3 votes)
Numbers to Words in Excel (3 votes)

I am sharing Excel Addin for converting Numbers to Words. I keep getting mails / comments where people are not able to install the VBA code shared in my earlier post Excel Functions : Convert Numbers to Words. This Addin will make it easier to use. This Addin can be installed on any computer having...
Posted on 13 February 2012 | 10:51 pm
Read postThe Code I am sharing with you today is capable of sending active sheet of your workbook through outlook mail to email ID specified by you. You will not get any warning messages and the email will be sent using outlook profile available on your machine.This code saves active sheet to temp file and t...
Posted on 24 July 2010 | 11:24 pm
Read postToday I am sharing with a long formula for calculating age based in Date of Birth as input. =YEAR(DATE(YEAR(TODAY())-YEAR(A1),MONTH(TODAY())-MONTH(A1)+1,DAY(TODAY())-DAY(A1)+1))-1900&" Years "&IF(MONTH(DATE(YEAR(TODAY())-YEAR(A1),MONTH(TODAY())-MONTH(A1)+1,DAY(TODAY())-DAY(A1)+1))-1=0,"",MONTH(DATE(...
Posted on 31 May 2010 | 9:16 pm
Read post