Re: $$Excel-Macros$$ please correct the formula

Hi, Thanks its working, but if we have to match the index On Sun, Jan 13, 2013 at 7:02 PM, >>Excel Beginner<< wrote: > Hi, > >Make use of this formula > > "=ABS(INDIRECT("'sheet1'!"&"C"&MATCH(C2,Sheet1!$B$1:$B$5,0))-INDIRECT("'sheet1'!"&"C"&MATCH(B2,Sheet1!$B$1:$B$5,0)))" > or check attachm

$$Excel-Macros$$ Re: formula required

Hi Prashant, I hope it may help you: =SUM(($D$2:D5=D2)*1*(G2:M2)) with CSE in Cell "O2" Regards Prince On Monday, January 14, 2013 12:19:32 PM UTC+5:30, ppawle.excel wrote: > > Dear Team, > > Need a formula to look up a filed & give sum of figure , sample file > attached > > Regards, > > Pras

Re: $$Excel-Macros$$ please correct the formula

why we have to press CTRL+SHIFT+ENTER. Its taking a lot of time to process the same. On Sun, Jan 13, 2013 at 2:46 PM, ashish koul wrote: > try attached workbook > > > On Sun, Jan 13, 2013 at 2:31 PM, Smitha S R wrote: > >> HI, >> Tried but returns #VALUE >> >> >> On Sun, Jan 13, 2013 at 2:26 P

Re: $$Excel-Macros$$ formula required

Dear Prashant, Please use this.. SUMPRODUCT(($D$2:$D$5=A7)*($G$2:$M$5)) Regard Manoj On Mon, Jan 14, 2013 at 12:19 PM, Prashant Pawle wrote: > Dear Team, > > Need a formula to look up a filed & give sum of figure , sample file > attached > > Regards, > > Prashant > > -- > Join official Faceboo

$$Excel-Macros$$ formula required

Dear Team, Need a formula to look up a filed & give sum of figure , sample file attached Regards, Prashant -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

Re: $$Excel-Macros$$ Hey how to recover source data from pivot table .

If you have pivot table existed there then double click on the grand total value. You can extract the pivot cache data from there. Regards, Anoop On Mon, Jan 14, 2013 at 12:05 PM, अनिल नारायण गवली wrote: > Dear All, > > actually my bro has deleted the source data. befor he has deleted i had > m

$$Excel-Macros$$ Hey how to recover source data from pivot table .

Dear All, actually my bro has deleted the source data. befor he has deleted i had made a pivot table after that he deleted the souce data. Now i want that data back . is there any solutions. -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Join

Re: $$Excel-Macros$$ Re: NSEINDIA Stock Price change Automatically

Pl help me on this topic On Mon, Jan 14, 2013 at 11:54 AM, amar takale wrote: > > > On Fri, Jan 11, 2013 at 1:44 PM, wrote: > >> ** >> Dear Amar >> >> Option for the same is available in odin, >> >> Kindly take help of it,it will be useful for live and closing both rates >> Sent from my BlackBe

Re: $$Excel-Macros$$ Re: NSEINDIA Stock Price change Automatically

On Fri, Jan 11, 2013 at 1:44 PM, wrote: > ** > Dear Amar > > Option for the same is available in odin, > > Kindly take help of it,it will be useful for live and closing both rates > Sent from my BlackBerry® smartphone from !DEA > -- > *From: * amar takale > *Sender: *

Re: $$Excel-Macros$$ Re: Prince Kumar - Most Helpful Member December'12

Hi Smitha, Here is the some stuffs that i refer some times. These are some standard books that help you a lot . Excel 200 7 Power Programming with VBA, by John Walkenbach VBA and Macros for Microsoft Excel , by Bill Jelen "Mr.Excel" and

Re: $$Excel-Macros$$ Re: Excel Query

Hi Vikram Is it only the particular value 125 that gets changed? For example if you put 124, does that become 224? Does this problem arise on every workbook on the system? Does it arise in other program's or only in excel? On Monday, 14 January 2013, venus wrote: > Hi, > > I am not getting t

Re: $$Excel-Macros$$ Re: Excel Query

Hi, I am not getting this error with any particular error but this is happening on particular system. Regards, Vikram On Sun, Jan 13, 2013 at 6:20 PM, Prince wrote: > Hi Vikram, > > Please Share your workbook. > > Regards > Prince > > On Saturday, January 12, 2013 9:30:45 PM UTC+5:30, vic kum

$$Excel-Macros$$ Re: Interview Questions with Answers (Excel+VBA+Access+SQL Server)

Dear Noorain, Thank you very much for the interview questions. Regards, Saravanan R. On Thursday, 10 May 2012 16:49:25 UTC+5:30, NOORAIN ANSARI wrote: > > Dear Group, > > Please find attached Interview questions and answers for MS Excel+VBA+MS > Access+SQL Server. > > If any one have th

RE: $$Excel-Macros$$ Re: Keen to more Learn

Hi Prince, Thank you so much. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prince Sent: 07 January 2013 16:18 To: excel-macros@googlegroups.com Cc: Manjunath Narayanappa Subject: Re: $$Excel-Macros$$ Re: Keen to more Learn Hi Manjunath, Here is t

$$Excel-Macros$$ Re: Want to copy 2nd sheet of all workbook in a particular folder

