$$Excel-Macros$$ Re: calculating euclidean distance

Can anybody help providing me macro for this. Regards Debasish On Friday, August 19, 2016 at 9:44:31 AM UTC+5:30, debasish wrote: > > forget to mention that the script calculate both 2d (HD button)& 3d (SD > button)euclidean distance. For 3d euclidean distance the formula would b

$$Excel-Macros$$ Re: calculating euclidean distance

forget to mention that the script calculate both 2d (HD button)& 3d (SD button)euclidean distance. For 3d euclidean distance the formula would be sqrt[(X1-X2)^2+(Y1-Y2)^2+(Z1-Z2)...(Xn-Zn)^2]. Regards, Debasish On Friday, August 19, 2016 at 9:25:16 AM UTC+5:30, debasish wrote: > >

$$Excel-Macros$$ calculating euclidean distance

Hello, I have attached a excel sheet which contains which got a vb script to euclidean distance. However its not giving the actual result as per the formula(pls refer to sheet 2) I want some help to resolve this. Enclosure: A graph showing 4 data points,Excel sheet (1st sheet got the script to

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

calculation has to be done. Any macro which can do these iteration will be very much helpful. Thanks & regards, Debasish On Tuesday, 24 September 2013 12:44:28 UTC+5:30, ravinder negi wrote: > > I don’t know more about this. U can use like below; > > > > =SQRT((x2 – x1)^2 + (y2

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

I am finding difficult to calculate as i need to calculate it between each sample with all other samples. Please help d = √((x2 – x1)2 + (y2 – y1)2 + (z2 – z1)2) d = √((x2 – x1)2 + (y2 – y1)2) Thanks & regards, Debasish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’

Re: $$Excel-Macros$$ update link automatically in excel sheet

have to browse every time to the file after replacing link names (e.g Fy 11 to Fy12) Hope you got my problem Thanks & regards Debasish On Dec 3, 3:43 pm, Sam Mathai Chacko wrote: > The edit links feature in Excel is specifically given for this. YOu just > need to browse for the new fi

$$Excel-Macros$$ update link automatically in excel sheet

regards, Debasish -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a qu

Re: $$Excel-Macros$$ Re: VBA code for importing data from excel to Access table

thanks for the reply... its possible to import data from excel to Access. Debasish On Jul 20, 7:01 pm, VILAS CHAVAN wrote: > Hi > is it posible, to export data excel to access using vba code > > vilas chavan > > On 7/19/10, Kishan Reddy, K wrote: > > > Hello, >

$$Excel-Macros$$ Re: VBA code for importing data from excel to Access table

I am a novice in macro... could you please elaborate more on this.. Thanks & regards, Debasish On Jul 18, 8:40 pm, Kishan K wrote: > Hi, > > In access, try to create a MACRO with action TRANSFERSPREADSHEET. > > Regards, > > Kishan Reddy K. > kishanreddy.kethire...@gm

$$Excel-Macros$$ VBA code for importing data from excel to Access table

Hello Everybody, I am working on a access database where in I have to import data from excel data on daily basis. I need a code so that i can update my access table with my excel file daily. Please help regards, Debasish

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

Many Thanks Debasish On Mon, Feb 2, 2009 at 5:11 PM, Tariq Kamal wrote: > Macro for the same > > 'to autofilter based on non blank cells in column A > Range("A:A").Select > Selection.AutoFilter > Selection.AutoFilter Field:=1, Criteria1:="&l

$$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

$$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