Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Show text data in excel pivot table | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
How do I compare 2 sets of data and highlight differences? | Excel Worksheet Functions | |||
How to convert columns of data to one column of text | Excel Worksheet Functions |