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