This array wont copy numbers in a column

[darksquare]

I have this array taken from the internet. It does copy all the texts in a column and take away blank cells. The problem is it does not copy the numbers in the column.

=LOOKUP("zzzzz",CHOOSE({1,2},"",INDEX(HS:HS,SMALL(IF($HS$5:$HS$219<>"",ROW($HS$5:$HS$219)),ROWS($HU$5:HU5)))))
This is followed by ctrl +shift and Enter

I am hoping to get the numbers too

[Phuocam]

Try: =INDEX(F:F,SMALL(IF($F$1:$F$11<>"",ROW($F$1:$F$11)),ROWS($H$1:H1)))
Enter with Ctrl+Shift+Enter

[MarvinP]

Hi darksquare and welcome to the forum,

Try this in H1 (CSE) and pull it down.

=LOOKUP(9^9^9,CHOOSE({1,2},"",INDEX(F:F,SMALL(IF($F$1:$F$11<>"",ROW($F$1:$F$11)),ROWS($H$1:H1)))))

[darksquare]

Thanks guys! I am really grateful with your help.

Phuocam- it worked on both text/number values. Thanks
Marvin- it worked on number values only. thanks

[darksquare]

Thanks guys! I am really grateful with your help.

Phuocam- it worked on both text/number values. Thanks
Marvin- it worked on number values only. thanks