Forum Discussion
Flag Outliers in an Excel Datafile Before Export
How do I create a new column of data in an Excel datafile flagging outlier values and then export that datafile so I can do more advanced modeling or analysis in SAS or SPSS? BUT....just using th...
Martin_Weiss thanks for the response. No, I actually want to do this without having any formulas in cells. But thanks for the response anyway.
Hi cool2021
but you wrote that you would need a new column with the flags, because conditional formatting obviousely does not get exported to a CSV.
So what exactly would you like to achieve?
Martin_Weiss that is okay. I figured it out. I used a VBA Macro to create the new column of data with a flag (eg. High Outlier, Normal, Low Outlier) for each record without having any formulas in the spreadsheet cells. Then, I could just export to .csv.