Recent content by YD

use text to colum & delimit it by using "*" :) cheers Thanks YD

good morning a7 = 7/28/1981 b7= 7/30/1984 =DATEDIF(A7,B7,"y")&" years "&DATEDIF(A7,B7,"ym")&" months & "&DATEDIF(A7,B7,"md")&" days" hope this solves your problem :) cheers thanks yd

Awesome :)

this site rocks ! happy learning :)cheers YD

Q. Why did Microsoft develop Access? A. To make Excel seem faster

If Excel Were a Car... It would crash two or three times per day for no apparent reason. The driver is often hurt, but the car itself receives no permanent damage. You'd just accept this fact, restart the car, and begin your trip again. Occasionally, your car would fail to restart after a...

http://chandoo.org/forums/topic/posting-a-sample-workbook

Dear Please don't post Excel questions here. They will be deleted. Post Excel related questions by clicking here ======================================= File sharing websites Please don't post a picture of your worksheet. http://www.dropbox.com/ http://rapidshare.com/...

http://speedy.sh/QAJh5/non-circular-Reference-Formula.xls please check i have created one format Enable macro after opening the file Enjoy YD

good afternoon if there is no relation between m income and a income anual income on C2 monthly income on B2 just recard a macro click on record macro in D2 =C2+B2 and copy D2 and paste it on C2, stop the recording you will get the updated figure add a button and assign the macro to it i am...

Awesome :)

though i was not able to highlight a specific letter but an automated line "the letter number 6 that is N is missing" can appear :) A1 contains "JAGANNATH" and B1 contains "JAGANATH" B2 formula =LEFT($A$1,1)=LEFT($B$1,1) B3 Formula =IF(B2=$E$1,(LEFT($A$1,2)=LEFT($B$1,2))," ") B4...

dear ajinkya What is the out put after using the formula specified by me

please ignore

Ajinkya formula for c14 should be =C13+-0.8 & c15 should be =C14+0.01 Cheers YD