How to create auto updated sorted list?

[jb]

An excel sheet contains data of few employees.
Column A contains employee number, column b contains name of employee.
Column C contains present days of employees. Column D presents attendance percentage.
Column C is updated at end of every month.
Now a list is required to be prepared which will display employee number, employee name and attendance percentage in descending order of attendance percentage.

This list must be refreshed automatically when column C will be updated and due to that column D will also be updated.
I have tried to prepare such sorted list. But it is not giving me expected result.
If more than one employee has same attendance percentage, it shows same employee number and name in all rows having same attendance percentage.
How to solve this?
I am attaching sample sheet.

 

[Deepak]

Hi,

This might be a solution.

 

[Somendra Misra]

Hi Jb,

I would use Pivot Table for this task, as this is fast and will update automatically, see the attached file for the illustration.

Regards,

 

[jb]

Hi Deepak,
Your solution was perfect. Thanks for that.
But I do not understand the role of helper column as it generates same value as percentage column.
Can you plz tell me about it?

 

[jb]

Hi Somendra sir,
I gone thru your solution. But if I change attendance data, then the pivot table is showing changes.

 

[Deepak]

Hi Deepak,
Your solution was perfect. Thanks for that.
But I do not understand the role of helper column as it generates same value as percentage column.
Can you plz tell me about it?

Hi,

Actually it's not the same.
Change the number format to look for differences.

 

[Somendra Misra]

@jb

You need to update the source data range of Pivot Table to update it.

Regards,

 

[jb]

Thanks Deepakji for the clarification. I understood it. Thanks a lot.

 

[jb]

Thanks Somendra sir.