Group number lists into text based categories in Excel
on channel: AuditExcel Advanced Excel and Financial Model Training and Consulting
How to categorize a series of numbers into text categories in MS Excel. In this case it is employee performance reviews that are any number (including decimal numbers) from 1 to 10, which need to be placed into 5 possible categories being
- Unsatisfactory
- Inconsistent
- Effective
- Highly effective, and
- Exceptional.
The temptation is to use a nested IF, but VLOOKUP True is the correct way to do this as it allows you to find where the number would fit BETWEEN 2 numbers (even if a decimal).
------------------------------------------------------------------------------------------------------------------------------------------------------
✅- Free check of your Excel Skill Level- https://excel-skills-assessment.com/s...
🏅- Test employee Excel skill levels- https://excel-skills-assessment.com/e...
🏆- Improve you Excel Skill Levels- https://online-excel-training.auditex...
🇿🇦- Our main website- https://www.auditexcel.co.za/blogs/
------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 How to group numbers into categories
00:22 VLOOKUP works better for number categorization than nested IF
01:04 Employee rating numbers converted to performance categories
Watch video Group number lists into text based categories in Excel online without registration, duration hours minute second in high quality. This video was added by user AuditExcel Advanced Excel and Financial Model Training and Consulting 01 November 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 228 once and liked it 1 people.