Use data from unique formula for another formula and have the same number of rows

[CV12]

Hello,

In this sheet I am using the unique formula to find unique values in column A. The unique values are stored in column E. Now in column F I would like to have the unique value +1 (Just to keep it simple in this example).
Is there a way to always have the same number of rows? If the unique values are 20 rows for example, I would like to have 20 rows exactly in column F to.

Thanks in advance!

Book2
	A	B	C	D	E	F	G
1	1				1	2
2	2				2	3
3	3				3	4
4	4				4	5
5	5				5	6
6	6				6	7
7	7				7	8
8	8				8	9
9	9				9	10
10	10				10	11
11	11				11	12
12	12				12	x
13	13				13	x
14	14				14	x
15	15				15	x
16					0	x
17
Sheet1

Cell Formulas
Range	Formula
E1:E16	E1	=UNIQUE(A1:A40)
F1:F11	F1	=SUM(E1+1)
Dynamic array formulas.

 

[johnnyL]

How about:

= IF(E1<>"",E1+1,"")

Drag that formula down the F column as far as you might expect to see results in the E column.

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F
1	1				1	2
2	2				2	3
3	3				3	4
4	4				4	5
5	5				5	6
6	6				6	7
7	7				7	8
8	8				8	9
9	9				9	10
10	10				10	11
11	11				11	12
12	12				12	13
13	13				13	14
14	14				14	15
15	15				15	16
16
Main

Cell Formulas
Range	Formula
E1:E15	E1	=UNIQUE(FILTER(A1:A40,A1:A40<>""))
F1:F15	F1	=E1#+1
Dynamic array formulas.

 

[CV12]

Adding the # was the simple issue, thanks Fluff!

 

[Fluff]

Glad we could help & thanks for the feedback.