![]() We are using FILTER() function to filter down the talent table to all candidates who have given performance (E8) and potential (D5) values The above formula assumes E$8 has the performance rating value and $D5 has potential. In the top left cell, use the below formula. Note: this method requires Excel 365 with dynamic array functions. ![]() ![]() If you have Excel 365 and access to dynamic array functions like FILTER(), you can use formulas to generate the 3×3 talent map grid.Įlse, you can use Pivot Tables to generate the talent map grid. Step 2: Create the talent map 9 box grid visual Feel free to add things like department or team names. At the very least, you want staff name, performance and potential. In a blank spreadsheet, gather the data about your staff. Step 1: Gather data about performance and potential of your staff
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |