RE: $$Excel-Macros$$ Formula Quiz

2012-11-25 Thread Rajan_Verma
@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of >>Excel Beginner<< Sent: 25 November 2012 12:23 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula Quiz Hi Rajan sir, Please find the attachment. I had been given to anot

RE: $$Excel-Macros$$ Formula Quiz

2012-11-25 Thread Rajan_Verma
Excellent J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of >>Excel Beginner<< Sent: 25 November 2012 12:23 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula Quiz

Re: $$Excel-Macros$$ Formula Quiz

2012-11-24 Thread Umar Abeer
t but it can be more better.* >> >> * * >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> * * >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@

Re: $$Excel-Macros$$ Formula Quiz

2012-11-24 Thread >>Excel Beginner<
;>Excel Beginner<< > *Sent:* 23 November 2012 11:54 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Formula Quiz > > ** ** > > Hi Rajan Sir, > > ** ** > > please find the attachment. > > ** ** &g

RE: $$Excel-Macros$$ Formula Quiz

2012-11-23 Thread Rajan_Verma
lt; Sent: 23 November 2012 11:54 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula Quiz Hi Rajan Sir, please find the attachment. Regards, Excel Beginner On Fri, Nov 23, 2012 at 10:51 PM, Rajan_Verma wrote: Hi Group, here

Re: $$Excel-Macros$$ Formula Quiz

2012-11-23 Thread vijayajith VA
Hi Rajan, I have question here.. Just wanted to know..what is the use of ROW(A1) A2 a3..etc etcc... HERE.. =IFERROR(IFERROR(INDEX($C$2:$J$2,0,ROW(A1)),INDEX($C$3:$J$3,0,ROW(A1)-COUNTA($C$2:$J$2))),INDEX($C$4:$J$4,0,ROW(A1)-COUNTA($C$2:$J$3))) On Fri, Nov 23, 2012 at 11:53 PM, >>Excel Begin

Re: $$Excel-Macros$$ Formula Quiz

2012-11-23 Thread >>Excel Beginner<
Hi Rajan Sir, please find the attachment. *Regards,* * * *Excel Beginner* * * On Fri, Nov 23, 2012 at 10:51 PM, Rajan_Verma wrote: > * * > > *Hi Group,* > > * > here is a formula Practice , hope you will enjoy this,* > > * * > > *Suppose you have data like this below table, y

$$Excel-Macros$$ Formula Quiz

2012-11-23 Thread Rajan_Verma
Hi Group, here is a formula Practice , hope you will enjoy this, Suppose you have data like this below table, you need create a formula to make it in a series like 2nd table 375 814 582 509 349 395 642 302 180 884 922 941 474 170 584 370 665 329 245 981 547 650