Excel help - Extract Top3 performer Data

[Mallesh23]

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
	A	B	C	D	E	F	G	H	I
1	Date(DD/MM/YYYY)	Emp Perfomance		EMP Name	Top Performer Appereance for November	Date(DD/MM/YYYY)	Top1(★★★)	Top2(★★)	Top3(★)
2	08/11/2020	MS Dhoni★★★		Rohit Sharma	2	08/11/2020	MS Dhoni	Virat Kohli	Rohit Sharma/Sachin Tendulkar
3	08/11/2020	MS Dhoni★★★		MS Dhoni	2	09/11/2020	MS Dhoni/Virat Kohli	Rohit Sharma	Sachin Tendulkar/Manish Pandey
4	08/11/2020	Virat Kohli★★		Virat Kohli	2
5	08/11/2020	Rohit Sharma★		Sachin Tendulkar	2
6	08/11/2020	Sachin Tendulkar★		Sehwag	0
7	09/11/2020	MS Dhoni★★★		Manish Pandey	1
8	09/11/2020	Virat Kohli★★★		Yuvraj	0
9	09/11/2020	Rohit Sharma★★
10	09/11/2020	Sachin Tendulkar★
11	09/11/2020	Manish Pandey★
Sheet1

Thanks
mg

 

[Mallesh23]

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


Thanks
mg

 

[abdelfattah]

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 ?

 

[sandy666]

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

 

[abdelfattah]

how i know it is installed ?

 

[sandy666]

The Complete Guide to Installing Power Query - Excel Campus

Learn what version you need to get Power Query and instructions on how to install this free add-in from Microsoft.

www.excelcampus.com

 

[alansidman]

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.