1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Drop down for whole numbers and N/A?

I am looking to create a box that allows for whole numbers or N/A.

I can data validation, set to whole remove error message. But this means people can write anything in there.

The numbers are extremely varied so creating a list of numbers doesn’t woke.

I’m thinking maybe an if then statement maybe?

I

submitted by /u/kassiormson124
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article