Dear Amar,
We are using No. 4 for row no., If you go through attachment, table start
from row no. 5, row no.4 is heading so, we deduct above all row Number
including header. so we are using 4 because we are deduction 4 row no.
Hope my explanation will help you.
On Thu, Aug 30, 2012 at 5:16 P
Hi Noorin
what is logic of last number 4 in formula if I change it nothing change in
output
={INDEX($B$5:$B$29,SMALL(IF($C$5:$C$29=$G$6,ROW($C$5:$C$29),""),ROW(B1))-4)}
I used excel 2003 so I changed formula like this Pl tell me logic of number
4 in last
On Tue, Aug 28, 2012 at 10:16 PM, maksood
Thanks Noorain bhai.. its solved my qurey..
On Tue, Aug 28, 2012 at 8:35 PM, NOORAIN ANSARI wrote:
> See attachment for more clarity
>
> On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com>wrote:
>
>> Hi experts,
>>
>> I have data in once sheet in two colums like *NAME*(colum A)
See attachment for more clarity
On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com> wrote:
> Hi experts,
>
> I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum
> B). In 2nd sheet i want a formula if i enter 20 its should show me the name
> of all the c
Dear Maksood,
Please try it..
=IFERROR(INDEX($B$5:$B$29,SMALL(IF($C$5:$C$29=$G$6,ROW($C$5:$C$29),""),ROW(B1))-4),"--")
On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com> wrote:
> Hi experts,
>
> I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum
> B
cannot send any attchment due to system restrictions.
On Tue, Aug 28, 2012 at 8:20 PM, ashish koul wrote:
> can you send us the attachment
>
>
> On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com>wrote:
>
>> Hi experts,
>>
>> I have data in once sheet in two colums like *NAME*(c
can you send us the attachment
On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com> wrote:
> Hi experts,
>
> I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum
> B). In 2nd sheet i want a formula if i enter 20 its should show me the name
> of all the ca
Hi experts,
I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum
B). In 2nd sheet i want a formula if i enter 20 its should show me the name
of all the candidate who has 40 marks in 1st sheet. can it done with array
forumla. please help.
*Name* *Marks CT-1* SOMERSET
