Forum Discussion
Flag Outliers in an Excel Datafile Before Export
Hi cool2021
you could use a formula in a separate column that flags values based on a rule that you need to define.
This example would flag values below 80% or above 120% of the average with *
=IF(OR(A2<AVERAGE($A$2:$A$25)*80%,A2>AVERAGE($A$2:$A$25)*120%),"*","")
Is that what you need?
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.