On Thursday, January 10, 2013 4:12:10 PM UTC+5, sandeep chhajer wrote: > > Dear excel guru, > I want to copy only the 2nd sheet of the all workbooks from a particular > folder. Please accordingly rectify the below mentioned code which I also > got this forum. > > Option Explicit > > > > '32

Re: $$Excel-Macros$$ please correct the formula

Hi, Make use of this formula "=ABS(INDIRECT("'sheet1'!"&"C"&MATCH(C2,Sheet1!$B$1:$B$5,0))-INDIRECT("'sheet1'!"&"C"&MATCH(B2,Sheet1!$B$1:$B$5,0)))" or check attachment. On Sun, Jan 13, 2013 at 2:21 PM, Smitha S R wrote: > Hi, > > PFA the statement and correct the formula I have used. > Its s

$$Excel-Macros$$ Re: Macro to send data from one master sheet to multiple sheets

Hi Vignesh, Please find attached regards prince On Saturday, January 12, 2013 11:24:41 PM UTC+5:30, Vignesh S R wrote: > > hi All, > > Need your help guys. > > Description > Master excel sheet contains many records with different categories, we > have multiple excel sheet for each categories. N

$$Excel-Macros$$ Re: Excel Query

Hi Vikram, Please Share your workbook. Regards Prince On Saturday, January 12, 2013 9:30:45 PM UTC+5:30, vic kumar wrote: > > Hi, > > I need some information regarding excel where in one of the > instance whenever we input 125 and press enter we are getting 225 as result. > > We have tried a lo

Re: $$Excel-Macros$$ merge data

Hi Smitha, 1:First paste this macro into any module of any workbook let say workbook1 2:Now run this, now this sub will check if any worksheet exists in workbook except output sheet (manually given name to any of the sheet of workbook 1) 3:If yes any worksheet exist it will copy that and paste

Re: $$Excel-Macros$$ please correct the formula

try attached workbook On Sun, Jan 13, 2013 at 2:31 PM, Smitha S R wrote: > HI, > Tried but returns #VALUE > > > On Sun, Jan 13, 2013 at 2:26 PM, ashish koul wrote: > >> Try this >> >> >> >> =INDEX(Sheet1!C:C,MATCH(Sheet2!A2&Sheet2!C2,Sheet1!$A$1:$A$5&Sheet1!$B$1:$B$5,0))-INDEX(Sheet1!C:C,MATCH(

Re: $$Excel-Macros$$ Re: Prince Kumar - Most Helpful Member December'12

try excel power programming by John Walkenbach book On Sun, Jan 13, 2013 at 2:38 PM, Smitha S R wrote: > Congrats Prince. > > I too want to learn excel in depth, advance, want to become excel expert. > I always search net for excel materials, but cannot make a step by step > study. > > Please h

Re: $$Excel-Macros$$ Re: I am suspecting a Circular Reference *

Thanks boss You are pecfectly right I got ride of the zeros and its workin On Jan 12, 2013 12:09 PM, "i.prakash1984" wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (i.prakash1...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Re: Prince Kumar - Most Helpful Member December'12

Congrats Prince. I too want to learn excel in depth, advance, want to become excel expert. I always search net for excel materials, but cannot make a step by step study. Please help me and advice me to complete my wish, also suggest any materials so that I can buy from the shop, which is useful a

Re: $$Excel-Macros$$ please correct the formula

HI, Tried but returns #VALUE On Sun, Jan 13, 2013 at 2:26 PM, ashish koul wrote: > Try this > > > > =INDEX(Sheet1!C:C,MATCH(Sheet2!A2&Sheet2!C2,Sheet1!$A$1:$A$5&Sheet1!$B$1:$B$5,0))-INDEX(Sheet1!C:C,MATCH(Sheet2!A2&Sheet2!B2,Sheet1!$A$1:$A$5&Sheet1!$B$1:$B$5,0)) > > > press CTRL+SHIFT+ENTER > >

Re: $$Excel-Macros$$ please correct the formula

Try this =INDEX(Sheet1!C:C,MATCH(Sheet2!A2&Sheet2!C2,Sheet1!$A$1:$A$5&Sheet1!$B$1:$B$5,0))-INDEX(Sheet1!C:C,MATCH(Sheet2!A2&Sheet2!B2,Sheet1!$A$1:$A$5&Sheet1!$B$1:$B$5,0)) press CTRL+SHIFT+ENTER On Sun, Jan 13, 2013 at 2:21 PM, Smitha S R wrote: > Hi, > > PFA the statement and correct the f

Re: $$Excel-Macros$$ merge data

Hi, Can you explain the macro used On Fri, Jan 11, 2013 at 1:19 PM, Prince wrote: > hi Smitha, > > > please get this > > Public Sub CombineData() > > Public Sub CombineData() > > Dim wks As Worksheet > > For Each wks In ThisWorkbook.Worksheets > If wks.Name = "Index" Or wks.

$$Excel-Macros$$ please correct the formula

Hi, PFA the statement and correct the formula I have used. Its showing sum errors -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

Re: $$Excel-Macros$$ Probability

thanks a lot On Sat, Jan 12, 2013 at 8:55 PM, >>Excel Beginner<< wrote: > Hi, > > Please find the attachment. > > > > > -- > *Regards,* > * > * > *Excel Beginner* > On Thu, Jan 10, 2013 at 2:52 PM, Smitha S R wrote: > >> Hi, >> >> PFA the file which shows distance in KMS between different