Forum Discussion
Solved
Please help! Data > Get Data (from File) is driving me insane
I am forced to use Get Data to work around the insane situation with Excel reformatting dates (a centuries old problem that has been discussed to death and still no resolution since the dawn of time ...
ChrizK ISBLANK() requires the cell to contain absolutely nothing. I suspect that your transformation to Date and then to Text returns something to the cell that just isn't visible. Try this in stead:
=IF(cell="","PASS","FAIL")On the other hand, you say that you are "forced to used Get Data". I would want to suggest to do all your validations with "Get and Transform Data" (a.k.a. Power Query), in stead of working with all sorts of formulae in Excel. Power Query is extremely powerful in formatting, matching and more. But since I haven't seen your data, I may be mistaken.
TBH I have never touched Power Query (at least, not that I know). Dare I say, I don't even know what it is (will need to do some googling)!
NB I am only transforming the date column, however, if I view the columns in the Transform operation, I can see that each column with no content is identified as Text (not sure why it is General at the point it is loaded).
Thank you for your quick reply ...I will try "" 🙂
NB I am only transforming the date column, however, if I view the columns in the Transform operation, I can see that each column with no content is identified as Text (not sure why it is General at the point it is loaded).
Thank you for your quick reply ...I will try "" 🙂
ChrizK ....... provided you're not a Mac. If so, PQ will not (yet) work for you.