Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    India
    Posts
    41

    Unanswered: Need to compare the list of values

    Hi EveryB

    I need to compare a list of datas.

    I have got 4 colomns of data as described below

    server1-filesize server1-filename server2-filesize server2-filename

    I want to compare the the filenames and its size present in the server 1 with the files in the server2. and want to list down the files seperately.

    Thanks in Advance,
    Arun

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    How i think i would do this is to use the VLOOKUP Function,
    Create a new file with the list of files and sizes from Server1 on a new sheet

    then as long as everything in the 2 names are identical then use VLOOKUP to lookup the list in server2

    Hope that makes sense
    Dave

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •