5
\$\begingroup\$

I want to get a review on some Excel (Non-VBA) data validation formulas I have applied to some columns in a spreadsheet. Is this acceptable? I feel like it will get closed on SO because I'm really looking for input on some limitations I'm experiencing in Excel.

Also, what I'm trying to accomplish is really simple (ensure duplicates don't exist across several rows) and probably doesn't need any test data, but if I had to provide some test data, how would I go about doing that?

\$\endgroup\$
  • \$\begingroup\$ Short answer, yes. You should still ensure it covers all the bases that regular code reviews require, working formula, etc. \$\endgroup\$ – rolfl Mar 11 '15 at 16:43
  • \$\begingroup\$ To answer the second part of your question, you can make tables using MathJax. \$\endgroup\$ – 200_success Mar 11 '15 at 16:45
  • \$\begingroup\$ Sweet. I checked but couldn't find a duplicate before posting so it may be helpful to keep this around for questions that use "Excel" instead of "spreadsheet" \$\endgroup\$ – moarboilerplate Mar 11 '15 at 16:45
  • 1
    \$\begingroup\$ I really recommend looking at the main site question linked in my meta question. The Mug did a great job of making it a good question. It wasn't in that state when it arrived. \$\endgroup\$ – RubberDuck Mar 11 '15 at 16:50

Browse other questions tagged .