Output except 1

[coolsac12]

Hi all,

I want output from column A to column B but I dont want 1 as output.
I have attached the sheet.

Thanks & regards,
coolsac12

 

[Hui]

B2: =IFERROR(IF(COUNTIF(A:A,"<>"&1) < ROWS($E$2:E2), "", INDEX(A:A, SMALL( IF($A$2:$A$8 <>1, ROW( $A$2:$A$8)), ROW(A1)))),"") Ctrl+Shift+Enter

Copy B2 down to B8

Read about how this works at:
http://chandoo.org/wp/2011/11/18/formula-forensics-003/

 

[coolsac12]

B2: =IFERROR(IF(COUNTIF(A:A,"<>"&1) < ROWS($E$2:E2), "", INDEX(A:A, SMALL( IF($A$2:$A$8 <>1, ROW( $A$2:$A$8)), ROW(A1)))),"") Ctrl+Shift+Enter

Copy B2 down to B8

Read about how this works at:
http://chandoo.org/wp/2011/11/18/formula-forensics-003/

Thank you @Hui ,

I got the output.