$$Excel-Macros$$ Index Formula Help

2012-07-01 Thread SUDHIR VERMA
Dear All, Please look at attachment and help me. thanking u Regards Sudhir -- FORUM RULES (986+ 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 ge

Re: $$Excel-Macros$$ Index Formula Help

2012-07-01 Thread Manoj Kumar
Dear Sudhir Please find the attachment... Regard Manoj On Mon, Jul 2, 2012 at 10:58 AM, SUDHIR VERMA wrote: > Dear All, > > Please look at attachment and help me. > > > thanking u > > Regards > > > Sudhir > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, ac

Re: $$Excel-Macros$$ Index Formula Help

2012-07-01 Thread NOORAIN ANSARI
Dear Sudhir, Please use it for unique Name in drop down List.. *=IFERROR(INDEX($A$10:$A$43,MATCH(0,COUNTIF($Q$1:Q1,$A$10:$A$43),0)),"")* for specific record of Party Name * =IFERROR(INDEX($C$10:$C$43,SMALL(IF($A$10:$A$43=$I$6,ROW($C$10:$C$43),""),ROW(B1))-9),"") * with ctrl+shfit+enter see at

RE: $$Excel-Macros$$ Index Formula Help

2012-07-02 Thread Rajan_Verma
See the attached sheet. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SUDHIR VERMA Sent: 02 July 2012 10:59 To: excel-macros Subject: $$Excel-Macros$$ Index Formula Help Dear All, Please