Unique Filter returning a #calc error

[davids4500]

I am trying to use this formula:- =UNIQUE(FILTER(Chreosdata!N2:N3224,(Chreosdata!N2:N3224<>"")*(Chreosdata!H2:H3224= b32))). I need to add to the formula so that it does not return a #calc error if there are no relevant data in the H2:H3224 data fields.

 

[Peter_SSs]

Welcome to the MrExcel board!

Something like this?

=UNIQUE(FILTER(Chreosdata!N2:N3224,(Chreosdata!N2:N3224<>"")*(Chreosdata!H2:H3224= B32),"no data"))

The FILTER function has an optional final argument for what to return if no data is returned by the filter criteria.
=FILTER(array,include,[if_empty])
I have used that final argument above

 

[davids4500]

Welcome to the MrExcel board!

Something like this?

=UNIQUE(FILTER(Chreosdata!N2:N3224,(Chreosdata!N2:N3224<>"")*(Chreosdata!H2:H3224= B32),"no data"))

The FILTER function has an optional final argument for what to return if no data is returned by the filter criteria.
=FILTER(array,include,[if_empty])
I have used that final argument above

Dear Peter
Thank you so much Perfect...

 

[Peter_SSs]

You're welcome. Glad to help. Thanks for the follow-up.

 

[Joe4]

Note:
When marking a post as the solution, please mark the actual post that contains the solution originally, and not your own reply acknowledging that some other post is the solution.
I have updated this thread for you.