Getting corresponding data
I have list of student name and their Total Marks in the column. In the row, we have
• I class (above 360 marks)
• II class (300 - 360 marks)
• III class (240 - 299) marks
• Fail ( below 240 marks)
Based on the Total marks, the name of student should appear in the relevant column.
Last edited by vrnataraj; 04-29-2011 at 08:53 AM.
Please post a sample workbook.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
now i have loaded the example.....
Try these in C2:F2, respectively:
=IF(B2>=360,A2,"")
=IF(AND(B2>=300,B2<360),A2,"")
=IF(AND(B2>=240,B2<300),A2,"")
=IF(B2<240,A2,"")
and then copy them all down the table.
you may need to adjust the operators, >, >=, <, <= depending on where you want to include/exclude the upper/lower bounds of each range.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Do you mean, based on the total marks, the Class type should appear?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks