Learn more about FILTER & SORT functions.SORT() function sorts these names in alphabetical order.įinally TEXTJOIN() is used to combine all names to one big text with comma & new line character between names. 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 |