Array Returning "0" value

[BijanBorazjani]

Good Afternoon,
I built an array function a long time ago and moved it to a new sheet/workbook. The issue i am having is that now the last unique value is posting as a 0. Any ideas on how to get it to just leave the last cell blank?

Array Formula
=IFERROR(INDEX('Weekly Input'!$C$3:$C$1000, MATCH(0, COUNTIF($B$4:B4, 'Weekly Input'!$C$3:$C$1000), 0)), "")

Tribute Tracking and Planning Form - TMCSW Bijan Copy.xlsx
	A	B	C	D
1	January
2	Family Name	DoD	Location	Notes
3	John Smith	2/3/2024	Seviere	Pre Need
4	Jane Doe	2/4/2024	Ireland
5	Steve Parker	2/5/2024	Tribute SW
6	Ray John	2/5/2024	Seviere
7
8
9
10
Weekly Input

Tribute Tracking and Planning Form - TMCSW Bijan Copy.xlsx
	B	C	D	E
3	2024	Q1
4		Jan	Feb	Mar
5	Seviere	2	-	-
6	Ireland	1	-	-
7	Tribute SW	1	-	-
8	0	0
9
10
11
12			5	5
13			4	4
14			-	-
15			-	-
16	Average	1	5	5
2022

Cell Formulas
Range	Formula
B5:B15	B5	=IFERROR(INDEX('Weekly Input'!$C$3:$C$1000, MATCH(0, COUNTIF($B$4:B4, 'Weekly Input'!$C$3:$C$1000), 0)), "")
C5:C15	C5	=IF(B5="","",COUNTIF('Weekly Input'!$C$3:$C$1000,B5))
C16:E16	C16	=AVERAGE(C5:C15)
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Fluff]

Clear the formula in col B & in B5 use

=UNIQUE(FILTER('Weekly Input'!$C$3:$C$1000,'Weekly Input'!$C$3:$C$1000<>""))

 

[BijanBorazjani]

Clear the formula in col B & in B5 use

=UNIQUE(FILTER('Weekly Input'!$C$3:$C$1000,'Weekly Input'!$C$3:$C$1000<>""))

Do you know if there is a way to use this with multiple columns. Eg: January is column c february is column H etc. basically offset every x number of columns

 

[Fluff]

How about

=LET(a,TOCOL(CHOOSECOLS('Weekly input'!$C$3:$BF$1000,SEQUENCE(,12,,5)),,1),UNIQUE(FILTER(a,a<>"")))

 

[BijanBorazjani]

How about

=LET(a,TOCOL(CHOOSECOLS('Weekly input'!$C$3:$BF$1000,SEQUENCE(,12,,5)),,1),UNIQUE(FILTER(a,a<>"")))

This worked absolutely beautifully! Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.