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
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
Dear Sudhir
Please find the attachment...
Regard
Manoj
On Mon, Jul 2, 2012 at 10:58 AM, SUDHIR VERMA newinex...@gmail.com wrote:
Dear All,
Please look at attachment and help me.
thanking u
Regards
Sudhir
--
FORUM RULES (986+ members already BANNED for violation)
1) Use
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
