davids4500
New Member
- Joined
- Jan 14, 2023
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
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.