using input field in one cell to control number of rows below it

G

Guest

Hi,

how can I get a number which is entered into a cell to
provide a number of other for inputing and then on the next
sheet create a knockout tournament draw also based on the
number entered in that same cell.

eg. number of participants - 8
participant 1 -
participant 2 -
etc.
 
F

Frank Kabel

Hi
try the following formula (if I understood this correctly):
1. sheet1, cell A1: enter the number of participants

2. sheet2, cell A1 enter the following formula:
=IF(ROW(1:1)<='sheet1'!$A$1,"participant " & ROW(1:1),2")
and copy this formula down
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check value range, then return spesific number? 2
Match and delete rows on two different sheets from reference numbers 4
trouble with (complicated) vlookup searching another workbook 2
After I reset my Games they get scambled. Conditional Formatting orMacro messed up somewhere 1
Seek recommendation, idea or solution for creating training manuals 0
What Multiple functions do I need? 2
Fill cell colour based on input in another cell 2
one cell in a row contains a number 8

Top