Thread: Compare four columns in excel

hi,

I need to compare four columns data in excel. I am able to do this for two columns.

I have data as follows.

ppvt_min ppvt_max ppvt_mean ppvt_median observations MOM
143148 143148 143148 143148 1 -100
141843 141843 141843 141843 1 -100
119490 119490 119490 119490 1 -100
91915 91915 91915 91915 1 -100

basically, i am showing the data which are same across four columns. But i do have other records where in they are not same. I have more than 10 mil recs and can not do this manually.
Please help me with formulae of comparing these four columns.

i use below forulae for comparing two columns,

if(a=b,true,false)

Thanks,
VIJ

=and(a1=b1,b1=c1,c1=d1)

Thanks, a ton. Both the formulae works according to my need.

Keep providing solutions, which really makes our life easier.

Thanks, again .
VIJ