Re: $$Excel-Macros$$ ifError not woking with excel 2003 version

Try by using as below =if(iserror(formula),on error,formula) Thanks and Regards, Somnath C Pardeshi Sent from BlackBerry® on Airtel -Original Message- From: chandra sekaran duraichan...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 27 Feb 2012 10:24:13 To:

Re: $$Excel-Macros$$ alert for duplicate name or number while entering the data in the sheet

Hi, Try following steps in excel Range a2 1 go to data then data validation 2 settings 3 allow custom 4 formula =countif($a$1:a1,a2)=o 5 copy this cell and paste down with validation This will not allow you to reenter name if you use formula =countif($a$1:a1,a2)0 in conditional formatting

Re: $$Excel-Macros$$ Quick Date Count Question

Hi Try this =if(and(a1b1,a1c1),a1,0) Thanks and Regards, Somnath C Pardeshi Sent from my BlackBerry® Smartphone on Loop Mobile. -Original Message- From: RockyFontane vtorral...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 17 Oct 2011 08:08:40 To: MS EXCEL AND VBA

Re: $$Excel-Macros$$ Urgent Help required

Hi Just divide this by 100 Try this formula =A1/10^6 Thanks and Regards, Somnath C Pardeshi Sent from my BlackBerry® Smartphone on Loop Mobile. -Original Message- From: Prathap prathap@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 13 Oct 2011 20:22:52 To:

Re: $$Excel-Macros$$ Urgent Help required

Hi In a cell type 100 copy it( ctrl + C) Select all cells then paste special ( Alt + E + S + V + I ) value with divide operation This will convert all the numbers in million format. Thanks and Regards, Somnath C Pardeshi +91 966 419 4782 Sent from my BlackBerry® Smartphone on Loop Mobile.

Re: $$Excel-Macros$$ Shortcut key for Border

Hi Try this In a excel file select any area Then start recording macro ( alt + t + m + r ) save macro in personal file Insure that you will not change selection before stop the macro recording Assign border to selection as per your req. Stop recording macro Press alt + f8 Select recorded macro

Re: $$Excel-Macros$$ Prefix 0 before the number- Help

Hi Try this =text(A2,000) This will convert in text with format as per your req. If you want same value in number then change the format with to custom 000 Thanks and regards, Somnath C Pardeshi +91 829 111 9311 Sent from my BlackBerry® Smartphone on Loop Mobile. -Original