Skipping to next index match value when the formula returns "0"

[Bassie]

Hi,

I am trying to make a auto populating column depending on data from another column. However, when a value in the column is "" the index match will return a 0. Is there a way to skip this 0? I dont want the 0 to be a blank space but rather to move everything under the 0 1 cell up

Current formula:

=IFERROR(INDEX($C$17:$C$29,MATCH(0,COUNTIF($H$16:H16,$C$17:$C$29),0)),"")

I hope I made myself clear

Regards,
Bassie

 

[Fluff]

How about

=UNIQUE(FILTER(C17:C29,C17:C29<>""))

 

[Bassie]

How about

=UNIQUE(FILTER(C17:C29,C17:C29<>""))

I get an error that the FILTER function is not valid. Im on Excel 2019 if that is relevant

 

[Fluff]

Im on Excel 2019 if that is relevant

Then why does your profile show 365?

 

[Fluff]

How about

=IFERROR(INDEX($C$17:$C$29,AGGREGATE(15,6,(ROW($C$17:$C$29)-ROW($C$17)+1)/($C$17:$C$29<>"")/(ISNA(MATCH($C$17:$C$29,$H$16:H16,0))),1)),"")

 

[Bassie]

Then why does your profile show 365?

Im sorry that is my personal excel, I am not at work. Will change it

 

[Bassie]

How about

=IFERROR(INDEX($C$17:$C$29,AGGREGATE(15,6,(ROW($C$17:$C$29)-ROW($C$17)+1)/($C$17:$C$29<>"")/(ISNA(MATCH($C$17:$C$29,$H$16:H16,0))),1)),"")

This is madness, thank you so much!!

 

[Fluff]

You're welcome & thanks for the feedback.