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 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
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
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