$$Excel-Macros$$ Formula

Dear Champs, please find the attachment of example sheet, any one help me the formula of tat related. , Shivaprasad K. +91-9866351016 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles

Re: $$Excel-Macros$$ Re: Card List view

Use grid control, to meet your requirement. Regards Eugene On Fri, Jan 11, 2013 at 4:35 PM, Prince wrote: > Hi Chaya, > > > Can you please shere ur workbook. One more thing where is the source of ur > data. > > regards > prince > > On Friday, January 11, 2013 4:03:27 PM UTC+5:30, chaya moni wr

Re: $$Excel-Macros$$ excel tips

Thank you Noorain for sharing the tips. On Thu, Jan 10, 2013 at 11:35 PM, NOORAIN ANSARI wrote: > Dear Putta, > > See attachments, Hope it will help to you. > > -- > With Regards, > Noorain Ansari > http:// > noorainansari.com > htt

Re: $$Excel-Macros$$

Hi try these videos http://www.youtube.com/watch?v=CHk7a8FM9TI http://www.youtube.com/watch?v=vhufngPejDk http://www.youtube.com/watch?v=GZX2iXfqALs Regards Ashish On Fri, Jan 11, 2013 at 1:27 PM, NOORAIN ANSARI wrote: > Hi Ruchi, > > See attachment, Hope it will useful for you. > > > -- > With

Re: $$Excel-Macros$$ Sumproduct Formula Required

edit the formula in cells D163 and below and add =IFERROR(AX8/V8,0) . add If error in all to avoid value errors Or try this =SUM(IF(ISNUMBER($C$163:$C$182+$D$163:$D$182),$C$163:$C$182*$D$163:$D$182,0))/C183 with Ctrl+shift+ Enter or Visit this link http://www.mrexcel.com/forum/excel-questions/2

Re: $$Excel-Macros$$ Conditional Concatenate

write UDF then On Fri, Jan 11, 2013 at 5:15 PM, Satendra kumar wrote: > many many thanks sir, > > but any other way with out helping column. > > > thankx > satendra > > > On Fri, Jan 11, 2013 at 5:06 PM, ashish koul wrote: > >> try the attachment see if it helps >> >> >> On Fri, Jan 11, 2013 at

Re: $$Excel-Macros$$ Conditional Concatenate

many many thanks sir, but any other way with out helping column. thankx satendra On Fri, Jan 11, 2013 at 5:06 PM, ashish koul wrote: > try the attachment see if it helps > > > On Fri, Jan 11, 2013 at 3:50 PM, Satendra kumar > wrote: > >> Hi All, >> >> any solution please >> >> thank

Re: $$Excel-Macros$$ Conditional Concatenate

try the attachment see if it helps On Fri, Jan 11, 2013 at 3:50 PM, Satendra kumar wrote: > Hi All, > > any solution please > > thankx > satendra > > > On Fri, Jan 11, 2013 at 1:44 PM, Satendra kumar > wrote: > >> Hi Dear, >> >> I'm not understand with this solution & not fulfill my req

Re: $$Excel-Macros$$ Lookup

Try this http://www.youtube.com/watch?v=aleaMFPk4-I http://support.microsoft.com/kb/324986 Regards Ashish On Fri, Jan 11, 2013 at 4:45 PM, Prince wrote: > http://www.techonthenet.com/excel/formulas/lookup.php > > http://www.techonthenet.com/excel/formulas/vlookup.php > > http://www.techonthen

Re: $$Excel-Macros$$ Re: Card List view

Hi sir, Thanks for the revert, Actually i didn't understands "source of ur data" means. Let me tell you all clear that i have many buisness card, travel car and any card collected in a form of hard copy, so instead of carrying all those card, i have put those data in a excel

Re: $$Excel-Macros$$ Lookup

http://www.techonthenet.com/excel/formulas/lookup.php http://www.techonthenet.com/excel/formulas/vlookup.php http://www.techonthenet.com/excel/formulas/hlookup.php See above link may be if these can help you. Regards Prince On Friday, January 11, 2013 4:22:06 PM UTC+5:30, Manjunath Narayana

$$Excel-Macros$$ Re: Card List view

Hi Chaya, Can you please shere ur workbook. One more thing where is the source of ur data. regards prince On Friday, January 11, 2013 4:03:27 PM UTC+5:30, chaya moni wrote: > > Dear Exceller, > > While goggling, i find some interesting fact in user form, Actually > I use to update card

RE: $$Excel-Macros$$ Lookup

Thank you prince….. I'm looking for Lookup function [cid:image001.png@01CDEFE9.B0D749D0] Thanks Manjunath From: Prince [mailto:prince141...@gmail.com] Sent: 11 January 2013 09:10 To: excel-macros@googlegroups.com Cc: Manjunath Narayanappa Subject: Re: $$Excel-Macros$$ Lookup Hi Manjnnath: t

