Re: $$Excel-Macros$$ please help with array formula

2012-08-30 Thread NOORAIN ANSARI 
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 PM, amar takale  wrote:

> 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 alam <786maks...@gmail.com>wrote:
>
>> 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) 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, CHERRYL A 40 WILSON, BARBARA P 40 
 BLECKLEY,
 SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH,
 WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L
 35 SENSENBRENNER, SUSAN   35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J
 35 BENNING, VIRGINIA   40 ROLLINS, ANNETTE   40 CRATTY, CYNTHIA   40 RYAN,
 PHYLLIS   100 SPENCER, SUSAN   100 VANALSTYNE, DAVID E 75 LINN, DANIEL
 B 100 BENSMAN, SUE B 100 ROMEO, CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN,
 CAROL   100 RYMSKI, JOSEPH G 100



 *Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores*


 --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ 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 get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.



>>>
>>>
>>>
>>> --
>>> With Regards,
>>> Noorain Ansari
>>> http:// 
>>> noorainansari.com
>>> http:// 
>>> excelvbaclinic.com
>>>
>>>
>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ 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 get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate th

Re: $$Excel-Macros$$ please help with array formula

2012-08-30 Thread amar takale 
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 alam <786maks...@gmail.com> wrote:

> 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) 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, CHERRYL A 40 WILSON, BARBARA P 40 
>>> BLECKLEY,
>>> SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH,
>>> WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L
>>> 35 SENSENBRENNER, SUSAN   35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J 35 
>>> BENNING,
>>> VIRGINIA   40 ROLLINS, ANNETTE   40 CRATTY, CYNTHIA   40 RYAN, PHYLLIS
>>> 100 SPENCER, SUSAN   100 VANALSTYNE, DAVID E 75 LINN, DANIEL B 100 BENSMAN,
>>> SUE B 100 ROMEO, CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN, CAROL   100 
>>> RYMSKI,
>>> JOSEPH G 100
>>>
>>>
>>>
>>> *Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores*
>>>
>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ 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 get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.com
>>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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 get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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 get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in

Re: $$Excel-Macros$$ please help with array formula

2012-08-28 Thread maksood alam 
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) 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, CHERRYL A 40 WILSON, BARBARA P 40 BLECKLEY,
>> SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH,
>> WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L 35 
>> SENSENBRENNER,
>> SUSAN   35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J 35 BENNING, VIRGINIA
>>40 ROLLINS, ANNETTE   40 CRATTY, CYNTHIA   40 RYAN, PHYLLIS   100 SPENCER,
>> SUSAN   100 VANALSTYNE, DAVID E 75 LINN, DANIEL B 100 BENSMAN, SUE B 100 
>> ROMEO,
>> CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN, CAROL   100 RYMSKI, JOSEPH G
>> 100
>>
>>
>>
>>*Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores*
>>
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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 get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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 get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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 get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send em

Re: $$Excel-Macros$$ please help with array formula

2012-08-28 Thread NOORAIN ANSARI 
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 candidate who has 40 marks in 1st sheet. can it done with array
> forumla. please help.
>
>
> *Name* *Marks CT-1*  SOMERSET, CHERRYL A 40 WILSON, BARBARA P 40 BLECKLEY,
> SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH,
> WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L 35 
> SENSENBRENNER,
> SUSAN   35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J 35 BENNING, VIRGINIA
> 40 ROLLINS, ANNETTE   40 CRATTY, CYNTHIA   40 RYAN, PHYLLIS   100 SPENCER,
> SUSAN   100 VANALSTYNE, DAVID E 75 LINN, DANIEL B 100 BENSMAN, SUE B 100 
> ROMEO,
> CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN, CAROL   100 RYMSKI, JOSEPH G 100
>
>
>
> *Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores*
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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 get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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 get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Maksood(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ please help with array formula

2012-08-28 Thread NOORAIN ANSARI 
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). 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, CHERRYL A 40 WILSON, BARBARA P 40 BLECKLEY,
> SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH,
> WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L 35 
> SENSENBRENNER,
> SUSAN   35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J 35 BENNING, VIRGINIA
> 40 ROLLINS, ANNETTE   40 CRATTY, CYNTHIA   40 RYAN, PHYLLIS   100 SPENCER,
> SUSAN   100 VANALSTYNE, DAVID E 75 LINN, DANIEL B 100 BENSMAN, SUE B 100 
> ROMEO,
> CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN, CAROL   100 RYMSKI, JOSEPH G 100
>
>
>
> *Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores*
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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 get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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 get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ please help with array formula

2012-08-28 Thread maksood alam 
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*(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, CHERRYL A 40 WILSON, BARBARA P 40 BLECKLEY,
>> SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH,
>> WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L 35 
>> SENSENBRENNER,
>> SUSAN   35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J 35 BENNING, VIRGINIA
>>40 ROLLINS, ANNETTE   40 CRATTY, CYNTHIA   40 RYAN, PHYLLIS   100 SPENCER,
>> SUSAN   100 VANALSTYNE, DAVID E 75 LINN, DANIEL B 100 BENSMAN, SUE B 100 
>> ROMEO,
>> CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN, CAROL   100 RYMSKI, JOSEPH G
>> 100
>>
>>
>>
>>*Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores*
>>
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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 get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
>
>
>  *Visit*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/*
>
> P Before printing, think about the environment.
>
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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 get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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 get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ please help with array formula

2012-08-28 Thread ashish koul 
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 candidate who has 40 marks in 1st sheet. can it done with array
> forumla. please help.
>
>
> *Name* *Marks CT-1*  SOMERSET, CHERRYL A 40 WILSON, BARBARA P 40 BLECKLEY,
> SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH,
> WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L 35 
> SENSENBRENNER,
> SUSAN   35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J 35 BENNING, VIRGINIA
> 40 ROLLINS, ANNETTE   40 CRATTY, CYNTHIA   40 RYAN, PHYLLIS   100 SPENCER,
> SUSAN   100 VANALSTYNE, DAVID E 75 LINN, DANIEL B 100 BENSMAN, SUE B 100 
> ROMEO,
> CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN, CAROL   100 RYMSKI, JOSEPH G 100
>
>
>
> *Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores*
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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 get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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 get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.