$$Excel-Macros$$ Calculating Euclidean distance in 2 dimension & 3 dimension

​​Can somebody help me calculating euclidean distance for the attached sample file. Column 2, 3 & 4 contains X, Y &Z information of samples for which the euclidean distance is required to be calculated. The formula for the Euclidean distance in 3d & 2d are mentioned below. I am finding difficu

$$Excel-Macros$$ Re: Selective copy of non bank cell

; (with out macro) >> >> >> >> >> >> *Regards* >> *Naveen Kumar M N* >> * * >> Email :naveenkumarmn...@yahoo.com >> *Best Wishes-Karunaada Kuvara* >> >> --- On *Sun, 2/1/09, Debasish Sahu * wrote: >> >> From: Debasish

$$Excel-Macros$$ Selective copy of non bank cell

HiI hv a xl sheet whre i want to copy one of the column which contains both blank & non blank cells). but I want copying only non blank cells(cells having data) from that column. Could somebody help me in writing a macro for this. Regards Debasish Sahu Assistant Manager - Geology ACC Ltd. T

$$Excel-Macros$$ Re: macro that will combine workbooks

Thanks On Wed, Jan 21, 2009 at 9:45 PM, Tom Jeffries wrote: > Take a look at the attached macro. It may do what you want. > Tom > > On Tue, Jan 20, 2009 at 12:49 PM, Debasish Sahu wrote: > >> hi >> I have several work books having contact details in a folder (with s

$$Excel-Macros$$ macro that will combine workbooks

hi I have several work books having contact details in a folder (with same headers). Now I want to merge all files in to one sheet. Could somebody please provide a macro for this. Thnks in Advance Regards Debasish --~--~-~--~~~---~--~~ Visit the blog to download Ex

$$Excel-Macros$$ macro that will combine workbooks

Hi I have several work books(excel files) having contact details in a folder (with same headers). Now I want to merge all files in to one sheet. Could somebody please provide a macro for this. Thanks in Advance Regards Debasish -- debasish sahu IIT Bombay