Re: $$Excel-Macros$$ Conditional Concatenate

Hi All, any solution please thankx satendra On Fri, Jan 11, 2013 at 1:44 PM, Satendra kumar wrote: > Hi Dear, > > I'm not understand with this solution & not fulfill my requirement, > > please solve ! > > thankx > satendra > > > > On Fri, Jan 11, 2013 at 1:33 PM, rajan verma wrote: > >

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Thank you all. regards, Chaya On Fri, Jan 11, 2013 at 3:32 PM, अनिल नारायण गवली wrote: > Hi Chaya, > > Welcome to our Groups.fell free at any time to ask regarding about > excel. > > > Warm Reagrds, > Gawli Anil > > On Fri, Jan 11, 2013 at 3:08 PM, Prince wrote: > >> Hi Chaya, >> >> Welco

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Hi Chaya, Welcome to our Groups.fell free at any time to ask regarding about excel. Warm Reagrds, Gawli Anil On Fri, Jan 11, 2013 at 3:08 PM, Prince wrote: > Hi Chaya, > > Welcome in the group :) > > > Regards > Prince > > > On Friday, January 11, 2013 3:01:45 PM UTC+5:30, chaya moni wrot

$$Excel-Macros$$ Need formula based on 3 condition

Hello All, Please see attached excel, I'm confused how can I set IF statement based on varying 3 condition for one cell. Please review & advice. With Regards, *Suyog* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate th

$$Excel-Macros$$ Re: Introduce Yourself !!

Hi Chaya, Welcome in the group :) Regards Prince On Friday, January 11, 2013 3:01:45 PM UTC+5:30, chaya moni wrote: > > Dear Expert/Exceller, > > I am new to this group and very few knowledge about excel and > macros. Myself Miss Chaya, from delhi and completed my B.A English. Even

$$Excel-Macros$$ Re: Introduce Yourself !!

Dear Expert/Exceller, I am new to this group and very few knowledge about excel and macros. Myself Miss Chaya, from delhi and completed my B.A English. Even though i passed through this stream, i want to get full time to new era of learning Excel and macros, as i found to be very inno

Re: $$Excel-Macros$$ Lookup

Hi Manjnnath: this link describe lookup with good description please se it: http://msdn.microsoft.com/en-us/library/office/dd797422(v=office.12).aspx and from my side: Vlookup(lookup value,Lookup range,columnsNo, Match type) regards prince On Friday, January 11, 2013 2:21:49 PM UTC+5:30,

Re: $$Excel-Macros$$ Sumproduct Formula Required

If you Delete the rows mentioned.. then the formula you have mentioned works On Fri, Jan 11, 2013 at 2:09 PM, amar takale wrote: > No problem hide row delete,no matter. > > > On Fri, Jan 11, 2013 at 1:59 PM, Aindril De wrote: > >> Dear Amar, >> >> You are getting a #Value error.. since you have

$$Excel-Macros$$ Lookup

Dear All, How to use Lookup in Excel Worksheet. I need to know the formulas. Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-fo

Re: $$Excel-Macros$$ Sumproduct Formula Required

No problem hide row delete,no matter. On Fri, Jan 11, 2013 at 1:59 PM, Aindril De wrote: > Dear Amar, > > You are getting a #Value error.. since you have the following #Value > errors in your data. > > > ASTRAZENECA PHARMA INDIA LTD 36 #VALUE! PFIZER LIMITED 35 17.6 SUN > PHARMA ADVANCED RES

Re: $$Excel-Macros$$ Sumproduct Formula Required

Dear Amar, You are getting a #Value error.. since you have the following #Value errors in your data. ASTRAZENECA PHARMA INDIA LTD 36 #VALUE! PFIZER LIMITED 35 17.6 SUN PHARMA ADVANCED RESEARCH 33 #VALUE! On Fri, Jan 11, 2013 at 12:15 PM, amar takale wrote: > Hi All, > Pls suggest me Sumpro

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

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 -Original Message- From: amar takale Sender: excel-macros@googlegroups.com Date: Fri, 11 Jan 2013 13:35:10 To: Rep

Re: $$Excel-Macros$$ Conditional Concatenate

Hi Dear, I'm not understand with this solution & not fulfill my requirement, please solve ! thankx satendra On Fri, Jan 11, 2013 at 1:33 PM, rajan verma wrote: > Hi > Please find attachement > > Rajan > > On Fri, Jan 11, 2013 at 12:49 AM, Satendra kumar < > satendrakuma...@gmail.com> wrote:

Re: $$Excel-Macros$$ Conditional Concatenate

Hi Please find attachement Rajan On Fri, Jan 11, 2013 at 12:49 AM, Satendra kumar wrote: > Dear Rajan ji, > > Please find attachment & solve , > > thankx > satendra > > > On Fri, Jan 11, 2013 at 1:13 PM, rajan verma wrote: > >> can be done with using concatenate function >> =A1&","&B1&","&C1&","