RE: Compare 2 sets of data

Thank you i will try this method. I just thought there would be an easier way
to select the entire range A2:I91 to compare to the other range J2:R91.

Thanks again.

"Eduardo" wrote:

Hi Juan,
If you want to compare column A with F, you have to be positioned in Column
F, go to conditional formating, enter where the cell vallue is not equal to
A1, then go to format and choose fill and select the color you want press
ok , you should be able to see in preview the color choosen, then press ok
again. if the value doesn't match it will color the cell. Do once for each
column in the second serie of data and then copy the format down to the last
cell

"Juan" wrote:

Wow thank you Eduardo, that worked. Although i tried a conditional formual to
highlighted each cell that is different between the 2 ranges and it seems to
compared the cell on one row to the cell on the row above from the other
range.
I used the the formulas below with the named ranges of Aeries and SEIS.

=COUNTIF(SEIS,A2)=0
=COUNTIF(Aeries,A2)=0

"Eduardo" wrote:

Hi Juan,
here is the formula that will enter the X if any of the values doesn't match

=+IF(AND(A3=F3,B3=G3,C3=H3,D3=I3,E3=J3),"","X")

If you want to highlight the cell where the information doesn't match use
the conditional formating

"Juan" wrote:

I have 2 sets of data that i will place side by side and each record will
display on each row rather than columns. They will consist of the the same
amount of columns across. Example - ID, Last Name, First Name, Enter Date,
disability Code placed on row 1

I want to compare the first range of 5 columns on the first row to the next
5 columns on the same row. Ideally i would like to have an X placed on the
11th column as a sign of a discrepancy in data (If enter date in the first
range is different from the second set or Disability Code is different and so
on).

Would that be possible or would it be simpler to have something where the
different fields are highlighted. If D1 does not equal I1 or E1 does not
equal J1.
.

Relevant Pages

  • RE: Compare 2 sets of data
    ... "Juan" wrote: ... If you want to compare column A with F, you have to be positioned in Column ... F, go to conditional formating, enter where the cell vallue is not equal to ...
    (microsoft.public.excel.worksheet.functions)
  • Help with difference in time macro
    ... First of all I want to say this is my first time here and I am on my ... Compare H with system date and insert the difference in "I" ... the background of the cell should be colored in RED. ... This is based on a 24/5 clock (meaning it does not include Saturday and ...
    (microsoft.public.excel.programming)
  • RE: Compare 2 sets of data
    ... If you want to compare column A with F, you have to be positioned in Column ... F, go to conditional formating, enter where the cell vallue is not equal to ... range is different from the second set or Disability Code is different and so ...
    (microsoft.public.excel.worksheet.functions)
  • RE: comparing componants of tables
    ... jimbo, I have to make several assumptions to provide this solution. ... Second assumption, when you do comparisons, you're wanting to compare one ... weights, and not weight for one person to belt size for someone else. ... Here is the basic formula that I placed into cell B18 of this comparison ...
    (microsoft.public.excel.newusers)
  • Advanced Swong jTable cells
    ... I'm writing swing application that shall compare differences between ... public Object getValueAt(int rowNumber, int columnNumber) { ... but i would like to improve cell design ... ...
    (comp.lang.java.gui)
Quantcast