Forum Discussion
gillgill
Jul 17, 2025Copper Contributor
Preventing duplicate selections
Hi all! What I'm trying to do: Once a company is selected on one employee's sheet, it's removed from the dropdown lists on all the others, preventing duplicate selections. Background: I'm buil...
SergeiBaklan
Jul 19, 2025Diamond Contributor
Let assume you have Company List sheet as
and in each employee sheet (in the sample from A to C) data starts exactly from A5
With that we may generate spill for validation which has values from Company List not repeating in employee sheets
=UNIQUE( VSTACK( TOCOL( $B$5:$B$70, 3), TOCOL( VSTACK('A:C'!$A$5:$A$70),3 ) ),,1)
and use this spill in data validation as
Please check in attached file
- gillgillJul 21, 2025Copper Contributor
Thank you! That ended up working.