title: Allow duplicate names in google sheets data validation
body: <p>I'm requiring duplicate names within a sheet to be read by data validation.</p>
  <p>Currently at the minute, if a duplicate first name appears, it won't appear within the drop down menu even if the last name and other data is different, if it views the first column to be a duplicate it won't be an option to select.</p>
  <p>Example:</p>
  <pre><code>John Smith  01/01/2000 - 22/02/2022
  John Doe    05/05/2005 - 15/01/2021
  John Robert 18/08/1970 - 12/11/2021
  
  It will only read the top one as the second and third &quot;First name&quot; is a duplicate.
  </code></pre>
  <p>Here is the link to the test sheet to view what's set up currently - <a href="https://docs.google.com/spreadsheets/d/1P-SZh3z0-p7yD0YQYij_7qVZjY7yjRENXbrja4ySrLg/edit?usp=sharing" rel="nofollow noreferrer">CLICK ME</a></p>
  <p><em>Please note the link allows editors for the next hour then it'll be marked as view only</em></p>
  <p>Any and all help is highly appreciated.</p>