DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 1 of 1

Thread: Help with validating data in excel

  1. #1
    Join Date
    Dec 2005
    Posts
    1

    Help with validating data in excel

    Hey,

    I have this problem where I want to validate 2 set of data that aren't sorted and are in different format in excel.

    Example of 1st set of data:
    x3
    y3
    z3
    x1
    y1
    x2
    y2
    z2

    Example of second set:
    x1 y1
    x2 y2

    What I want to do is have the 2nd set check each row for a matching X in set 1, and check the row beneath it to see if the Y also matches. In the first set, the corresponding Y is always the row below the X.

    How would I go about doing this? I can use conditional formatting to see if the values of the 2nd set matches the values in the first, but I need something that matches it up. The values are strings.

    Can anyone help me out?
    Last edited by Haydee; 12-17-2005 at 03:23 PM.

Similar Threads

  1. Data Validation in excel files
    By daRkSIEM in forum VB Classic
    Replies: 0
    Last Post: 11-01-2005, 10:06 AM
  2. oracle data into excel sheet
    By deepali in forum Java
    Replies: 0
    Last Post: 09-27-2005, 05:23 AM
  3. Matching data macro in VBA Excel
    By Werner in forum VB Classic
    Replies: 2
    Last Post: 06-15-2005, 02:13 PM
  4. Re: maintaining data when importing into excel
    By denis pelletier in forum XML
    Replies: 8
    Last Post: 08-08-2002, 09:02 PM
  5. Retrieving Excel data
    By Cedric Thirion in forum VB Classic
    Replies: 0
    Last Post: 04-13-2000, 10:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center