Excel help - Extract Top3 performer Data

Mallesh23

Well-known Member
Joined
Feb 4, 2009
Messages
976
Office Version
  1. 2010
Platform
  1. Windows
Hi Team,

I Want to extract top 3 Performer from a list.

Name with ★★★.... Top1 performer
Name with ★★ ..... Top2 Performer
Name with ★ ...... Top3 Peformer


I Receive daily one file, from which I have to extract Top 3 performer.
sometimes we receive more than one top performance in TOP1/ Top2/ Top3.

We need to show both performance name with seperator.


Column A and B my input Columns , which I update Manually.
Column D is Constant Emp Name
Column E is Count no of Times emp name appeared in Column B.


Need Excel formula to show Top1,Top2 and Top3 Columns(G,H,I)
from Column A and B.

Attached are sample input with expected output Column (E:I) D is Constant.

Book1
ABCDEFGHI
1Date(DD/MM/YYYY)Emp PerfomanceEMP NameTop Performer Appereance for NovemberDate(DD/MM/YYYY)Top1(★★★)Top2(★★)Top3(★)
208/11/2020MS Dhoni★★★Rohit Sharma208/11/2020MS DhoniVirat KohliRohit Sharma/Sachin Tendulkar
308/11/2020MS Dhoni★★★MS Dhoni209/11/2020MS Dhoni/Virat KohliRohit SharmaSachin Tendulkar/Manish Pandey
408/11/2020Virat Kohli★★Virat Kohli2
508/11/2020Rohit Sharma★Sachin Tendulkar2
608/11/2020Sachin Tendulkar★Sehwag0
709/11/2020MS Dhoni★★★Manish Pandey1
809/11/2020Virat Kohli★★★Yuvraj0
909/11/2020Rohit Sharma★★
1009/11/2020Sachin Tendulkar★
1109/11/2020Manish Pandey★
Sheet1


Thanks
mg
 
Hi, veySeleMre,

Just cross checked , your code is working ,
I did somewhere mistake. thats the reason it has created problem, Now its working.


Millions of thanks for your help. ? (y)


Thanks
mg
 
Upvote 0

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, sandy i'm asking about your code where exactly put i know in normal case the code put in module but power query i no know i find many codes like your code because i no know how use it always ignore solution by power query s,o could you guide me, please ?
 
Upvote 0
hi, sandy i'm asking about your code where exactly put i know in normal case the code put in module but power query i no know i find many codes like your code because i no know how use it always ignore solution by power query s,o could you guide me, please ?
this is NOT VBA!!!

you need to have Power Query add-in installed, then open Blank Query and put M-code there
 
Upvote 0

Power-Query-Tab-of-the-Ribbon-Excel-2010.png
 
Upvote 0
Additional information on PQ

Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

- Follow this link to learn how to install Power Query in Excel 2010 / 2013.

- Follow this link for an introduction to Power Query functionality.

- Follow this link for a video which demonstrates how to use Power Query code provided.
 
Upvote 0

Forum statistics

Threads
1,213,515
Messages
6,114,080
Members
448,548
Latest member
harryls

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