Hi guys,
Please find attached the sample excel file I have been working on so far.
Can anyone help me to get rid of the #N/A from the cells that does not match the criteria?
I've tried ISNA already and it didn't seem working properly on my excel function.
Any help will be greatly appreciated.
Plus, any idea why column K generate '0' value?
1. To get rid of #N/A
2. And also to get rid of '0' from column K
Cheers,
Bookmarks