Create unique list based on row and column criteria

[Rolly_Sefu]

Hello

I have the following formula: (array)
=INDEX($B$4:$AF$4;MATCH(0;IF(""<>$B$6:$AF$6;COUNTIF($A$17:$A17;$B$4:$AF$4);"");0))

I all works fine but, I would like to add a row criteria as well

this would mean that is will not be restricted to row 6.

Any ideas ?

Thank you.

 

[James006]

Hello,

You can always a new condition ... i.e insert a new If() inside the existing If() segment ...

HTH

 

[Rolly_Sefu]

Hello

Yeah that might work but I have a range off 1000 rows

 

[James006]

Hello

Yeah that might work but I have a range off 1000 rows

1'000 rows ... !!! Indeed this was explicit in your first message ....

Try to avoid array formulas ...when dealing with large spreadsheets ...