+ Reply to Thread
Results 1 to 3 of 3

random name extraction without repetition

  1. #1
    Registered User
    Join Date
    11-05-2018
    Location
    Ferrara
    MS-Off Ver
    2016
    Posts
    2

    random name extraction without repetition

    Hello everyone, I have a problem with managing the customer database for a competition that we have announced.

    For questions of privacy I reproduced the problem inspired by football.

    I would like to know if it is possible to create a formula that allows me to use the Enter key (WITHOUT MACRO) to randomly extract from a list of names without the Player2 repeating the name extracted for Player1.
    I enclose the file (for greater clarity) containing:
    1.Ruolo
    2. Characters
    3.Equipaggiamenti
    4.Partita (sheets in which an object (two for equipment) must be attributed to each player without repetitions). It is not repeated what was extracted from Player1 for Player2 but he could extract the same equipment three times. Can you suggest me how to correct.

    If anyone can help me I would be extremely grateful.

    Buongiorno a tutti, ho un problema con la gestione del database clienti per un concorso che abbiamo indetto.

    Per questioni di privacy ho riprodotto il problema ispirandomi al calcio.

    vorrei sapere se è possibile creare una formula che mi permetta attraverso il tasto invio (SENZA MACRO) di estrarre casualmente da una lista di nomi senza che per il Giocatore2 possa ripetersi il nome estratto per il Giocatore1.
    Allego il file (per maggiore chiarezza) contenente:
    1.Ruolo
    2. Personaggi
    3.Equipaggiamenti
    4.Partita (fogli in cui un oggetto (due per gli equipaggiamenti) deve essere attribuito ad ogni giocatore senza ripetizioni). Non si ripete quanto estratto dal Giocatore1 per il Giocatore2 tuttavia egli potrebbe estrarre tre volte lo stesso equipaggiamento. Riuscite a suggerirmi come correggere.

    Se qualcuno riuscirà ad aiutarmi gliene sarei estremamente grata.
    Attached Files Attached Files
    Last edited by AliGW; 11-05-2018 at 10:08 AM.

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: random name extraction without repetition

    May be this.
    In E5 then dragged across

    =INDEX(Equipaggiamenti!$A$1:$A$16,MATCH(LARGE(Equipaggiamenti!$B$1:$B$16,COLUMN(A$1)+((ROWS($B$5:$B5)-1))*COLUMNS($B$5:$E$5)),Equipaggiamenti!$B$1:$B$16,0))
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  3. #3
    Registered User
    Join Date
    11-05-2018
    Location
    Ferrara
    MS-Off Ver
    2016
    Posts
    2
    It really seems to work. Very interesting also the use of the + operator! I didn't know it.
    Thank you very much.!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA Macro to generate groups of 3 random numbers without repetition
    By gurunathblessings in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-16-2016, 09:59 AM
  2. Complex Random Cell Extraction checking multiple criteria
    By mpellica in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 09-17-2015, 01:00 PM
  3. [ITA] Estrazione dati con FILTRO su nuovo FOGLIO !
    By cybmatrix in forum Non English Excel
    Replies: 1
    Last Post: 05-11-2013, 07:01 PM
  4. [SOLVED] Sum without repetition
    By ratkiller in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-19-2013, 09:20 AM
  5. [SOLVED] Repetition
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-29-2012, 06:55 PM
  6. Random selection from list without repetition
    By WaveOfMutilation2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2010, 11:51 AM
  7. Random numbers without repetition
    By Mike7 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2008, 07:44 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1