Generate sequential numbered list

[WendyHubard]

Hello Guru's
Hoping you can help. I work in Law and are our current practice is to hand write Exhibit numbers on to little white sticky dots and attach to evidence photo's. There can be anywhere from 20 to 180 photo's and each set has to be replicated 16 times (14 Jurors plus Judges etc) - this equates to a lot of hand written little white dots. I'm trying to produce an excel list that will then be used as data for msword mail merge. I've attached a sample (using only 5 photo's and 4 sets). The EXHIBIT number is a sequential number and will need to be replicated 16 times before moving onto the next EXHIBIT Start Number (eg EXHIBIT number 643821 - will need to appear 16 times, then increment to 643822- will need to appear 16 times etc... Is this possible using formulas and some input parameters? many thanks in advance.

Merge Field Exhibit Number	How I want Column A to look		Exhibit Start Number	643821​
	643821​		Number of Photo's	5​
	643821​		Exhibit End Number	643826​
	643821​		Number of Sets Required	4​
	643821​
	643822​
	643822​
	643822​
	643822​
	643823​
	643823​
	643823​
	643823​
	643824​
	643824​
	643824​
	643824​
	643825​
	643825​
	643825​
	643825​
	643826​
	643826​
	643826​
	643826​

 

[FormR]

Hi, if I've understood correctly, you could try this, that uses the "start number", "end number" and "number of sets cells".

Book1
	A	B	C	D	E
1	Merge Field Exhibit Number	How I want Column A to look		Exhibit Start Number	643821
2	643821	643821		Number of Photo's	5
3	643821	643821		Exhibit End Number	643826
4	643821	643821		Number of Sets Required	4
5	643821	643821
6	643822	643822
7	643822	643822
8	643822	643822
9	643822	643822
10	643823	643823
11	643823	643823
12	643823	643823
13	643823	643823
14	643824	643824
15	643824	643824
16	643824	643824
17	643824	643824
18	643825	643825
19	643825	643825
20	643825	643825
21	643825	643825
22	643826	643826
23	643826	643826
24	643826	643826
25	643826	643826
Sheet1

Cell Formulas
Range	Formula
A2:A25	A2	=E1+INT((SEQUENCE(((E3-E1)+1)*E4)-1)/E4)
Dynamic array formulas.

 

[WendyHubard]

Oh my!!!! PERFECT. Thank you so much. You are a wizard!!!!

 

[FormR]

Hi, try to keep your replies in the open forum rather than by private message.

For Excel 2016 you could try this, note, you'll need to copy the formula down as far as might be required.

Book1
	A	B	C	D	E
1	Merge Field Exhibit Number	How I want Column A to look		Exhibit Start Number	643821
2	643821	643821		Number of Photo's	5
3	643821	643821		Exhibit End Number	643826
4	643821	643821		Number of Sets Required	4
5	643821	643821
6	643822	643822
7	643822	643822
8	643822	643822
9	643822	643822
10	643823	643823
11	643823	643823
12	643823	643823
13	643823	643823
14	643824	643824
15	643824	643824
16	643824	643824
17	643824	643824
18	643825	643825
19	643825	643825
20	643825	643825
21	643825	643825
22	643826	643826
23	643826	643826
24	643826	643826
25	643826	643826
Sheet1

Cell Formulas
Range	Formula
A2:A25	A2	=IF($E$1+INT((ROWS(A$2:A2)-1)/$E$4)>$E$3,"",$E$1+INT((ROWS(A$2:A2)-1)/$E$4))