This function is used at the time when we have to categories our data into some systematic order like groups.
So, to understand how to categories your data into groups, let’s take an example:
As you can see in the image above, we have taken a bunch of roll nos. and their marks scored out of 100 in some subject.
Now, to categories the marks into groups, we will input the formula:
The following formula requires lookup value, table array, column index number, and range lookup.
Let’s begin with the lookup value, our lookup value is the marks in this example as this is the value that we want to organise in groups.
Then comes the aspect of table array.
Table array is the table according to which we will be following the things in the near future.
Column index number is the aspect which is to be chosen from the table array only. As we want our marks to be categorised in the group form, so our column index number will be 2, as it’s the second column in the table array which is highlighting the groups.
Then comes the range lookup.
In this, there will be two options True or False, this is generally an additional thing in the formula so all you have to do is press on “TRUE”.
So, overall the formula becomes as:
Now all we have to do is press enter, and drag the same formula down so that you don’t have to go through the formula again and again.
So, here’s your data on the screen. The marks are successfully converted into groups.
It’s easy, isn’t it?