Excel tip – is X in the list?

Today’s #TipTuesday is a detour from my recent SmartList tips for Dynamics GP, and I’m going back to Excel for this one.

I have been working on a project recently where some data validation is needed to ensure that user-entered data on some forms is valid. I want to have some visual validation for Accounting when reviewing these forms prior to uploading the data into Dynamics GP to…

Continue Reading Jen Kuntz’s Article on their blog

Excel tip – is X in the list?

A tip in Excel for data validation where the out-of-the-box data validation may not be suitable. This example is validating using COUNTIF to validate data input.

Blog Syndicated with Jen Kuntz’s Permission