Index/Match to only return numbers which are a certain length

[pauldaddyadams]

Hi,

I have the array formula:
=IFERROR(INDEX('Balance Sheet New'!$C$7:$C$55,MATCH(1,--(COUNTIF($E$5:E5,'Balance Sheet New'!$C$7:$C$55)=0),)),"")

Which shows unique entries from a list on the sheet "Balance Sheet"

Is there any way I can in which I can restrict it further to only include numbers which are 6 charters in length only?

e.g. the list:
113000
22.1
22.2
234200
0
210000

Would become:
113000
234200
210000

Paul

[:) Sixthsense :)]

In E6 Cell - Array Formula - Requires CTRL+SHIFT+ENTER


=IFERROR(INDEX('Balance Sheet New'!$C$7:$C$55,MATCH(1,--(COUNTIF($E$5:E5,IF(LEN('Balance Sheet New'!$C$7:$C$55)>=6,'Balance Sheet New'!$C$7:$C$55,0))=0),0)),"")


Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.

[pauldaddyadams]

Hi

Thanks for replying

I couldnt get it to work with the formula.

I have uplaoded an example to show what its doing and what i require.

[:) Sixthsense :)]

Please check the attached file