Tag Archives: snowflake

Check Excel Data for Blank and Invalid Values (Part 2 – Sort)

basic data analytics1As I explained in the last Excel post, you can check for blank and invalid data in Excel several ways.

In this post, I will focus on the insights and issues encountered by sorting each column from A to Z and then Z to A.

Sounds pretty simple, but I’m willing to bet you will be surprised to learn a thing or two…

For a list of the reasons why you must validate data before analyzing it, see Why You Must Validate Data.

Continue reading

Advertisements

2 Comments

Filed under Data Analytics, How to..., Technology