=INDEX(A2:A15& " " &B2:B15,MATCH(MAX(B2:B15),B2:B15,0),1) with CSE

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Shaik Waheed
Sent: 25 June 2012 12:32
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ need help on maximum value and thier name

 

PFA

On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल <tosune...@gmail.com> wrote:

Dear all,

 

It has always been previlege to query on this group whenever needed and thanks 
from heart.

 

I need one help regarding finding out maximum number and their name in one cell 
?

 

Have a wonderful day !!

 

Thank you!!

Sunita

 

P.S: in case if file not attached(having probs)

 


name

amount

                                

 Bijay Barma 

11640

                                

 Binod Barma 

10983

                                

 Manoj Barma 

10983

                                

 Jitendra Barma 

16215

                                

 Birbal Sunar 

15207

                                

 Dinesh Rokaya 

28742

                                

Nisha Basnet

10041

                                

Daman Raj Aidi 

11356

                                

Nara Rawat

32130

                                

Surya Buda

10001

                                

Binita Bam

9699

                                

RajKumar Rawat

29512

                                

Shiva Thapa

28393

                                

Rajesh Singh

10365

                                
                                                
                                                

Can we find maximum number and their name in one cell or different?

        

Can we find 2nd maximum number and their name/

                        

Likewise from greates to least number?

                        
                                                
                                                

 

 

-- 
-- 
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 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com 
<mailto:excel-macros%2bunsubscr...@googlegroups.com> 
 
 

 

-- 
-- 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 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. NOTE : Don't ever post personal or confidential data in a 
workbook. Forum owners and members are not responsible for any loss. 
------------------------------------------------------------------------------------------------------
 To post to this group, send email to excel-macros@googlegroups.com To 
unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com 

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com


Reply via email to