Thanks saurabh for attention of error but there is not time problem, there
are no error occurred and also result not display in the cell, if you find
the data without error, please send me a attachment sheet with successful
working of formula.
Thanks & regards
Ashish Bhalara
On Sat, Mar 10, 2012
Hi,
It's an array formula. Confirmed with CTRL + SHIFT + ENTER
Kris
On Saturday, 10 March 2012 17:34:19 UTC+5:30, Ashish_Bhalara wrote:
>
>
> Dear sir,
>
> I write your condition but there are no result display in the cell, I
> don't know whats happen with this formula, please see attached file
No need to use IFERROR twice. BTW, Sam's formula works fine for me.
You could use this as well.
=IFERROR(INDEX(Sheet2!C$3:C$15,SMALL(IF(INT(Sheet2!$A$3:$A$15)=$B$32,ROW(Sheet2!$A$3:$A$15)-ROW(Sheet2!$A$3)+1),ROWS(B$34:B34))),"")
Kris
--
FORUM RULES (986+ members already BANNED for violation)
-
> From: Ashish Bhalara
> Date: Tue, Mar 6, 2012 at 9:44 AM
> Subject: $$Excel-Macros$$ Error in condition of particular data receive
> from another sheet
> To: excel-macros@googlegroups.com
>
>
> Dear expert,
>
> There are problem in my condition in attached file
