returing multiple cell on the base of minium value

dheeraj27

New Member
Joined
Mar 1, 2013
Messages
49
hi guys i have the sheet which have the table which look like

Person task done

A 5

B 4

C 1

D 1



now i want is there is any way to find minum value in task done colium and return the person name and like in this exapmle, 2 person have done have done minium work.. it tell me both those name
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Hi,

Does this work for you?...

Sample data....

Excel Workbook
ABCDEF
1NameTask Done*1Name*
2Bill5**Joe*
3Ben4**Rob*
4Joe1****
5Bob3****
6Jim2****
7Rob1****
8******
Sheet12


The formula in E2 needs to be entered using ctrl shift enter NOT just enter, you can then copy it down.

I hope that helps.

Ak
 
Upvote 0
Hi,

Im pleased it worked for you and thanks for the feedback. :biggrin:

I'm sorry, but I don't write or understand VBA, so I cannot help you with that.
You may want to post a new question with a title like, "VBA for message box value to be used in formula".
You may also want to refer to this post so that it is easier for you to explain what you require.

Good luck.

Ak
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,040
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top