Categorising Excel Data using VLOOKUP

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
509 views
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Oct 14, 2010

How to categorise data into value bands. Much more elegant and maintainable than nested IFs, this technique enables you to allocate categories based on the values in a particular column. In the example, a list of people's ages is categorised into bands such as 17-39, 40-44, 45-50, etc.

Category:

Education

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (0)

Sign In or Sign Up now to post a comment!
Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more