View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deeptiman
 
Posts: n/a
Default how to compare 6 columns of text data

I have six databases which have the same measure in them.Now I have put all
the 6 databases measures in 6 column side by side.I want to match the six
columns so that the output is in that form where all the measures that are
not matching exactly to any of the six databses are highlighted or False
sttement comes up.Here is the example data

Databse1 Database 2 Database 3 Database 4.................

DollarSales Dollar Sales Dollar Sales $ Sales
Dollar Share Dollar Share Dollar Share Unit Sales



and so on for around 500 rows.What I want is that all the databases should
have the same naming convention....Dollar should be Dollar and not $.Moreover
each column data is not alligned with the other column.So I also want the
data to be aligned first for all columns and then compare all the six
databases and find oth that is there any changes.....


Help from anyone will be really very much appreciated as this work is
really eating up a lot of my tiime as I am doin it manually...