I am using Mode for a series of non-consecutive cells in a row. When text or blanks occur, I get a #value error. How do I get rid of it?
Md Ariful Islam
বিএসসি(সিএসই)
,
এমবিএ(মার্কেটিং)
4 views
1 Answers
Dr. Md Rushad Rahman
এমবিবিএস(আরপিএমসি)
,
পিজিটি(মেডিসিন)
You can't. You need to choose your data so that there are no empty cells (or use a bit of VBA to exclude empty cells).
4 views
Answered