# Select list in the second row to be unique from first row **URL:** \ **Category:** Ask the Community\ **Created:** [November 7, 2022, 8:22am UTC](https://connect.superhuman.com/t/select-list-in-the-second-row-to-be-unique-from-first-row/35143 "2022-11-07T08:22:43Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Korn\_Tris](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/korn_tris/32/24921_2.png) [@Korn\_Tris](https://connect.superhuman.com/u/Korn_Tris)\ **Post date:** [November 7, 2022, 8:22am UTC](https://connect.superhuman.com/t/select-list-in-the-second-row-to-be-unique-from-first-row/35143/1 "2022-11-07T08:22:43Z")
![1667808664590](https://global.discourse-cdn.com/coda1/original/3X/6/b/6b17c555adaada1735474f6e25fb2918660659ae.jpeg) ![1667808649053](https://global.discourse-cdn.com/coda1/original/3X/e/2/e2784669636bc0fe52bdc2df18bea4611cbd58eb.jpeg) Hello . I have A table for students and i have B table for class. Now in table B i have a column with multi select student list from table A. What i want is that if the students name are already selected in first row, I want it to be unique and cannot be select in second row . Any formula to filter this ---
**Author:** ![Quentin\_Morel](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/quentin_morel/32/31407_2.png) [@Quentin\_Morel](https://connect.superhuman.com/u/Quentin_Morel)\ **Post date:** [November 7, 2022, 9:13am UTC](https://connect.superhuman.com/t/select-list-in-the-second-row-to-be-unique-from-first-row/35143/2 "2022-11-07T09:13:44Z")
Hi @Korn_Tris If I understand well, you don’t want to be able to select a student twice, \> if a student is already in Test Class 1, you dont want to have it in Test Class 2, right ? If Yes 🙂 - Start to check if a people is already in a test class with this formula. If coda detect your students once in the test class list, the checkbox qill go to “true” ![image](https://global.discourse-cdn.com/coda1/original/3X/d/6/d65f5389ac29a386c1c61c10d6bebdae9707d35a.png) - Then, custom filter your lookup (in option settings) in class table, you only want people that are not already in a class \> witch checkbox “already in a class” not true ![image](https://global.discourse-cdn.com/coda1/original/3X/3/8/38070620e526dfb704d8559444747391faf23bdb.png) - There you go, you will have only “available” people for new class test ![CPT2211071009-998x810](https://global.discourse-cdn.com/coda1/original/3X/e/f/ef93810e078293f5cf5ab16f795dc044457e4377.gif) ---
**Author:** ![Christiaan\_Huizer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/christiaan_huizer/32/28269_2.png) [@Christiaan\_Huizer](https://connect.superhuman.com/u/Christiaan_Huizer)\ **Post date:** [November 7, 2022, 5:46pm UTC](https://connect.superhuman.com/t/select-list-in-the-second-row-to-be-unique-from-first-row/35143/3 "2022-11-07T17:46:16Z")
hi @Quentin_Morel , @Korn_Tris you might also want to consider this in the LookUp Option `currentvalue. Contains(BibleStudyClass.StudentSelection).Not()` cheers, Christiaan ---
**Author:** ![Korn\_Tris](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/korn_tris/32/24921_2.png) [@Korn\_Tris](https://connect.superhuman.com/u/Korn_Tris)\ **Post date:** [November 10, 2022, 11:57am UTC](https://connect.superhuman.com/t/select-list-in-the-second-row-to-be-unique-from-first-row/35143/4 "2022-11-10T11:57:15Z")
what do you mean by lookup option? if it’s LOOKUP then it’s not select list ---
**Author:** ![Quentin\_Morel](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/quentin_morel/32/31407_2.png) [@Quentin\_Morel](https://connect.superhuman.com/u/Quentin_Morel)\ **Post date:** [November 10, 2022, 12:03pm UTC](https://connect.superhuman.com/t/select-list-in-the-second-row-to-be-unique-from-first-row/35143/5 "2022-11-10T12:03:03Z")
Hey @Korn_Tris @Christiaan_Huizer meens in the option settings here, that will filter your lookup value. With his formula, you will only have available people. Different (more elegant) solution than mine, but same results ! Right there ![image](https://global.discourse-cdn.com/coda1/original/3X/2/f/2ff6343e9e0e0bb9c5b35e3acbd9513b395fc4d4.png) ---
**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\ **Post date:** [February 8, 2023, 12:03pm UTC](https://connect.superhuman.com/t/select-list-in-the-second-row-to-be-unique-from-first-row/35143/6 "2023-02-08T12:03:12Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.