Hi excelchallenge,

Welcome to the forum.

You can use =if(isblank(.... ) function in your data set... or you can use =na() ...
If this is not as what you are looking for... suggest you to upload the excelworkbook.. thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>