Arranging the Grades

I've two tables, one Grades-

and other is Name

output should be like Julia wo has 88 marks which is between 80 and 89 so Grade should be 9, smantha 7 and so on.

Output table will look like

I tried using Union, but no success

Please suggest a solution.

Thanks

Amit

Developer

Preparation

Accepted answers

Here is how you can do it.

Workflow:

Hope this helps : )

Can you provide the workflow with data or the data in excel file. So that we can work with it 🙂

If the range is 10 you can do something like this.

Workflow:

Hope this helps : )

I've shared the workflow.😉