Home |
Search |
Today's Posts |
#1
|
|||
|
|||
countif max value help!!!
hi all, well i am having small problem, i am having a sheet with Column A as name of the people and Column B as no of calls taken, what i want to do is that suppose kelly took 12 calls, john took 11 calls, matt took 10 calls, i want a formula which will only collect top five names who have taken maximum calls and should give information of those call takers and no of calls in different column. I will give you example once again Column A Column B John 11 Matt 10 Pat 2 Kelly 12 Keith 3 Judieth 4 July 9 Polly 5 Cat 4 Micheal 8 Peter 4 Now in a separate sheet I have two columns that is column A and Column B named Top 5 Names and top 5 counts, i want a formula which will look at the above data and give me the information the way it is given below. Is it possible ? Column A Column B Top 5 Names Top 5 Counts Kelly 12 John 11 Matt 10 July 9 Micheal 8 Please help Chintu..... -- chintu49 ------------------------------------------------------------------------ chintu49's Profile: http://www.excelforum.com/member.php...o&userid=18631 View this thread: http://www.excelforum.com/showthread...hreadid=374783 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF COMBINATION?? | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |